Functions : Count, Today , if

Which function would you use to count the number of numeric entries in the range A1:A10?

• COUNT(A1:A10)
• AVERAGE(A1:A10)
• SUM(A1:A10)
• MAX(A1:A10)

What function can you use to insert today's date into a cell in a spreadsheet?

• TODAY()
• DATE()
• NOW()
• CURRENT()

Which function would you use to evaluate if a number in cell B1 is greater than 10 and return 'Yes' if true and 'No' if false?

• IF(B1 > 10, 'Yes', 'No')
• SUMIF(B1 > 10, 'Yes')
• AVERAGEIF(B1 > 10, 'Yes')
• COUNTIF(B1 > 10, 'Yes')

How do you check if the value in cell C3 is equal to 100 and return 'Match' if true and 'No Match' if false?

• IF(C3 = 100, 'Match', 'No Match')
• EQUAL(C3, 100)
• IF(C3 == 100, 'Match', 'No Match')
• CHECK(C3 = 100, 'Match', 'No Match')

Which function would you use to calculate the total number of cells with numeric data in the range D1:D20?

• COUNT(D1:D20)
• AVERAGE(D1:D20)
• COUNTIF(D1:D20)
• SUM(D1:D20)

What function would you use to display the current date in a spreadsheet cell?

• TODAY()
• CURRENT_DATE()
• NOW()
• GETDATE()

If you want to return 'Pass' if the score in cell A5 is greater than or equal to 60, and 'Fail' otherwise, which function would you use?

• IF(A5 >= 60, 'Pass', 'Fail')
• CHECK(A5 >= 60, 'Pass', 'Fail')
• IF(A5 > 60, 'Pass')
• SELECT(A5 >= 60, 'Pass', 'Fail')

Which function helps you determine whether a value in cell B2 is less than 50 and return 'Low' if true and 'High' if false?

• IF(B2 < 50, 'Low', 'High')
• CHECK(B2 < 50, 'Low', 'High')
• CONDITIONAL(B2 < 50, 'Low', 'High')
• EVALUATE(B2 < 50, 'Low', 'High')

Which function would you use to count how many cells in the range E1:E15 contain numbers greater than 5?

• COUNTIF(E1:E15, '>5')
• SUMIF(E1:E15, '>5')
• COUNT(E1:E15)
• AVERAGEIF(E1:E15, '>5')

What function will you use to display both the current date and time in a cell?

• NOW()
• TIME()
• TODAY()
• CURRENT_DATE()