Free ICDL ICDL-EXCEL Practice Test & Real Exam Questions, Page 1

Page: 1 / 10
Total 88 questions

Close this workbook without closing the application.

A. Option A
File -> close

Discussion 0

Correct Answer: A Vote an answer

Which one of these combinations is used to indicate that cell C1 has an absolute reference?

A. #C#1

B. ?C?1

C. $c$1

D. /C/1

Discussion 0

Correct Answer: C Vote an answer

Automatically sort this list so that the highest mark displays at the top of the list.

A. Option A
Click the sort descending tool from the standard tool bar

Discussion 0

Correct Answer: A Vote an answer

Delete row5 from this worksheet.

A. Option A
Right click on the gray area -> select delete

Discussion 0

Correct Answer: A Vote an answer

You wish to reverse the last change you have made to this worksheet. Choose the appropriate command to do this.

A. Option A
Click on the undo tool from the standard tool bar

Discussion 0

Correct Answer: A Vote an answer

Freeze both the column A and row 1 titles in this worksheet.

A. Option A
Select the cell B2 -> window -> select freeze pane

Discussion 0

Correct Answer: A Vote an answer

Insert a blank row above row 5.

A. Option A
Select row 5 from the gray area -> Insert Rows

Discussion 0

Correct Answer: A Vote an answer

Insert a new worksheet into this workbook.

A. Option A
Right click on the sales worksheet -> select insert -> ok

Discussion 0

Correct Answer: A Vote an answer

Automatically adjust the height of Row 2 to fit its tallest contents.

A. Option A
Double click on the gray area between Row 2 and Row 3

Discussion 0

Correct Answer: A Vote an answer

Page: 1 / 10
Total 88 questions

Previous Page Next Page

Download Free ICDL ICDL-EXCEL Demo

Simply submit your e-mail address below to get started with our free demo of your ICDL ICDL-EXCEL exam.