Sec 3 SST Recap

What is the argument in the following function?

= MIN(B1:B4)

• =

• MIN

• ( )

• B1:B4

Which formula would you use to find the sales of Gold in cell D3?

• =B3+C3

• =B3-C3

• =B3*C3

• =B3/C3

Which formula would you use to find the Total Sales in cell D5?

• =(D2:D4)

• =ADD(D2:D4)

• =SUM(D2:D4)

• =TOTAL(D2:D4)

Which function is used to calculate Victor’s daily average of hours of computer usage for the week?

• =AVERAGE(B7:G7)

• =(B7+C7+D7+E7+F7+G7+H7)/7

• =MIN(B7:H7)

• =SUM(B7:H7)

Which formula will change the daily average for Jun Wei to 2.8?

• =ROUNDDOWN(I5,0)

• =ROUNDDOWN(I5,1)

• =ROUNDUP(I5,0)

• =ROUNDUP(I5,1)

Which of the following formulas can be used to return the current date and time in cell B2?

• =CURRENT( )

• =NOW( )

• =TIME( )

• =TODAY( )

What is the output value in cell B5?

• 2

• 3

• 4

• 6

State the formula used to enter the largest number from A1:A5 in cell A6?

• =BIGGEST(A1:A5)

• =HIGHEST(A1:A5)

• =LARGEST(A1:A5)

• =MAX(A1:A5)