ICDL-Excel Exam Practice Test Instant Access

Question 1

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

A#REF!

B6,000

C#VALUE!

D#NAME!

Answer : C

Question 2

Use the Find tool to find the name Kim Brown in this worksheet.

AOption A
Edit -> find -> type Kim Brown -> click on the find next button

Answer : A

Question 3

Cut the selected range and paste it into cell A1 on the worksheet entitled Qtr 3 in this workbook.

AOption A
Click on the cut tool from the standard tool bar -> select the Qtr3 sheet -> select cell A1 -> click on the paste tool from the standard tool bar

Answer : A

Question 4

Which TWO of the following would calculate the amount left to spend for March?

A=D12-D8

B=SUM(D4:D7)-SUM(D10:D11)

C=(D10:D11)-(D4:D7)

D=SUM(D10:D11)-SUM(D4:D7)

Answer : A, D

Question 5

Dragging the fill handle up to cell B3 will fill B3 with:

AEnvelopes

BPens

CPaper

DStamps

Answer : B

Question 6

Add a page footer with the text Confidential that will print at the botton left of all the pages in this woksheet.

AOption A
View -> Header and footer -> click on the custom footer -> type Confidential

Answer : A

Question 7

Change the white background colour of the chart to yellow.

AOption A
Click the arrow in the chart tool bar -> select the chart area -> click on the format Chart area tool -> select the yellow color -> ok

Answer : A

ICDL-Excel ICDL L4 Excel Exam Practice Test