Homework answers / question archive / Shelly Cashman Excel 2019 Module 3:Textbook Project Andrew Moore 1

Shelly Cashman Excel 2019 Module 3:Textbook Project Andrew Moore 1

MS Excel

Share With

---

Shelly Cashman Excel 2019 Module 3:Textbook Project

Andrew Moore

1. Project: Financial Projection Worksheet with What-If Analysis and Chart

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

4. Inserting and Deleting Cells in a Worksheet

To Enter Numbers with Format Symbols

To Enter the Projected Monthly Sales

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 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

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 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