Predefined Function - Calculate the Average Advertisement Cost - Engineering Assignment Help

Assignment Task :

Background Info
The tvseries.xlsx workbook contains eight (8) worksheets (Sheet1 to Sheet7 and OriginalData worksheets).
Sheet1 worksheet contains excerpts of TV series information with the advertisement cost (values in dollar) for each 30 seconds timeslot during the show in 2018 and 2019. You are tasked to complete this worksheet with the necessary formula and charts, as well as make it presentable.
Sheet2 to Sheet7 worksheets serve different purposes, you will need to prepare them for each of those intended purposes as listed.
OriginalData worksheet contains the copy of the original data used in worksheets Sheet2 to Sheet7. If you need a fresh copy, you can duplicate this worksheet and rename it accordingly. Do not make any changes to this worksheet.

Tasks
Work on each instruction in the correct worksheet.
Sheet1  
T1: Add your name and ID in cells A1 and B1 respectively.
T2: Rename the worksheet name Sheet1 to TV Advertisement.
T3: In the cells G8 to G15, use a pre-define formula to calculate the total cost in 2018 and 2019. Read notes above.
T4: In H8 to H15, use a formula to calculate difference between 2018 and 2019 (cost in 2019 minus 2018). Read notes above.
T5: In I8 to I15, use a formula to calculate the percentage of difference between 2018 and 2019 (difference over 2018). Read notes above.
T6: In B18 to B20, use a predefined function to calculate the number of TV shows in 2019 according to the age restriction classifications (PG, M, MA15+). Read notes above.
T7: In F18 to G21, use a predefined function to calculate the average advertisement cost in 2019/2018 for each network (ABC, CBS, Fox, NBC).

This Engineering Assignment has been solved by our Engineering  Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.