You have been asked by the AUM student efficiency committee to create a weekly time tracking...

  

Transcribed Image Text:

You have been asked by the AUM student efficiency committee to create a weekly time tracking workbook for students. The requirements for the workbook are as follows: Create a column, with a header, for activities (do this in column A) Create columns, with headers, for each day of the week (starting in column B) Create rows, with labels, for the following activities: o Four AUM classes (make up the class name and put each class in a separate row) o Sleeping o Recreation Make all cells under the days of the week (for each activity) user input cells Make up and input the number of hours that you spend each day for each activity Create a new row below the activities that calculates the total time spent each day (Use a function for this calculation) Add new columns, with headers, that calculate the minimum daily time, the average daily time, and the maximum daily time spent on each activity for the week (Use functions for these calculations) You have been asked by the AUM student efficiency committee to create a weekly time tracking workbook for students. The requirements for the workbook are as follows: Create a column, with a header, for activities (do this in column A) Create columns, with headers, for each day of the week (starting in column B) Create rows, with labels, for the following activities: o Four AUM classes (make up the class name and put each class in a separate row) o Sleeping o Recreation Make all cells under the days of the week (for each activity) user input cells Make up and input the number of hours that you spend each day for each activity Create a new row below the activities that calculates the total time spent each day (Use a function for this calculation) Add new columns, with headers, that calculate the minimum daily time, the average daily time, and the maximum daily time spent on each activity for the week (Use functions for these calculations)

Answer rating: 100% (QA)

the tables below shows the column... View the full answer