Digital Foundations Excel Project #2

• You will need to submit an Excel file for your assignment – not another type of file.
• The Excel file must allow me to see the formulas and functions used in order to qualify for credit. So if a question asks for the average body weight of the cars, and only the answer is provided and not the equation itself, full credit cannot be granted.
• You can ask questions on this assignment in the discussion forum, but responses should provide direction, not the answer themselves. (e.g. review the module on SumIf() function)
• The work you submit must be your own. 0 credit will be earned if the work submitted is not your own. SubmitYour submission must include:Appropriate StylingAll required formattingA footer as the assignment dictatesWhen You Are FinishedWhen you upload your XLSX assignment file, be sure you keep it in the same format/structure as the original assignment file.Be sure to add your last name to the assignment submission.

Maryville University Surplus
Sales of Surplus Technology
Product Number
Quantity Sold
Selling PriceTotal Sales Percent of Total Sales
Desktop Computer
DC-1
176
222.95
Mac
MAC-1
283
699.95
Mini Mac MM-1
152
299.5
iPad
iP-1
63
139.95
iPad mini iPMi-1
281
239.5
Apple TV APP-1
271
84.95
Monitor MO-1
176
75.99
Total Sales for All Products
No. Question
1 What were total sales for iPads?
What was the final number of Mac Minis
2 sold?
What was the total retail value of all
3 surplus Apple TVs?
Your
Response
Excel Project 2
ISYS 100 – Excel Project 2
Project Description:
In the following project, you will create a worksheet summarizing the sales of Maryville University surplus
technology that is no longer in use.
Instructions:
Perform the following tasks:
Step
Points
Possible
Instructions
1
Start Excel. Download and open the file named ISYS 100 – Excel 2 Project.
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.
4
3
Check spelling in your worksheet, and correct Menitors to Monitors. Widen column A to 140
pixels and columns B:F to 95 pixels.
2
4
In cell E4, construct a formula to calculate the Total Sales of the Balance by multiplying the
Quantity Sold by the Selling Price. Copy the formula down for the remaining products.
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.
5
5
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.
5
7
To the computed percentages, apply Percentage Style with two decimal places, and then
center the percentages.
4
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.
5
9
To the range D5:E10, apply the Comma Style.
2
10
Change the Retail Price of the Mac to 599.95 and the Quantity Sold of the Mac mini to 33.
2
1
ISYS 100 Excel Project 2.docx
Excel Project 2
Step
11
Points
Possible
Instructions
Delete column B.
3
12
Insert a new row 3. In cell A3, type Month Ending December 31 and then merge and
center the text across the range A3:E3. Apply the Heading 2 cell style.
5
13
To cell A12, apply the 20% – Accent1 cell style.
2
14
Select the four column titles. Apply Wrap Text, Middle Align, and Center formatting, and then
apply the Heading 3 cell style.
4
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. Change the Orientation to
Landscape.
5
16
Answer the 3 questions found on the “Questions” tab; put your answers in the proper cell in
column B. Each question is worth 4 points.
12
17
Save and close the workbook. Exit Excel. Submit the file in Canvas.
0
Total Points
2
65
ISYS 100 Excel Project 2.docx