Illustrated Excel 2019 Module 2: Textbook Project Tam Doan 1

Illustrated Excel 2019 Module 2: Textbook Project

Tam Doan

1. Format Values

Change the number format.

Change the number format.

Change the number format.

Change the number format.

Change the number format.

Change the number format.

2. Change Font and Font Size

Change the font.

Apply a cell style.

Apply a cell style.

Apply a cell style.

3. Change Font Styles and Alignment

Change the font style.

Align cell content.

Use the Format Painter.

Merge and center a range.

4. Adjust Column Width

Change the column width.

Change the column width using AutoFit.

Change the column width using AutoFit.

Change the column width.

5. Insert and Delete Rows and Columns

Insert a row.

Delete a row.

Delete a column.

6. Apply Colors, Borders, and Documentation

Change the fill color of a range.

Add a border to a range.

Change the font color.

Add a header to a worksheet.

7. Apply Conditional Formatting

Apply a conditional formatting rule that uses data bars.

Change the fill color of conditional formatting data bars.

Apply a conditional formatting rule.

Format a conditional formatting rule.

Update a value in a cell.

8. Rename and Move a Worksheet

Change the name of a worksheet.

Change the color of a worksheet tab.

Change the name of a worksheet.

Delete a worksheet.

9. Check Spelling

Run the Spelling check.

Run the Spelling check.

Use Find and Replace to update cell values.