Neco 2020 Computer Studies Question 29

The spreadsheet below records monthly sales data for a year. Columns are: Month, Units Sold, Unit Price (₦), Discount (%). Net revenue for a month is calculated as\n\[\text{Revenue}= \text{Units}\times \text{Price}\times\bigl(1-\frac{\text{Discount}}{100}\bigr)\]\nThe data are:\n\n| Month | Units | Price | Discount |\n| Jan | 120 | 2000 | 5 |\n| Feb | 150 | 1950 | 0 |\n| Mar | 130 | 2100 | 10 |\n| Apr | 160 | 2050 | 5 |\n| May | 140 | 2000 | 0 |\n| Jun | 155 | 1980 | 5 |\n| Jul | 165 | 2020 | 0 |\n| Aug | 170 | 1990 | 10 |\n| Sep | 158 | 2010 | 5 |\n| Oct | 162 | 2005 | 0 |\n| Nov | 148 | 1975 | 5 |\n| Dec | 175 | 2030 | 0 |\n\nUsing spreadsheet functions, (i) identify the month with the highest net revenue, and (ii) compute the average net revenue of those months whose revenue exceeds the overall average revenue for the year. Give the month name and the average (rounded to the nearest naira).