New Perspectives Excel 2019 Module 5: Textbook Project 1

New Perspectives Excel 2019 Module 5: Textbook Project

1.Working with Multiple Worksheets

To open the Peoria workbook

2. Non-graded - Viewing a Workbook in Multiple Windows

3. Working with Worksheet Groups

4. Writing 3-D References

To calculate total food sales using a 3-D cell reference

To change the food sales value in the Grill5-08 worksheet

To calculate the totals for the rest of the worksheet

5. Linking to External Workbooks

6.  Creating Hyperlinks

To create hyperlinks to the Prime Costs and Controllable Profits entries

To link to an email address

7. Simplifying Formulas with Named Ranges

To define a named range using the Name box

To create formulas for the benchmark values

To apply defined names to existing formulas in the profit and loss worksheets

To replace cell references with the TOTAL_SALES defined name