New Perspectives Excel 2016 Module 1: Textbook Project EKINADOSE UKPONMWAN 1

New Perspectives Excel 2016 Module 1: Textbook Project

EKINADOSE UKPONMWAN

1. Non-graded - Introducing Excel and Spreadsheets

2. Non-graded - Exploring a Workbook

3. Non-graded - Closing a Workbook

4. Non-graded - Planning a Workbook

5. Starting a New Workbook

To rename the Sheet1 worksheet.

To insert and name the Documentation and Customer Contact worksheets.

To move the Documentation worksheet.

6. Entering Text, Dates, and Numbers

To enter text in the Documentation sheet.

To undo the text entry in cell B5.

To edit the text in cell B5.

To enter Leslie Ritter's contact information.

7. Resizing Columns and Rows

To set the with of column D using the Format command.

To change the height of row 13.

8. Performing Calculations with Formulas

9. Simplifying Formulas with Functions

10. Modifying a Worksheet

11. Using Flash Fill

To enter the Store IDs using Flash Fill.

12. Formatting a Worksheet

To add borders around the worksheet cells.

To change the font size of the worksheet title.

13. Printing a Workbook

To change the page orientation of the worksheet.

To scale the printout of the Customer Order worksheet.

14. Non-graded - Viewing Worksheet Formulas

15. Non-graded - Saving a Workbook with a New Filename