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

Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

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 TVAssignmentHelp. 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.

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services