Free ICDL-EXCEL Exam Braindumps (page: 7)

Page 6 of 23

Type a function into cell F8 that will calculate the smallest value in the highlighted range. Press the Enter key when you have finished.

  1. Type = min (F5:F7) -> press Enter

Answer(s): A



Which formula entered into B10 would find the total amount of rainfall that in the seven days?

  1. =SUMB3:B9
  2. =SUM(B3:B9)
  3. =(SUM)B3:B9
  4. SUM=(B3:B9)

Answer(s): B



Which formula would display 10% in cell C3 if the customer order quantity is over 300, and 0% if not.

  1. =IF(C3>300,10%,0%)
  2. =IF (B3>300, 10%, 0%)
  3. =IF (B3>300, 0%, 10%)
  4. =IF (B3<300, 10%, 0%)

Answer(s): B



Change the display of the numbers in the selected range from no decimal places to one decimal place.

  1. Click on increase decimal tool from the formatting tool bar

Answer(s): A






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

ICDL-EXCEL Exam Discussions & Posts