Shelly Cashman Excel 2019 | Module 3: Textbook Project 1

Subject:MS ExcelPrice:19.99 Bought3

Share With

Shelly Cashman Excel 2019 | Module 3: Textbook Project

1.	Project: Financial Projection Worksheet with What-If Analysis and Chart
		To Enter the Worksheet Titles and Apply a Theme
		In the first worksheet, cell A1 should contain the text "Manola Department Stores, Inc.".
2.	Rotating Text and Using the Fill Handle to Create a Series
		To Rotate Text in a Cell
		To Use the Fill Handle to Create a Series of Month Names
		To Increase Column Widths
		To Enter and Indent Row Titles
3.	Copying a Range of Cells to a Nonadjacent Destination Area
		To Copy a Range of Cells to a Nonadjacent Destination Area
4.	Inserting and Deleting Cells in a Worksheet
		To Insert a Row
		To Enter Numbers with Format Symbols
		In the first worksheet, one or more cells in the range B19:B25 contains an incorrect value.
		To Enter the Projected Monthly Sales
		To Enter and Format the System Date
		In the first worksheet, cell H1 should be formatted using the yyyy-mm-dd Date number format.
5.	Absolute versus Relative Addressing
		To Enter a Formula Containing Absolute Cell References
6.	Making Decisions - The IF Function
		To Enter an IF Function
		To Enter the Remaining Formulas for January
		To Copy Formulas with Absolute Cell References Using the Fill Handle
		To Determine Row Totals in Nonadjacent Cells
7.	Adding and Formatting Sparkline Charts
		To Add a Sparkline Chart to the Worksheet
		To Change the Sparkline Style and Copy the Sparkline Chart
		To Change the Sparkline Type
8.	Formatting the Worksheet
		To Assign Formats to Nonadjacent Ranges
		To Format the Worksheet Titles
		To Assign Cell Styles to Nonadjacent Rows and Colors to a Cell
		To Copy a Cell's Format Using the Format Painter Button
		To Format the What-If Assumptions Table
		In the first worksheet, cell A18 should be formatted using a 9 point font size.
9.	Adding a Clustered Column Chart to the Workbook
		To Draw a Clustered Column Chart on a Separate Chart Sheet Using the Recommended Charts Feature
		To Insert a Chart Title
		To Add an Axis Title to the Chart
		To Change the Chart Style
		To Modify the Chart Axis Number Format
10.	Non-graded - Organizing the Workbook
11.	Non-graded - Changing the View of the Worksheet
12.	Non-graded - What-If Analysis
13.	Non-graded - Insights