ZuoTi.Pro
Question

4) Use a spreadsheet analysis to determine the total miles driven by each driver and the average miles driven in each categor
engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

1. Formula for total :

=SUM(Starting Cell:Ending Cell)

for example :

Formula for total miles drive by "Geske"

=SUM(B2:D2)

2. Formula for average :

=AVERAGE(Starting Cell:Ending Cell)

for example :

Formula for average miles drive in City Miles

=AVERAGE(B2:B7)

Screenshot :

Untitled spreadsheet File Edit View Insert Format Data Tools Add-ons Help na 100% - $ % 0 .00 123- Default (Ar... - All chang

0 0
Add a comment
Know the answer?
Add Answer to:
4) Use a spreadsheet analysis to determine the total miles driven by each driver and the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Partial payments are made on the dates indicated. Use the United States rule to determine the...

    Partial payments are made on the dates indicated. Use the United States rule to determine the balance due on the note at the date of maturity. (The Effective Date is the date the note was written.) Assume the year is not a leap year. Effective Partial Payment Maturity Principal Date Amount Date Date $1900 19% Sept. 1 $500 Oct. 1 Dec. 1 $500 Nov. 1 Click the icon to view a table of the number of the day of the...

  • A partial payment is made on the date indicated. Use the United States rule to determine...

    A partial payment is made on the date indicated. Use the United States rule to determine the balance due on the note at the date of maturity. (The Effective Date is the date the note was written.) Assume the year is not a leap year. Effective Partial Payment Maturity Principal Rate Date Amount Date Date $4000 4% April 1 $1000 May 1 June 1 Click the icon to view a table of the number of the day of the year...

  • Please determine the IDENTITY of the unknown compound and explain how each peak / data point...

    Please determine the IDENTITY of the unknown compound and explain how each peak / data point from the following instruments led to that identification. What does the gcms indicate. Thank you very much! (The GCMS data is just a long set of numbers which is why the question appears so long). IR of unknown: NMR unknown Proton Graphs (first is overall graph, others that follow are zoomed in sections): NMR unknown Carbon Graphs (first is overall graph, others that follow...

  • I need help understanding what I need to do to complete this spreadsheet (steps on how...

    I need help understanding what I need to do to complete this spreadsheet (steps on how to start it) in Excel, thank you! Spreadsheet Assignment 2 Riesk and Return Historical Data NSTRUCTIONS listorical price data are obtained for Stocks X, Y, Z. To erform the required analysis, as demonstrated in the preadsheet modeling video, first calculate the rates f return for each stock. Then use the RETURNS data not price) to perform the required analysis. Please be ure to watch...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT