The ICDL L4 excel exam (ICDL-EXCEL) Free Practice Test

Question 1

Click on the location that selects all of the cells in row4.

A. Option A
Click on the gray area of the row 4

Correct Answer: A

Question 2

Preview the worksheet to see how it will look when printed.

A. Option A
File -> select print preview

Correct Answer: A

Question 3

Change the name of the worksheet from Sheet2 to Costs.

A. Option A
Right click on the sheet2 tab -> select rename -> type Costs

Correct Answer: A

Question 4

Change the formatting for the selected cells so they display with commas separating the thousands (e.g. 10,000).

A. Option A
Click the comma style from the formatting tool bar

Correct Answer: A

Question 5

If the Enter key was pressed to accept the formula in cell E8, what would appear in the cell?

A. #NAME!

B. 6,000

C. #VALUE!

D. #REF!

Correct Answer: C

Question 6

If the Enter key was pressed to accept the formula in cell E9, which of the following would be the result:

A. A #NAME! error message.

B. A Circular Reference error message

C. A #VALUE! error message.

D. A #REF! error message.

Correct Answer: B

Question 7

Save this workbook as a text file.

A. Option A
File -> save as -> in the save as type -> from the drop down list -> choose text (Tab delimited) -> save

Correct Answer: A

Question 8

Copy the entire Trees worksheet from this workbook into the Contracts workbook, so that it displays after Sheet1.

A. Option A
Right click on the Trees worksheet tab -> select move or copy -> check the create a copy -> from the to book drop down list select the Contracts workbook -> select (move to end) -> ok

Correct Answer: A

Question 9

Apply the Percentage style to the selected cells.

A. Option A
Click on the percent style tool from the formatting tool bar

Correct Answer: A

Welcome to TestSimulate

ICDL The ICDL L4 excel (ICDL-EXCEL) Free Practice Test