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.
Essay Writing Service Features
Our Experience
No matter how complex your assignment is, we can find the right professional for your specific task. Tutoracer is an essay writing company that hires only the smartest minds to help you with your projects. Our expertise allows us to provide students with high-quality academic writing, editing & proofreading services.
Free Features
Free revision policy
$10Free bibliography & reference
$8Free title page
$8Free formatting
$8How Our Essay Writing Service Works
First, you will need to complete an order form. It's not difficult but, in case there is anything you find not to be clear, you may always call us so that we can guide you through it. On the order form, you will need to include some basic information concerning your order: subject, topic, number of pages, etc. We also encourage our clients to upload any relevant information or sources that will help.
Complete the order form
Once we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.
Writer’s assignment
As soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.
Completing the order and download