Fill This Form To Receive Instant Help
Fill This Form To Receive Instant Help
Homework answers / question archive / 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
Already member? Sign In
