Cisco®
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
Scrum
All Vendors
  2. Home
  3. Exams
  4. ICDL
  5. ICDL-EXCEL

Free ICDL-EXCEL Exam Braindumps (page: 6)

Page 5 of 23
PDF with 88 Questions

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

  1. =B5+B11
  2. =SUM(B5:D5)-SUM(B11:D11)
  3. = B5-B11
  4. =AVERAGE(B5:D5)-AVERAGE(B11:D11)

Answer(s): C



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

  1. A #REF! error message
  2. 9.3
  3. A #VALUE error message
  4. A #NAME? Error message

Answer(s): D



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.

  1. =B3*C1
  2. =B3*$C$1
  3. =$B$3*$C$1
  4. =$B$3*C1

Answer(s): B



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?

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

Answer(s): B






Post your Comments and Discuss ICDL ICDL-EXCEL exam with other Community members: