Question: 1 . Begin in the Documentation worksheet: enter your name and date ( use a function for the current date ) . ( 1 mark

1. Begin in the Documentation worksheet: enter your name and date (use a function for the current date).(1 mark)
2. Copy the Newton worksheet and re-name it Consolidated Sales Q2. Move it to the right of the Documentation worksheet. (1)
3. In the Consolidated Sales Q2 worksheet, delete all the numeric data under the headings April, May and June (C5:53).
4. In C5 use a 3D reference to calculate the sales for each product for all locations. Copy the formula appropriately. (2)
5. Group all the locations and the Consolidated Sales Q2 worksheets. Create a formula to calculate the Quarter2 Sales Total in cell F5 for all months and autofill the formula. (2)
Ungroup the sheets. In the Consolidated Sales Q2 worksheet, in cell H4, insert an external link to Test
1 Part 2 V14 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!