Question

Your manager has requested you keep a timesheet showing how many hours you work each day and what projects you work on during that time. Using spreadsheet software, how can you total your hours at the end of each week to provide a quick and accurate amount? Use the MIN and MAX functions. Use the AVERAGE function. Use the SUM function.

A: Use the MIN and MAX functions.
B: Use the AVERAGE function.
C: Use the SUM function.

Answer 1

I had to use Microsoft Excel for a while when I was working as a dispatcher, inputting pricing and hours and such. C Would be the correct answer.

Step-by-step explanation:

Average function would just average out the entire week. Though, if the entire week was 8 hours a day, the average would indeed be 8 hours. But it is not the correct answer if one assumes it's not steady like that. Min and Max, depending how it is setup will find the minimum number, and or the maximum number. Making that incorrect as well.