ICDL-EXCEL by ICDL Valid Free Exam Practice Test

Question 1

Display the Drawing toolbar in the Microsoft Excel application window.

A. Option A
View -> Toolbars -> Drawing

Correct Answer: A

Question 2

Which one of these combinations is used to indicate that cell C1 has an absolute reference?

A. $c$1 B. #C#1 C. ?C?1 D. /C/1

Correct Answer: A

Question 3

If row 4 is deleted, which formula will then be in cell B6?

A. =B3+B4+B5 B. =SUM(B3:B5) C. =SUM(B3:B7) D. =SUM(B3:B6)

Correct Answer: B

Question 4

Enter a formula in cell D4 that would calculate the Pre-tax Salary for Cathy Miller. Press the Enter key when you have finished.

A. Option A
Type = B4*C4 -> press Enter

Correct Answer: A

Question 5

Change the user name for this application to Carla Banks.

A. Option A
Tool -> options -> select General tab -> in user name type Carla Banks

Correct Answer: A

Question 6

Insert the file name field into the centre section of the header for this worksheet.

A. Option A
View -> select Header and Footer -> click custom Header -> click in the center section -> click on -> ok -> ok

Correct Answer: A

Question 7

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 8

View the above worksheet at 75% of its full size.

A. Option A
From the zoom tool in the standard toolbar use the drop down list and select 75%

Correct Answer: A

Question 9

Which formula entered into B10 would find the total amount of rainfall that in the seven days?

A. SUM=(B3:B9) B. =SUMB3:B9 C. =SUM(B3:B9) D. =(SUM)B3:B9

Correct Answer: C

ICDL The ICDL L4 excel - ICDL-EXCEL Exam Practice Test