Portfolio Unit 3

.xlsx

School

Indian River State College *

*We aren’t endorsed by this school

Course

1100

Subject

History

Date

Dec 6, 2023

Type

xlsx

Pages

Uploaded by GrandValor9759

Employee Time (hrs) Rate ($/hr) Pay ($) Napoleon 10 $8.75 $87.50 Deb 20 $9.00 $180.00 Rico 32 $40.00 $1,280.00 Me 40 $100.00 $4,000.00 Total pay $5,547.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