WorksheetsBU102YC-Office Productivity Apps -Functions
Total questions: 10
Worksheet time: 57mins
Chase wants to total all values in a column, what function would he use
=DATE
=MAX
=SUM
=IF
Tatiana is preparing a payroll spreadsheet (see image). What is the function that goes in F2?
=IF(D2>40, D2-40, 0)
=IF(E2>40, E2-40, 0)
=D2+E2
=B2*E2
Rokeeha is preparing a payroll spreadsheet (see image).. What is the function that goes in F6?
=AVG(F2:F5)
=SUM(F2:F5)
=F2:F5
=MAX(F2:F5)
Austin is preparing a payroll spreadsheet (see image). What is the result of the function =MAX(B2:B5)?
17
25.5
24
45
Lillian wants to write a function that returns the lowest number in a series of numbers. What function would she use?
=SUM
=LOW
=MIN
=AVERAGE
Christian is preparing a payroll spreadsheet (see image). What is the result of the function =AVERAGE(D2:D5)?
Note: Feel free to start a new spreadsheet to calculate.
40
40.25
39
40.75
Riley wants to calculate days based on the current date. What function would he use to for the CURRENT date?
=DATE
=MAX
=NOW
=IF
Refer to the image. Wesley wants to add 30 days to the Date of Service to calculate the 30 Day Payment Date. What is the formula or function that goes in F3?
=D3+30
=NOW
=Date+30
=E3+30
Fernanda wants to calculate the number of days between two dates. What function would she used?
=NOW360
=Date
=Date360
=DAYS360
Refer to the image. Hector wants to calculate 90 Days Past Due (column I) for outstanding balance. What is the formula or function that goes in I3?
=D3+60
=F3+60
=NOW+30
=E3+30
