A festival organiser is preparing a costs spreadsheet for a small lantern parade. Column B contains the number of items ordered, column C contains the unit ...
Question 1 Report
A festival organiser is preparing a costs spreadsheet for a small lantern parade. Column B contains the number of items ordered, column C contains the unit cost, and column D calculates each line cost. The organiser has a budget of £1200 and wants a warning when the combined costs are too high. Some unit costs are entered in pence, so the organiser must ensure that all displayed money values are suitable for the document sent to sponsors.
(a) Create a formula in D2 to calculate the line cost. [2]
(b) Create a function to calculate the total of D2 to D18. [2]
(c) Use a suitable number format for the unit cost and line-cost columns. [1]
Answer Details
(a) Enter =B2*C2 in D2 [2]. It multiplies the quantity ordered by the unit cost to calculate that line’s cost.
(b) Use =SUM(D2:D18) [2] to add all line costs.
(c) Apply a £ currency format with two decimal places to the unit-cost and line-cost columns [1]. Money should be displayed consistently, for example £4.50 rather than an unformatted number.
Download The App On Google Playstore
Everything you need to excel in your exams
