ICDL Exam ICDL-Excel Topic 1 Question 26 Discussion

Actual exam question for ICDL's ICDL L4 Excel exam

Question #: 26
Topic #: 1

Which formula entered into E2 would calculate the total cost (including delivery) of a Barbados garden suite and, if copied down, would automatically calculate the total cost for the other two garden suites.

A=SUM(B2:D2)+$B$6

B=SUM(B3:D3)+$B$6

C=SUM($B$2:$D$2)+B6

D=SUM(B2:B42)+$B$6

Show Suggested Answer

Suggested Answer: A

by Carissa at May 05, 2022, 09:56 AM

Limited Time Offer

25%

Off

Get Premium ICDL-Excel Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!