Shelly Cashman Excel 2019 Module 1:Textbook Project Peter Yackley 1

Shelly Cashman Excel 2019 Module 1:Textbook Project

Peter Yackley

1. Non-graded - Project: Real Estate Budget Worksheet and Chart

2. Non-graded - Starting and Using Excel

3. Non-graded - Selecting a Cell

4. Entering Text

To Enter the Worksheet Titles

To Enter Row Titles

5. Entering Numbers

To Enter Numbers

6. Calculating Sums and Using Formulas

To Sum a Column of Numbers

7. Using the Fill Handle to Copy a Cell to Adjacent Cells

To Copy a Cell to Adjacent Cells in a Row

8. Calculating Average, Maximum, and Minimum Values

To Enter a Formula Using the Keyboard

To Copy a Cell to Adjacent Cells in a Row Using the Fill Handle

9. Non-graded - Saving the Project

10. Formatting the Worksheet

To Change a Cell Style

To Change the Font

To Apply Bold Style to a Cell

To Increase the Font Size of a Cell Entry

To Change the Font Color of a Cell Entry

To Format Numbers in the Worksheet

To Adjust the Column Width

11.  Adding a Pie Chart to the Worksheet

To Apply a Style to a Chart

12. Changing the Sheet Tab Names and Colors

To Move a Chart to a New Sheet

To Change the Sheet Tab Name and Color

13. Non-graded - Document Properties

14. Printing a Worksheet

To Preview and Print a Worksheet in Landscape Orientation

15. Non-graded - Viewing Automatic Calculations

16. Non-graded - Correcting Errors