excel table

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.

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)