excel table

Assignmentguruh.com boasts a team of highly skilled and experienced writers who specialize in various academic fields. The company carefully selects its writers through a rigorous screening process to ensure that they possess the necessary qualifications and expertise. Whether it’s an essay, research paper, or any other homework assignment, students can rely on Assignmentguruh.com to connect them with professionals who have an in-depth understanding of the subject matter. This ensures that the work delivered is of high quality and meets the academic standards set by educational institutions.
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 2nd worksheet
26.Complete the Document Properties with your name and TAGS (min of 3 – separated by commas)

 
 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code “GURUH” for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.