Shelly Cashman Excel 2019 Module 2:Textbook Project Britany Luna 1

Shelly Cashman Excel 2019 Module 2:Textbook Project

Britany Luna

1. Non-graded - Project: Worksheet with Formulas and Functions

2. Entering the Titles and Numbers into the Worksheet

To Enter the Worksheet Title and Subtitle

To Enter the Column Titles

To Enter the Salary Data

3. Flash Fill

To Use Flash Fill

To Enter the Row Titles

To Change the Sheet Tab Name and Color

4. Entering Formulas

To Enter a Formula Using the Keyboard

To Enter a Formula Using Point Mode

To Copy Formula Using the Fill Handle

5. Option Buttons

To Determine Totals Using the AutoSum Button

To Determine the Total Tax Percentage

6. Using the AVERAGE, MAX, MIN, and other Statistical Functions

To Determine the Higest Number in a Range of Numbers Using the Insert Function Dialog Box

To Determine the Lowest Number in a Range of Numbers Using the Sum Menu

To Determine the Average of a Range of Numbers Using Keyboard

To Copy a Range of Cells across Columns to an Adjacent Range Using the Fill Handle

7. Non-graded - Verifying Formulas Using Range Finder

8. Formatting the Worksheet

To Change the Workbook Theme

To Format the Worksheet Titles

To Change the Background Color and Apply a Box Border to the Worksheet Title and Subtitle

To Apply a Cell Style to the Column Heading and Format the Total Row

To Format Date and Center Data in Cells

To Apply an Accounting Number Format and Comma Style Format Using the Ribbon

To Apply a Currency Style Format with a Floating Dollar Sign Using the Format Cells Dialog Box

To Apply a Percent Style Format and Use the Increase Decimal Button

To Apply a conditional formatting

To Change the Row Height

9. Non-graded - Checking Spelling

10. Printing the Worksheet

To Change the Worksheet's Margins, Header, and Orientation in Page Layout View

11. Non-graded - Displaying and Printing the Formulas Version of the Worksheet