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 hiri...

Assessment: Information and Communication Technology 4IT1 | Paper 2 Mock 01 | Written Paper 2 Subject: Information and Communication Technology - 4IT1

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]

Answer Details

(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.

Download The App On Google Playstore

Everything you need to excel in your exams

Green Bridge CBT Mobile App
Personalized AI Learning Chat Assistant
200,000+ Exam Questions Across IGCSE, JAMB, WAEC & NECO
Over 3,900 Lesson Notes
Offline Support - Learn Anytime, Anywhere
Green Bridge Timetable
Literature Summaries & Potential Questions
Track Your Performance & Progress
In-depth Explanations for Comprehensive Learning