Question 1 Report
A community theatre is planning six evening shows. Its finance volunteer has opened a new spreadsheet worksheet to record ticket income and the cost of hiring equipment. The volunteer must save the document as TASK B3 before sending it to the producer. Income values will be entered in column D and costs in column E. The producer wants the worksheet to remain clear when extra shows are added later.
(a) Identify the cell reference for the cell in column E on row 3. [1]
(b) Give a suitable label for cell D1. [1]
(a) The cell in column E and row 3 is E3 [1]. A spreadsheet cell reference combines its column letter with its row number.
(b) A suitable label for D1 is Ticket income [1]. It clearly describes the values that will be entered in column D.
Everything you need to excel in your exams