City Guilds Model Questions Vol1 2023 Information Technology Question 11
Practice objective / multiple choice question 11 from the 2023 City Guilds Model Questions Vol1 Information Technology examination.
A spreadsheet records monthly sales in cells B2 to B6 for January to May respectively. The values are: B2 = 45 000, B3 = ?, B4 = 55 000, B5 = ?, B6 = 60 000. Cell B7 contains the formula ( =\text{SUM}(B2:B6) \) and the target total for the five months is 250 000. If the sales for February (B3) and April (B5) are equal, determine the sales figure for each of those two months.
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2023 Information Technology Question 11. It is one of the objective questions from the 2023 City Guilds Model Questions Vol1 Information Technology examination.
Difficulty level: Medium .
Master the Exam!
You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.