ICDL-Excel Exam Questions Instant Access - No Installation Required

Question 1

Delete row5 from this worksheet.

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

Answer : A

Question 2

Enter the value 521 in cell B5. Click any other cell when you have finished.

AOption A
Select B5 cell -> type 521 -> click any other cell

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

Use Microsoft Excel Help to access information on advanced filters.

AOption A
Help -> Microsoft excel help -> type advanced filters -> click search

Answer : A

Question 5

Which formula entered into C12 would calculate the number of recorded rainfall readings taken over the 3 weeks?

A=NUMBER(B4:D10)

B=COUNT(B4:B10)+(C4:C10)+(D4:D10)

C=COUNT(B4:D10)

D=NUM(B4:D10)

Answer : C

Question 6

Open the Samples.xls workbook that is in the My Documents folder.

AOption A
File -> open -> select the samples.xls -> open

Answer : A

Question 7

Which of the following formulas would calculate the Net Sales for January in this worksheet?

A=SUM(B2:B11)

B=B6 + B11

C=B6 - B11

D=SUM(B6:D6)-SUM(B11:D11)

Answer : C

ICDL L4 Excel ICDL-Excel Exam Questions