Gce Model Questions Vol1 2018 Computer Studies Question 32
Practice objective / multiple choice question 32 from the 2018 Gce Model Questions Vol1 Computer Studies examination.
A spreadsheet stores quarterly sales (Q1-Q4) for three products as follows (the data starts at cell B2): - Product A: 120, 150, 130, 160 - Product B: 80, 95, 100, 110 - Product C: 200, 210, 190, 220 In cell G5 you must write a single formula that calculates the overall average weighted sales where the weight for quarters Q1-Q4 is 1, 2, 3, 4 respectively. Use mixed absolute/relative references so the formula can be copied to other cells if the table were extended. After entering the formula, the value in G5 is 151.00. If the sales figure for Product B in Q2 is changed from 95 to 105, what is the new value shown in G5 (rounded to two decimal places)?
Answer Options
About This Question
This is Gce Model Questions Vol1 2018 Computer Studies Question 32. It is one of the objective questions from the 2018 Gce Model Questions Vol1 Computer Studies examination.
Difficulty level: Hard .
Master the Exam!
You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.