City Guilds Model Questions Vol1 2018 Information Technology Question 10
Practice objective / multiple choice question 10 from the 2018 City Guilds Model Questions Vol1 Information Technology examination.
A spreadsheet contains the monthly sales (in thousands of dollars) for a company in cells A2:A13 as follows:\n\n| Month | Sales (A) |\n|-------|-----------|\n| Jan | 1200 |\n| Feb | 1350 |\n| Mar | 1280 |\n| Apr | 1500 |\n| May | 1600 |\n| Jun | 1580 |\n| Jul | 1700 |\n| Aug | 1650 |\n| Sep | 1800 |\n| Oct | 1900 |\n| Nov | 1850 |\n| Dec | 2000 |\n\nIn column B (cells B3:B13) you are to calculate the month‑over‑month percentage change using the formula in B3 and copying it down.\n\n(a) Write the formula that should be entered in B3 (using relative and absolute references) to compute the percentage change from January to February.\n(b) Using the data above, determine the average of all **positive** percentage changes for the year. Give your answer rounded to two decimal places.
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2018 Information Technology Question 10. It is one of the objective questions from the 2018 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.