Unit 3 Excel Assignments
Excel 3.1 – How to use Scatter Plot to Plot Points
Submit on Canvas an Excel file (.xslx file) with the work “HELP” spelled out by plotting points using Excel’s
scatter plot feature. I would suggest making a sketch on paper to get started with what scale & coordinates you
want to use.
For example, here is the word Hi.
0.8
1
1.2
1.4
1.6
1.8
2
2.2
2.4
2.6
0
1
2
3
4
5
6
7
Excel 3.2 – Making Table & Graphs on Excel
Submit on Canvas an Excel file (.xslx file) that shows the revenue and cost of the business described below in
table and graph format.
A few friends are looking into starting a business selling hand crafted mead.
They plan on selling bottles of
mead for $27, and it will cost approximately $9 to produce each bottle.
To set up a bottling and production
area they expect to spend $5,940.
Make a table for the revenue, cost & profit of the business for selling 0, 10,
20, 30,… all the way up to 500 bottles (by 10).
Then, make a graph of the revenue and cost, and make a
separate graph for the profit. How many bottles of mead must be sold to break even?
