ICDL-Excel Exam Practice Test Instant Access

Question 1

Change the name of the worksheet from Sheet2 to Costs.

AOption A
Right click on the sheet2 tab -> select rename -> type Costs

Answer : A

Question 2

Change this column chart to a Bar Chart.

AOption A
Click on the arrow in the chart type tool in the chart tool bar -> select bar chart

Answer : A

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

Select the range of cells A2 to B6. Launch the Chart Wizard, and choose a Pie Chart. Click Finish to submit your answer.

AOption A
Select the range -> insert -> select chart -> select pie in the chart type -> click finish

Answer : A

Question 5

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

Question 6

Adjust the page setup so that the entire contents of this worksheet will fit on 1 page wide by 3 pages tall.

AOption A
File -> select page setup -> delete number 4 and type 3 -> ok

Answer : A

Question 7

Move the entire Annuals worksheet into the Contracts workbook, so that it displays after the other worksheet.

AOption A
Right click on the Annuals worksheet -> select move or copy -> select Contracts from to book - > select move to end from before sheet -> ok

Answer : A

ICDL L4 Excel ICDL-Excel Exam Practice Test