Excel 2016 Managing Worksheets

Excel 2016

Lesson 2 – Managing Worksheets

E XERCISE

M ANAGING W ORKSHEETS



T ASK Manage the data in multiple worksheets.

1. Open REGION13.XLSX . 2. Move the Totals worksheet to the left of the By Week worksheet. 3. Select the Northeast worksheet. Move the data in the range A12:E20 to cell A1 in the Southeast worksheet. 4. Copy the title in cell A1 in the Southeast worksheet to cell A1 in the Central worksheet. Close the Clipboard task pane. 5. Group the worksheets Northeast through By Week . 6. Display the Northeast worksheet. Select the range A1:E9 and change the font to Arial. Change the font size of cell A2 to 12 points. Change the width of column E to 11 characters. 7. Ungroup the worksheets and view the change. 8. Copy the Northeast worksheet and place it after the Totals worksheet. Rename the copy Expenses . 9. Display the By Week worksheet. 10. In cell B5, create a formula that adds the total sales of all five regions for Jan , Week 1 . The values are in cell B5 on each of the five regional worksheets. Copy the formula to the range B6:B8. 11. In cell C5, use a 3-D =SUM() function to add the values in cell C5 on each of the five regional worksheets. Copy the function to the range C5:D8. Close the workbook without saving it.

OFFICEPRO, Inc.

Page 29