Free ICDL-EXCEL Exam braindumps download (ICDL-EXCEL exam dumps Free)

QUESTION: 16

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

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

Answer(s): A

QUESTION: 17

Which one of the following formulas would be appropriate to calculate the monthly surplus for September in this worksheet?

=B5+B11
=SUM(B5:D5)-SUM(B11:D11)
= B5-B11
=AVERAGE(B5:D5)-AVERAGE(B11:D11)

Answer(s): C

Show Answer Next Question

QUESTION: 18

If the Enter key was pressed to accept the formula in cell B9, which of the following would be the result:

A #REF! error message
9.3
A #VALUE error message
A #NAME? Error message

Answer(s): D

Show Answer Next Question

QUESTION: 19

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.

=B3*C1
=B3*$C$1
=$B$3*$C$1
=$B$3*C1

Answer(s): B

Show Answer Next Question

QUESTION: 20

Which formula entered into B5 will calculate the total cost of a Colonial style chair (including delivery) and if copied to C5 will perform a similar calculation for the Metro style chair?

SUM($B$2:$B$4)+B8
=SUM(B2:B4)+$B$8
=SUM(B2:B5)+$B$8
=SUM(C2:C4)+$C$8

Answer(s): B

Show Answer Next Question

Free ICDL-EXCEL Exam Braindumps ICDL Excel Exam Questions 16–20 (page: 5)

QUESTION: 16

QUESTION: 17

QUESTION: 18

QUESTION: 19

QUESTION: 20

Free ICDL-EXCEL Exam Braindumps
ICDL Excel Exam Questions 16–20 (page: 5)