Question No. 1

Print this worksheet.

AOption A
File -> print -> ok

Show Answer

Correct Answer: A

Question No. 2

Delete row5 from this worksheet.

AOption A
Right click on the gray area -> select delete

Show Answer

Correct Answer: A

Question No. 3

Delete the selected chart from this worksheet.

AOption A
Press Delete from the keyboard

Show Answer

Correct Answer: A

Question No. 4

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

AA #REF! error message

B9.3

CA #VALUE error message

DA #NAME? Error message

Show Answer

Correct Answer: D

Question No. 5

Which formula entered into E2 would calculate the total cost (including delivery) of a Barbados garden suite and, if copied down, would automatically calculate the total cost for the other two garden suites.

A=SUM(B2:D2)+$B$6

B=SUM(B3:D3)+$B$6

C=SUM($B$2:$D$2)+B6

D=SUM(B2:B42)+$B$6

Show Answer

Correct Answer: A

Free ICDL ICDL-Excel Exam Actual Questions

The questions for ICDL-Excel were last updated On Nov 22, 2024