Advanced Microcomputer Applications, programming homework help

W3Microsoft Excel Assignment “Gym Sales”

Do Project 1E Gym Sales that begins on page 406 of your textbook. Submit the document by clicking the Attachments button to attach the file. Do not paste the document in the Message area.

You will need to download and use the following data file to complete this assignment: 1E Data File

In addition to the assignment file, answer the following question with your submission. This can be answered directly in your Submission comment area, or as a separate Word attachment file:

In this Week’s reading and prep work, you learned about the Sparklines feature in Excel. What are the three types of Sparklines options in Excel, and provide an example of how you might use at least one of these either in a personal worksheet or something in the workplace. Please look to answer this in at least 3 complete sentences in order to address it adequately. CONTENT-BASED ASSESSMENTS (MASTERY AND TRANS
Mastering Excel Project 1 E Gym Sales
In the following Mastering Excel project, you will create a worksheet comparing
the sales of different types of home gym equipment sold in the second quarter. Your
completed worksheet will look similar to Figure 1.58.
PROJECT FILES
For Project 1E, you will need the following file:
e01E_Gym_Sales
You will save your workbook as:
Lastname_Firstname_1E_Gym_Sales
PROJECT RESULTS
Trend
Basic Home Gym
Deluxe Home Gym
Mutfifunctional Trainer
Bile Home Gym
Total
Pro Fit Marietta
Second Quarter Home Gym Sales
April
May
June
Total
$
137,962.96 $ 92,897.98 $ 122,667.61 $ 353,528.55
125,737.15 129,614.62
98,062.92 353,414.69
87,955.66
92,986.05 121,011.04 301,952.75
137,727.85 121,691.64 128,964.64 388,384.13
$ 489,383.62 $ 437,190.29 $ 470,706.21 $ 1,397,280.12
Second Quarter Home Gym Sales
$160,000.00
3140,000.00
$120,000.00
$100,000.00
$80,000.00
$60,000.00
$40,000.00
$20,000.00
$
May
Apra
Basic Home Gym Deluxe Home Gym Mutfunctional Trade Made Home Gym
CONTENT-BASED ASSESSMENTS (MASTERY AND TRANSFER OF LEARNING
Mastering Excel Project 1E Gym Sales (continued)
9 To compare the monthly sales of each product
Start Excel and then on the opening screen, in the
visually, select the range that represents the sales figures
lower left, click Open Other Workbooks. Click Browse,
and then navigate to your student data files for this for the three months, including the month names and the
chapter. Open the file c01_1E_Gym_Sales. Click the File product names—do not include any totals in the range.
tab, on the left click Save As, and then click Browse. In With this data selected, use the Recommended Charts
the Save As dialog box, navigate to your Excel Chapter 1
command to insert a Clustered Column chart with the
folder, and then using your own name, save the file as month names displayed on the category axis and the
product names displayed in the legend.
10 Move the chart so that its upper left corner is
range C3:03.
Lastname_Firstname_1E_Gym_Sales
2 Change the theme to Wisp.
3 In cell B3, use the fill handle to fill the months May
and June in the
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; this will
display the legend on one row and, after you add the
sparklines, center the chart below the data.
range A1:F1,
4 Merge & Center the title across the
and then apply the Title cell style. Merge & Center
the subtitle across the range A2:F2, and then apply the
Heading 1 cell style. Center the column titles in the
range B3:F3.
11 Apply Chart Style 6 and Color 2 under Colorful.
Change the Chart Title to Second Quarter Home Gym
Sales
5 Widen column A to 180 pixels, and then widen
columns B:F to 115 pixels. In the range B7:17, enter the
monthly sales figures for the Elite Home Gym as shown
in the table below:
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.
13 Center the worksheet Horizontally on the page, and
then insert a Footer with the File Name in the left section.
April
May
June
Elite Home
Gym
137727.85
121691.64
128964.64
6 In cell B8, on the Home tab, use the AutoSum
command to sum the April sales. Copy the resulting
formula across to cells C8:D8 to sum the May monthly
sales and the June monthly sales. In cell E4, use the
AutoSum button to sum the Basic Home Gym sales. Copy
the formula down to cells E4:E8.
14 Change the Orientation to Landscape. Display the
document properties, and then as the Tags type home
gym, sales As the Subject, type your course name and
section number. Be sure your name displays as the
Author. Check your worksheet by previewing it in Print
Preview, and then make any necessary corrections.
15 Save your workbook. By using the techniques
you practiced in Project 1A and as directed by your
instructor, print, create a PDF image that looks like a
printed document, or submit your completed Excel file. If
required by your instructor, print or create an electronic
1 Apply the Heading 4 cell style to the row titles and
the column titles. Apply the Total cell style to the totals
in the range
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.
range B8:E8.
version of your worksheet with formulas displayed. In the
upper right corner of your Excel window, click Close.
END | You have completed Project