Excel – The tvseries.xlsx workbook contains eight (8) worksheets
Background Info The tvseries.xlsx workbook contains eight (8) worksheets (Sheet1 to Sheet7 and Original Data worksheets). Sheet1 worksheet contains excerpts of TV series information with the advertisement cost (values in dollar) for each 30 seconds time slot 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. Original Data 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…
Details