Below is a screenshot from a Microsoft Excel 2016 spreadsheet. Identify SIX (6) errors in the spreadsheet. In the table below, using the relevant cell reference explain what the error is and how it could be corrected. B C D 1 Inputs 2 Advertisements Magazine Television Total 3 Number of Ads 4 B -SUM(B3:03) 4 Complimentary Ads =VLOOKUP(B3,$A$21:$8$24,2,TRUE) =VLOOKUP(C3,SC$21:$D$24,2,FALSE) =SUM(B4:C4] Audience 7 Audience per Ad 250000 1500000 s Size of Audience B7*SUM(83:84] C7* SUMM/C3:C4 SUM(BB:CS 9 10 Advertising Costs 11 Cost per Ad $5k $10k 12 Total Advertising Cost =B11 83+(11*C3 13 14 Magazine Resources 15 Offices People 16 Available =VLOOKUP("Total" A30:838,3,TRUE) 0 17 Magazines Assigned per Resource =SUM(83:84)/B16 =SUM(B3:B4)/C16 18 19 Complimentary 20 Magazine Television 21 1 22 2 23 5 24 10 15 10 25 26 If the company orders at least X ads, they receive Y complimentary ads. 27 28 For example, if the company order 2 or 3 magazines ads, they get 2 complimentary ads. 29 Office Availability 30 Brisbane Yes 31 Sydney No 32 Melbourne Yes 33 Canberra No 34 Darwin No 35 Hobart Yes 36 Perth No 37 Adelaide No 38 Total =COUNTIF(B30:837, "Yes"]