I attached the instructions to complete the assignment.

I also attached what the product should look like when it is finished. I showed this in class --- but wanted you to have it to compare.

So please complete the assignment using the instructions --- and refer to your text and or "Google it" if you are still not clear. Sometimes additional research is necessary to find solutions to problems in academics, and in business.

Directions for Excel

Project 15A

The Data we used in class is different ---- however --- If you follow the steps in the book pages 674 701 you should have no trouble completing the assignment. Please use this document to finish this project that we started in class. **Upload the assignment into Canvas once complete**

Activity Name

Demonstration Notes

Objective 1: Create, Save, and Navigate an Excel Workbook

15.01 Starting Excel, Navigating Excel, and Navigating and Saving a Workbook

• Start Excel. Click Blank Workbook.
• Save the workbook as any file name you feel comfortable with.

Objective 2: Enter Data in a Worksheet

15.02 Entering Text Using AutoComplete, and Using the Name Box to Select a Cell

• In cell A1, type GI Marketing and press Enter.
• Type 4th Quarter Salesperson Commissions and press Enter twice.
• Type each of the following, pressing Enter after each:

New York

New Jersey

Delaware

Virginia

Monthly Total

15.03 Using Autofill and Keyboard Shortcuts

• In cell B3, type October and press Enter.
• Select cell B3 and use the fill handle to drag to cell D3.

15.04 Aligning Text and Adjusting the Size of Columns

• Adjust the column width for column A to 100 pixels by dragging the right boundary.
• Select the range B3:D3. Right-click and on the mini-toolbar, click Center.
• Click Save on the Quick Access toolbar.

15.05 Entering Numbers

• In cell B4, type 25696.63 and enter the remaining numbers as shown:

	October	November	December
New York	25696.63	28963.17	29527.49
New Jersey	13646.37	12533.22	15621.28
Delaware	12981.36	13998.99	11586.57
Virginia	22877.52	25776.44	24696.53

Objective 3: Construct and Copy Formulas and Use the Sum Function
15.06 Constructing a Formula and Using the Sum Function	In cell B8, type =b4 + b5 + b6 + b7 and press Tab. In cell C8, type =c4 + c5 + c6 + c7 and press Tab. In cell D8, click AutoSum and press Enter.
15.07 Copying a Formula by Using the Fill Handle	In cell E3, type Total and then press Enter. Click in cell E4, Press Alt + = (This keyboard shortcut enters the Sum function.) Click the Enter button on the Formula Bar. Drag the fill handle down through cell E8. Click in cell F3, type Trend and press Enter.
Objective 4: Format Cells with Merge & Center, Cell Styles, and Themes
15.08 Using Merge & Center and Applying Cell Styles	Merge and center the title in the range A1:F1. Merge and center the title in the range A2:F2. Apply the Title style to cell A1. Apply the Heading 1 style to cell A2. Apply the Heading 4 style to the ranges B3:F3 and A4:A8.
15.09 Formatting Financial Numbers	Apply the Accounting number format to the ranges B4:E4 and B8:E8. Apply the Comma number style to the range B5:E7. Apply the Total number style to the range B8:E8.
15.10 Changing the Workbook Theme	Apply the Ion Boardroom theme.
Objective 5: Chart Data to Create a Column Chart and Insert Sparklines
15.11 Charting Data and Using Recommended Charts to Select and Insert a Column Chart	Select the range A3:D7. On the Insert tab, click Recommended charts, click all charts, select Clustered Column chart.
15.12 Using the Chart Tools to Apply Chart Styles	Change the Chart Title to Fourth Quarter Sales Commissions Using Chart styles select Style 6. Using Change Colors select Color 5. Drag the chart to cell A10.
15.13 Creating and Formatting Sparklines	Select the range B4:D7 and insert a Line sparkline. Type the location range as F4:F7. Show Markers. On the Design tab, in the Style group, click More and click on Sparkline Style Accent 1, Darker 25%.

Objective 6: Print a Worksheet, Display Formulas, and Close Excel
15.14 Creating a Footer and Centering a Worksheet	Center the data and chart horizontally on the page. Insert the File Name in the footer. (It explains in the textbook on exactly how to do this.)
15.15 Adding Document Properties and Printing a Worksheet	Add the following Document Properties: Type Quarterly Sales in the Tags box Type your course name and section number in the Subject box.
15.16 Printing a Section of the Worksheet	Select the range A2:F5 and then press Ctrl + F2. (This keyboard shortcut displays Print Preview --- (you do not need to print this assignment.) Change the print settings option to Print Selection. If I required a printed copy, you would click Print. (You do not need to print.)
15.17 Changing Page Orientation and Displaying, Printing, and Hiding Formulas	Show the Formulas. AutoFit columns as needed. Change to Landscape orientation and Scale the data to fit on one page. Click on the Chart to select it. Center the chart horizontally on the page. Press Ctrl + F2 and change the print settings option to Print Active Sheets. Make sure you save your file Submit the completed file in Canvas