Solution for QID #83756: Shelly Cashman Excel 2019 | Module 3: Textbook Project | StudyHelpMe

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