Overview
It's
now time to apply all that you have learned so far in this course. For this
assignment you will use the file below to enter and manipulate data comparing
Maryville Gander Dining Hall prices across 3 months of (fictitious) sales.
To Get
Started
Using
the files below, follow the instructions to compare the data provided. Your
submission must include:
·
The theme as specified by the assignment
·
Use of AutoSum function
·
A Clustered Column Chart that shows:
o Month Names
o Project Names
·
All required formatting
·
Accounting Number format where required
·
A footer as the assignment dictates
·
Multiple Sheets
ISYS 100 Excel Project 1 -
Instructions.docx
ISYS 100 - Excel 1
project.xlsx
Your
submission must also include responses to these questions (25 points):
1.
Which month had the highest food sales?
2.
Which type of food was sold most on average?
3.
What are the top 2 food items sold most in the month with the
lease overall sales?
You may
answer these questions by creating a new tab in the excel sheet you are
submitting. Name this tab "Questions".
A Few
Guidelines:
·
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.
When
You Are Finished:
·
When you upload your XLSX assignment file, be sure you keep it
in the same format / structure of the original assignment file. Be sure
to add your last name to the assignment submission.
Important
Notes
Since
there are multiple ways to accomplish goals in Excel, make sure that you are
using the learning modules within the course to answer and solve these
problems. To ensure full credit, you need to demonstrate that you're using the
elements taught in the learning modules. Let me know if you have any questions
about this.
Questions: Please do not wait until
the last minute to ask questions. Ideally, students can work through this
assignment while going through the learning modules.
Get Free Quote!
273 Experts Online