Shelly Cashman Excel 2019 | Module 1: Textbook Project 1

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 Column 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

To Calculate Multiple Totals at the Same Time

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

In the Monthly Finances worksheet, the range A1:A2 should be formatted using the Bold font style.

To Increase the Font Size of a Cell Entry

To Change the Font Color of a Cell Entry

To Center Cell Entries across Columns by Merging Cells

To Format Rows Using Cell Styles

In the Monthly Finances worksheet, cell A4 should be formatted using the 20% - Accent6 cell style.

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

The Monthly Finances worksheet should be formatted using Landscape orientation.

15.

Non-graded - Viewing Automatic Calculations

16.

Non-graded - Correcting Errors