ICDL ICDL-Excel Quiz:1 Topic:1 Questions:1-5

Free Practice Mock Questions Set 1-5 (Quiz # 1) for ICDL-Excel Exam, according to official ICDL L4 Excel exam syllabus topic # 1

Question: 1

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

q1_ICDL-Excel

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

Show Answer

Question: 2

Change the formatting so the selected text automatically wraps onto a second line within the cell.

q2_ICDL-Excel

AOption A
Format -> cells -> select Alignment tab -> check the wrap text -> ok

Show Answer

Question: 3

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

q3_ICDL-Excel

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

Show Answer

Question: 4

Change the contents of cell B2 to the world Cost. Press Enter when you have finished.

q4_ICDL-Excel

AOption A
Select cell B2 -> type Cost -> press Enter

Show Answer

Question: 5

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

q5_ICDL-Excel

A=D12-D8

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

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

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

Show Answer

Quiz 1