Question: 1 . Begin in the Documentation worksheet: enter your name and date ( use a function for the current date ) . ( 1 mark
Begin in the Documentation worksheet: enter your name and date use a function for the current date mark
Copy the Newton worksheet and rename it Consolidated Sales Q Move it to the right of the Documentation worksheet.
In the Consolidated Sales Q worksheet, delete all the numeric data under the headings April, May and June C:
In C use a D reference to calculate the sales for each product for all locations. Copy the formula appropriately.
Group all the locations and the Consolidated Sales Q worksheets. Create a formula to calculate the Quarter Sales Total in cell F for all months and autofill the formula.
Ungroup the sheets. In the Consolidated Sales Q worksheet, in cell H insert an external link to Test
Part V Start File.xIsx. Make sure the Text to Display makes sense to users.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
