Illustrated Excel 2019 Module 1: Textbook Project Sachelle Brown 1

Illustrated Excel 2019 Module 1: Textbook Project

Sachelle Brown

1. Non-graded - Explore Excel 2019

2. Enter Data

Enter text in a cell.

Enter text in a cell.

Enter a number in a cell.

Enter a number in a cell.

Enter a number in a cell.

Update a value in a cell.

AutoFill values in a range.

3. Edit Data

Update a value in a cell.

Update a value in a cell.

4. Copy and Move Cell Data

Copy and paste a value in a cell.

Cut and paste a range of values.

5. Enter Formulas and Use AutoSum

Use relative references in a formula.

6. Copy Formulas with Relative Cell References

Copy a formula into a range.

7. Copy Formulas with Absolute Cell References

Enter text in a cell.

Use mixed references in a formula.

Copy a formula into a range.

8. Enter a Formula with Multiple Operators

Enter text in a cell.

Use relative references in a formula

Use absolute, relative, or mixed references in a formula.

Change the number format.

Enter text/a number in a cell.

9. Insert a Function

Create a formula using a function.

Create a formula using a function.

10. Switch Worksheet Views

Set the print area for a worksheet.

11. Non-graded - Choose Print Options