ICDL-Excel Exam Practice Test Instant Access

Question 1

Which formula entered into C3 would calculate the Total Cost of Barrels for the Oil Deco company and if copied down would automatically calculate the Total Cost for all the other customers.

A=B3*C1

B=B3*$C$1

C=$B$3*$C$1

D=$B$3*C1

Answer : B

Question 2

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

AEnvelopes

BPens

CPaper

DStamps

Answer : B

Question 3

Save a copy of this workbook with the new name Accounts.

AOption A
File -> save as -> change the name Expense Claim into Accounts -> ok

Answer : A

Question 4

Use click-and-drag to select th range A4:C6 If necessary you can try again by repeating the click and drag action.

AOption A
Select cell A4 and drag to cell C6

Answer : A

Question 5

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 6

Which formula would display 10% in cell C3 if the customer order quantity is over 300, and 0% if not.

A=IF(C3>300,10%,0%)

B=IF (B3>300, 10%, 0%)

C=IF (B3>300, 0%, 10%)

D=IF (B3<300, 10%, 0%)

Answer : B

Question 7

Use the Replace tool to replace all occurrences of the name Jane Harris with Tim Snow.

AOption A
Edit -> select replace -> type Jane Harris in the find what -> type Tom Snow in replace with -> click replace all

Answer : A

ICDL-Excel ICDL L4 Excel Exam Practice Test