ISYS 100: Digital foundations working with excel

• 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.

Submit

Your submission must include the following:

• The theme as specified by the assignment
• Use of AutoSum function
• A Clustered Column Chart that shows:Month NamesProject Names
• All required formatting
• Accounting Number format where required
• A footer as the assignment dictates
• Multiple Sheets

When You Are Finished

• When 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.

Important Note

• Since there are multiple ways to accomplish goals in Excel, make sure you use the learning modules within the course to answer and solve these problems. To ensure full credit, you must demonstrate that you’re using the elements taught in the learning modules. Let me know if you have any questions about this.

Please do not wait until the last minute to ask questions. Ideally, students can work through this assignment while reviewing the learning modules.

Excel Project 1
ISYS 100 – Excel Project 1
Project Description:
In the following project, you will create a worksheet comparing the sales of different food items sold in Gander
Hall at Maryville University. This data is not factual.
Instructions:
Perform the following tasks:
Step
Points
Possible
Instructions
1
Start Excel. Download and open the file named ISYS 100 Excel Project 1.
0
2
Change the worksheet theme to Wisp.
2
3
Use the fill handle to enter the months May and June in the range C3:D3.
3
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.
5
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.
In the range B7:D7, enter the following values: 137727.85, 121691.64, and 128964.64.
5
6
In cell B8, use the AutoSum button to sum the April food sales. Fill the formula across to cells
C8:D8. In cell E4, use the AutoSum button to sum the total hamburger sales. Fill the formula
down to cells E4:E8.
5
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.
3
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.
3
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.
5
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.
3
1
ISYS 100 Excel Project 1.docx
Excel Project 1
Step
Points
Possible
Instructions
11
Apply Chart Style 6 and Color 2 under Colorful. Change the Chart Title to Fall Semester
Food Sales.
5
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.
5
13
Center the worksheet Horizontally on the page, and then insert a Footer with the File Name in
the left section.
5
14
Change the Orientation to Landscape.
4
15
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
16
Save the file by adding your last name to the end of the filename and close the document.
Exit Excel. Submit the file in Canvas.
0
Total Points
2
65
ISYS 100 Excel Project 1.docx
Gander Hall
Fall Semester Food Sales
April
Total
Hamburgers 137963 92897,98 122667,6
Fish Sandwiches
125737,2 129614,6 98062,92
Salads
87955,66 92986,05 121011
Pizza slices
Total
Trend
No. Question
1 Which month had the highest food sales?
Which type of food was sold most on
2 average?
What are the top 2 food items sold most in
3 the month with the least overall sales?
Your
Response