GO16 Chapter 1 MyItLab Gym & Restaurant Supply Worksheet I am currently stuck on these assignments and need help. I dont know where to begin. HELP! Below a

GO16 Chapter 1 MyItLab Gym & Restaurant Supply Worksheet I am currently stuck on these assignments and need help. I dont know where to begin. HELP! Below are the instructions and Excel docs. Thanks. Office 2016 – myitlab:grader – Instructions
Excel Project
GO16_XL_CH01_GRADER_1E_HW – Gym Sales 1.2
Project Description:
In the following project, you will create a worksheet comparing the sales of different types of home gym
equipment sold in the second quarter.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
Points
Possible
Instructions
1
Start Excel. Download and open the file named go16_xl_ch01_grader_1e_hw.xlsx.
0.000
2
Change the worksheet theme to Wisp.
4.000
3
Use the fill handle to enter the months May and June in the range C3:D3.
6.000
4
Merge & Center the title across A1:F1, and then apply the Title cell style. Merge & Center the
subtitle across A2:F2, and then apply the Heading 1 style. Center the column titles in the
range B3:F3.
10.000
5
Widen column A to 180 pixels, and then widen columns B:F to 115 pixels. Note, Mac users will
need to set column A to a width of 21.88 and columns B:F to a width of 13.83.
10.000
In the range B7:D7, enter the following values: 137727.85, 121691.64, and 128964.64.
6
In cell B8, use the AutoSum button to sum the April sales. Fill the formula across to cells
C8:D8. In cell E4, use the AutoSum button to sum the Basic Home Gym sales. Fill the formula
down to cells E4:E8.
10.000
7
Apply the Heading 4 cell style to the row titles and column titles, and then apply the Total cell
style to the totals in the range B8:E8.
6.000
8
Apply the Accounting Number Format to the first row of sales figures and to the total row.
Apply the Comma Style to the remaining sales figures.
6.000
9
Select the range that represents the sales figures for the three months, including the month
names and the product names—do not include any totals in the range. With this data
selected, use the Recommended Charts command to insert a Clustered Column chart with the
month names displayed on the category axis and the product names displayed in the legend.
10.000
10
Move the chart so that its upper left corner is positioned in the center of cell A10. Then drag
the center right sizing handle to the right until the right edge of the chart aligns with the right
edge of column E.
6.000
Updated: 08/09/2017
1
Current_Instruction.docx
Office 2016 – myitlab:grader – Instructions
Step
Excel Project
Points
Possible
Instructions
11
Apply Chart Style 6 and Color 2 under Colorful. Change the Chart Title to Second Quarter
Home Gym Sales.
10.000
12
In the range F4:F7, insert Line sparklines that compare the monthly data. Do not include the
totals. Show the sparkline Markers and apply Sparkline Style Accent 2, Darker 50%—in the
first row, the second style.
10.000
13
Center the worksheet Horizontally on the page, and then insert a Footer with the File Name in
the left section.
6.000
14
Change the Orientation to Landscape.
6.000
15
Save and close the document. Exit Excel. Submit the file as directed.
0.000
Total Points
Updated: 08/09/2017
2
100.000
Current_Instruction.docx
Pro Fit Marietta
Second Quarter Home Gym Sales
April
Total
Basic Home Gym
137963 92897.98 122667.6
Deluxe Home125737.2
Gym
129614.6 98062.92
Multifunctional
87955.66
Trainer 92986.05
121011
Elite Home Gym
Total
Trend
Grader – Instructions
Excel 2016 Project
GO16_XL_CH01_GRADER_1F_HW – Balance Sales 1.3
Project Description:
In the following project, you will create a worksheet summarizing the sales of balance and stabilization equipment that Pro Fit
Marietta is marketing.
Steps to Perform:
Step
Points
Possible
Instructions
1
Start Excel. Download and open the file named go16_xl_ch01_grader_1f_hw.xlsx.
0
2
Merge and center the title and then the subtitle across columns A:F and apply the Title and
Heading 1 cell styles respectively.
8
3
Check spelling in your worksheet, and correct Silde to Slide. Widen column A to 180 pixels
and columns B:F to 95 pixels.
4
4
In cell E4, construct a formula to calculate the Total Sales of the Balance Pillow by multiplying
the Quantity Sold by the Retail Price. Copy the formula down for the remaining products.
10
5
Select the range E4:E10, and then use the Quick Analysis tool to sum the Total Sales for All
Products, which will be formatted in bold. To the total in cell E11, apply the Total cell style.
10
Note, Mac users, instead of the Quick Analysis tool, use the Sum button. Complete the step as
specified.
6
Using absolute cell references as necessary so that you can copy the formula, in cell F4,
construct a formula to calculate the Percent of Total Sales for the first product. Copy the
formula down for the remaining products.
10
7
To the computed percentages, apply Percentage Style with two decimal places, and then
center the percentages.
8
8
Apply the Comma Style with no decimal places to the Quantity Sold figures. To cells D4, E4,
and E11, apply the Accounting Number Format.
10
9
To the range D5:E10, apply the Comma Style.
4
10
Change the Retail Price of the Slide Board to 75.50 and the Quantity Sold of the Balance Pad
to 150.
4
11
Delete column B.
6
12
Insert a new row 3. In cell A3, type Month Ending March 31 and then merge and center the
text across the range A3:E3. Apply the Heading 2 cell style.
10
13
To cell A12, apply the 20% – Accent1 cell style.
4
14
Select the four column titles. Apply Wrap Text, Middle Align, and Center formatting, and then
apply the Heading 3 cell style.
8
15
Center the worksheet horizontally on the page, and then insert the file name in the footer in
the left section. Return the worksheet to Normal view, if necessary.
4
16
Save and close the workbook. Exit Excel. Submit the file as directed.
0
Created On: 01/29/2019
1
GO16_XL_CH01_GRADER_1F_HW – Balance Sales 1.3
Grader – Instructions
Excel 2016 Project
Total Points
Created On: 01/29/2019
2
100
GO16_XL_CH01_GRADER_1F_HW – Balance Sales 1.3
Pro Fit Marietta
Balance and Stabilization Sales
Product Number
Quantity Sold
Retail Price Total Sales Percent of Total Sales
Balance Pillow
BP-3
275
22.95
Silde BoardSB-8
382
99.95
Foam RollerFR-2
251
39.5
Rebounder RB-4
162
139.95
Stability BallSB-5
380
51.5
Balance Board
BB-6
206
84.95
Balance PadBP-8
220
75.99
Total Sales for All Products

Purchase answer to see full
attachment

Don't use plagiarized sources. Get Your Custom Essay on
GO16 Chapter 1 MyItLab Gym & Restaurant Supply Worksheet I am currently stuck on these assignments and need help. I dont know where to begin. HELP! Below a
Just from $13/Page
Order Essay
Homework Market Pro
Calculate your paper price
Pages (550 words)
Approximate price: -

Our Unique Features

Custom Papers Means Custom Papers

This is what custom writing means to us: Your essay starts from scratch. Plagiarism is unacceptable. We demand the originality of our academic essay writers and they only deliver authentic and original papers. 100% guaranteed! If your final version is not as expected, we will revise it immediately.

Qualified and Experienced Essay Writers

Our team consists of carefully selected writers with in-depth expertise. Each writer in our team is selected based on their writing skills and experience. Each team member is able to provide plagiarism-free, authentic and high-quality content within a short turnaround time.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Assuarance

We understand you. Spending your hard earned money on a writing service is a big deal. It is a big investment and it is difficult to make the decision. That is why we support our claims with guarantees. We want you to be reassured as soon as you place your order. Here are our guarantees: Your deadlines are important to us. When ordering, please note that delivery will take place no later than the expiry date.

100% Originality & Confidentiality

Every paper we write for every order is 100% original. To support this, we would be happy to provide you with a plagiarism analysis report on request.We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

We help students, business professionals and job seekers around the world in multiple time zones. We also understand that students often keep crazy schedules. No problem. We are there for you around the clock. If you need help at any time, please contact us. An agent is always available for you.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Our services are second to none. Every time you place an order, you get a personal and original paper of the highest quality.

Essays

Essay Writing Service

While a college paper is the most common order we receive, we want you to understand that we have college writers for virtually everything, including: High school and college essays Papers, book reviews, case studies, lab reports, tests All graduate level projects, including theses and dissertations Admissions and scholarship essays Resumes and CV’s Web content, copywriting, blogs, articles Business writing – reports, marketing material, white papers Research and data collection/analysis of any type.

Admissions

Any Kind of Essay Writing!

Whether you are a high school student struggling with writing five-paragraph essays, an undergraduate management student stressing over a research paper, or a graduate student in the middle of a thesis or dissertation, homeworkmarketpro.com has a writer for you. We can also provide admissions or scholarship essays, a resume or CV, as well as web content or articles. Writing an essay for college admission takes a certain kind of writer. They have to be knowledgeable about your subject and be able to grasp the purpose of the essay.

Reviews

Quality Check and Editing Support

Every paper is subject to a strict editorial and revision process. This is to ensure that your document is complete and accurate and that all of your instructions have been followed carefully including creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Prices and Discounts

We are happy to say that we offer some of the most competitive prices in this industry. Since many of our customers are students, job seekers and small entrepreneurs, we know that money is a problem. Therefore, you will find better prices with us compared to writing services of this calibre.