question archive 1)Group worksheets for Quarters 1-4 and calculate revenue under each pricing scenario for each quarter
Subject:BusinessPrice: Bought3
1)Group worksheets for Quarters 1-4 and calculate revenue under each pricing scenario for each quarter.
2)Group worksheets for Quarters 1-4 and calculate costs under each pricing scenario for each quarter. In cell C10, use the appropriate combination of mixed references so the formula can be copied across to column E and down to row 13.
3)Group worksheets for Quarters 1-4 and calculate projected earnings under each pricing scenario for each quarter. Projected earnings is equal to revenue minus the subtotal of cost of goods sold.
4)Make a copy of the Quarter4 sheet and name the new sheet "SamsSummary". Change the title to indicate that this sheet represents the yearly summary. Remove the sales volume data in cells C4:E4. Using static consolidation, complete the summary sheet to show sales volume totals for the entire year. Adjusting the sales volume should automatically calculate yearly totals for total revenue, cost of goods sold and projected earnings.