CONFUSED ON HOW TO APPROACH THIS QUESTION. PLEASE SHOW STEPS AND ALL FORMULAS USED. THANKS :)

Title 1 HC and eBook (ORB) HC: Tracking Title: Comp Title: Title 1 Title 2 EBook: Scenario: We are tracking a new title against it's comp title on a daily basis. You already have daily POS from the comp title, and will fill in the POS for the new title daily. Assuming today is day 3, and you already filled in the daily of the new title. Here's what you need to do: 1. Show grand total for the comp title up to day 3. You will need to use a formula to change the comp total everyday, rather than manually add the numbers. Hint: use cell E5. 2. Calculate the variance of the titles. This is a percentage of change. 3. Keep the cells in formula, don't hard code with values. OSD: On Sale Date: 10/23/18 Comp: Title 2 Hardcover Account Day 3 10/24/18 Day 2 10/23/18 Day 1 Grand Total (Incl. Preorder) 10/25/18 Day 3 10/26/18 Day 4 10/27/18 Day 5 Title Variance % 55 30 170 Barnes & Noble* TITLE 1 TITLE 2 Variance % 85 75 55 45 35 25 Hardcover Total TITLE 1 TITLE 2 Variance % eBook Account Day 1 Day 2 Day 3 Day 4 Day 5 Grand Total (Incl. Preorder) 78 66 55 Amazon 80 70 60 50 40 TITLE 1 TITLE 2 Variance % TITLE 1 TITLE 2 Variance % 50 30 55 Barnes & Noble* 74 64 54 44 34 eBook Total TITLE 1 TITLE 2 Variance % TITLE 1 TITLE 2 Variance % GRAND TOTAL (P+E) Title 1 HC and eBook (ORB) HC: Tracking Title: Comp Title: Title 1 Title 2 EBook: Scenario: We are tracking a new title against it's comp title on a daily basis. You already have daily POS from the comp title, and will fill in the POS for the new title daily. Assuming today is day 3, and you already filled in the daily of the new title. Here's what you need to do: 1. Show grand total for the comp title up to day 3. You will need to use a formula to change the comp total everyday, rather than manually add the numbers. Hint: use cell E5. 2. Calculate the variance of the titles. This is a percentage of change. 3. Keep the cells in formula, don't hard code with values. OSD: On Sale Date: 10/23/18 Comp: Title 2 Hardcover Account Day 3 10/24/18 Day 2 10/23/18 Day 1 Grand Total (Incl. Preorder) 10/25/18 Day 3 10/26/18 Day 4 10/27/18 Day 5 Title Variance % 55 30 170 Barnes & Noble* TITLE 1 TITLE 2 Variance % 85 75 55 45 35 25 Hardcover Total TITLE 1 TITLE 2 Variance % eBook Account Day 1 Day 2 Day 3 Day 4 Day 5 Grand Total (Incl. Preorder) 78 66 55 Amazon 80 70 60 50 40 TITLE 1 TITLE 2 Variance % TITLE 1 TITLE 2 Variance % 50 30 55 Barnes & Noble* 74 64 54 44 34 eBook Total TITLE 1 TITLE 2 Variance % TITLE 1 TITLE 2 Variance % GRAND TOTAL (P+E)