Insert the following table into Sheet1 of an Excel Spreadsheet, keeping the cell references consistent.

1.Copy the following table into a new Excel spreadsheet.Be sure to keep the cell data the same.

	A	B	C	D	E	F
1		Chalet	Samoa	Thin Mints	PeanutButter	Tagalongs
2	Troop 919	674	796	1249	1438	584
3	Troop NYC	1531	864	1765	792	1496
4	Troop 415	941	973	1523	6842	1302
5	Troop 5314	768	698	2004	1947	1463
6	Troop 627	644	891	1497	1053	385
7	Troop 9756	879	793	597	596	1185
8	Troop 7933	904	846	867	874	1675
9	Troop 318	894	1247	2015	863	2511
10	Troop 6917	796	822	496	1176	8976
11						Total Sales:
12	Prize Money:
13	More than 10,00 boxes	2500
14	More than 5,000 boxes	1375
15	Other	550

2.Save the workbook as yourname_Q1

CALCULATIONS (Functions)

3.At cell G1 enter the column title Total

a.Find the total of boxes sold be each troop

4.At cell H1 enter the column title % of Sales

a.Find the % amount of total sales that each troop sold

5.At cell I1 enter the column title Prize

a.Use an IF function to determine the Prize Monday given to each troopl based on the quantity of boxes sold

b.Be sure to use an ABSOLUTE cell reference

6.At cell G11 find the total of all boxes sold

7.Add 2 rows at the top of the table

8.In cell A1 enter the title National Girl Scout Cookie Sales

9.In cell A2 enter the subtitle Top Sellers

10.Center the title across the table

11.Center the subtitle across the table

12.Center, Bold and make Italic the column titles

13.Use the AutoFit Option to fix the column widths

14.Change the Font, Font Size and Color of your Title

a.You Choose

15.Change the font, font size and color of table cells

a.You choose

16.Format the rest table to your liking.

a.Be sure to format for numbers and money

17.Adjust column widths again

18.Change the name of the worksheet to Cookies

19.Color the tab RED

20.Change the page orientation to Landscape

CONDITIONAL FORMAT

21.Use conditional format for the cells that have less than 5500 total boxes

a.format them with a Blue Background and Bold White letters

GRAPH

22.Create a Column Chart showing the Employees and their Commissions

23.Move the Graph to a new worksheet

a.Call the worksheet Commissions and color the tab BLUE

b.ADD axis titles and ADD data labels

24.Enter your name, Student ID number, Date and Instructor Name underneath the table beginning at A19

25.Re-Order the tabs so the chart is the 2^nd worksheet

26.Complete the Document Properties with your name and TAGS (min of 3 – separated by commas)