Neco 2020 Data Processing Question 20
Practice objective / multiple choice question 20 from the 2020 Neco Data Processing examination.
In a spreadsheet, column A lists months 1-12 and column B contains the corresponding sales figures (in units): 120, 150, 180, 210, 190, 230, 250, 240, 260, 300, 310, 330. A 3‑month moving average is calculated for months 3-12 using the formula =AVERAGE(Bn‑2:Bn). Conditional formatting is set to highlight a month when its sales exceed the moving average by more than \(15\%\). How many months will be highlighted by this conditional formatting?
Answer Options
About This Question
This is Neco 2020 Data Processing Question 20. It is one of the objective questions from the 2020 Neco Data Processing 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.