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

Reveal Solution 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

Reveal Solution 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

Reveal Solution 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

Reveal Solution Next Question

Free ICDL-EXCEL Exam Braindumps (page: 6)

QUESTION: 17

QUESTION: 18

QUESTION: 19

QUESTION: 20

ICDL-EXCEL Exam Discussions & Posts