ICDL Exam ICDL-Excel Topic 1 Question 85 Discussion

Actual exam question for ICDL's ICDL-Excel exam

Question #: 85
Topic #: 1

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.

A=B3*C1

B=B3*$C$1

C=$B$3*$C$1

D=$B$3*C1

Show Suggested Answer

Suggested Answer: A

by Alita at Apr 25, 2024, 03:49 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Lorrine

10 months ago

Remember to select the Alignment tab for text wrapping.

upvoted 0 times

...

Hayley

10 months ago

I always struggle with Excel formatting questions.

upvoted 0 times

...

Roy

10 months ago

Yes, wrapping text in a cell can make data easier to read.

upvoted 0 times

...

Myra

11 months ago

I believe the answer is A.

upvoted 0 times

...

Hyun

12 months ago

I agree, formatting in Excel can be challenging.

upvoted 0 times

...

Mattie

12 months ago

I think this question is tricky.

upvoted 0 times

...

Pamela

1 years ago

Got it, thanks for the help!

upvoted 0 times

...

Tony

1 years ago

You can go to Format -> Cells -> Alignment tab -> check the wrap text box -> okay

upvoted 0 times

...

Pamela

1 years ago

How can we change the formatting to wrap text?

upvoted 0 times

...