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