summer melrose portoflio 3
xlsx
keyboard_arrow_up
School
Indian River State College *
*We aren’t endorsed by this school
Course
1100
Subject
History
Date
Dec 6, 2023
Type
xlsx
Pages
8
Uploaded by ChancellorSandpiperPerson591
Employee
Time (hrs)
Rate ($/hr)
Pay ($)
Napoleon
10
$8.75
$87.50
Deb
20
$9.00
$180.00
Rico
32
$10.00
$320.00
Me
40
$100.00
$4,000.00
Total pay
$4,587.50
Enter any rates you like in cells C3, C4, an
Enter a formula in cell D2 to calculate the
check on whether your formula is correct
$87.50. Then use the auto-fill feature to d
D3, D4, and D5.
Formula for cell D2
= B2*C2
Click on cell D2
Hover over cell D2 until you see a black cr
corner. Then click and drag to cell D5
Enter a formula in cell D6 to calculate the
employees.
Formula for cell D6
=sum(D2:D5)
nd C5.
e pay for Napoleon.
As a
t, the value should remain
determine the pay for cells
ross in the lower right hand
e total pay for all 4
Total Cost
0
$0
5
$45
10
$90
15
$135
20
$180
25
$225
30
$270
Pizzas
Bought
Graph the values in columns A and B, and place your
graph below:
Highlight all data -> Insert -> Scatter
Based on your class work from this lesson, enter a
formula in cell B2 that uses the number of pizzas bought
in cell A2 to give the total cost for that number of pizzas.
If done correctly, the value should remain $0.
Then use
the auto-fill feature to complete column B.
Provide an
explanation here of how the formula you used in column
B relates to the equation of the line you found in class.
In class, we had C = 9p
Formula for cell B2
=9*A2
Click on cell B2; hover over the lower right corner until you
see a black cross. Then click and drag to cell B8
0
5
10
15
20
25
30
35
$0
$50
$100
$150
$200
$250
$300
Total Cost
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Total Cost
0
$10
5
$55
10
$100
15
$145
20
$190
25
$235
30
$280
Pizzas
Bought
Graph the values in columns K and L, and place your
graph below:
Highlight all data -> Insert -> Scatter
Based on your class work from this lesson, enter a
formula in cell L2 that uses the number of pizzas bought
in cell K2 to give the total cost for that number of pizzas.
If done correctly, the value should remain $10.
Then use
the auto-fill feature to complete column L.
Provide an
explanation here of how the formula you used in column
L relates to the equation of the line you found in class.
In class, we had C = 10 + 9p
Formula for cell L2
= 10 + 9*K2
Click on cell L2; hover over the lower right corner until you
see a black cross. Then click and drag to cell L8
0
5
10
15
20
$0
$50
$100
$150
$200
$250
$300
Total Cost
25
30
35
0
99
0
2
174.18
93.98
4
249.36
187.96
6
324.54
281.94
8
399.72
375.92
10
474.9
469.9
12
550.08
563.88
Boxes of
Diapers
Bought
Cost with
Membership
Cost without
Membership
Cost with Membership: C = 99 + 37.59x
Cost without Membership: C = 46.99x
1. Click on cell B2
2. Type the following:
= 99 + 37.59*A2
3. Click on B2 and hover over the black bo
until it becomes a cross. Then click and dr
1. Click on cell C2
2. Type the following
=
46.99*A2
3.Click on C2 and hover over the black box
until it becomes a cross. Then click and dr
Finally, highlight all of the data (including
with the dots connected
Answer: When should you join Amazon Family?
-You should join amazon family when
ordering/using more than 10 boxes of diapers.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
ox in the lower right hand corner
rag to cell B8
x in the lower right hand corner
rag to cell C8
row 1) and insert a scatter plot
0
2
4
6
8
10
0
100
200
300
400
500
600
Chart Title
Cost with Membership
Cost without Membership
12
14
p