8 Chapter 8
- Use Average, Count, Max, and Min
- With an Excel Workbook open, enter in the days of the week in cells B1 through H1 (Monday to Sunday)
- In cells B2 through H2 put in how many hours you worked each day (4,3,6,3,8,4,3)
- In Cell I1 put the title Average
- In Cell I2 type =AVERAGE(B2:H2) and hit the Enter key
- You should end up with 5.142857 – the average number of hours worked . Use your previous skills to make the Average 2 decimal places and you’ll end up with 5.14
- In Cell J1 type Count
- In Cell J2 type =Count(B2:H2) and hit the enter key
- You should end up with 7 – the number of cells with numbers in them.
- In Cell K1 type Max Hours
- In cell K2 type =Max(B2:H2) and hit the enter key
- You should end up with 8 – the maximum number of hours worked in that week
- In Cell L1 type Min Hours
- In Cell L2 type =Min (B2:H2) and hit the enter key
- You should end up with 3 – the least number of hours worked that week.
- Use Today, Now, and Date
- Using the same spreadsheet as above, click on Row 1 and insert a row using your previous skills.
- In cell A1 type =Today()
- This will put in today’s date. Notice that there is nothing in the brackets. That is because there is no need to type a cell or cell range, the function will put in Today’s date! Every time you open this spreadsheet it will reflect the date that it was opened.
- Delete what is in cell A1 and then type =Now()
- This will put in today’s date AND time. Notice that, similar to the today function, there is nothing in the brackets, the function will just put in today’s Date and Time. Every time you open this spreadsheet it will put in the new date and time it was opened.
- Delete cell A1 and type =DATE(2022,01,03)
- This will put in a date of 2022-01-03 or Jan 3rd 2022. If you want to keep a specific date in a cell instead of the date changing every time you open the worksheet use the Date function. You’ll need to put in arguments that reflect the Year, the Month, and the Day like this =DATE(YEAR,MONTH,DAY).
