Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


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

Shelly Cashman Excel 2019 | Module 3: Textbook Project 1

MS Excel

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

 

Option 1

Low Cost Option
Download this past answer in few clicks

19.99 USD

PURCHASE SOLUTION

Already member?


Option 2

Custom new solution created by our subject matter experts

GET A QUOTE