Shelly Cashman Excel 2019 | Module 2: Textbook Project 1

Subject:MS ExcelPrice:19.99 Bought3

Share With

Shelly Cashman Excel 2019 | Module 2: Textbook Project

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
		In the Salary Report worksheet, cell C3 should contain the text "Dependents".
		To Enter the Salary Data
		In the Sheet1 worksheet, cell A12 should contain the value shown in Table 2-1 in the Instructions file.
3.	Flash Fill
		To Use Flash Fill
		In the Sheet1 worksheet, the range B6:B12 should be filled using Flash Fill based on the pattern in the range B4:B5.
		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
		In the Salary Report worksheet, the range E14:H16 should be formatted using the Currency number format.
		To Apply a Percent Style Format and Use the Increase Decimal Button
		To Apply a conditional formatting
		To Change Column Width
		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
		In the Salary Report worksheet, the center section of the header should contain the text "Madelyn Samuels Chief Financial Officer".
11.	Non-graded - Displaying and Printing the Formulas Version of the Worksheet