Excel Functions

What does this formula return if A1 = 6? =IF(A1>5, "Pass", "Fail")

• Fail

• Pass

• Error

• TRUE

What does this formula do? =COUNTIF(A1:A5, ">50")

• Adds all numbers above 50

• Counts numbers above 50

• Counts all cells

• Finds the largest number

What does =COUNTIFS(A1:A5, ">50", B1:B5, "<100") count?

• Values >50 in A1:A5 only

• Values <100 in B1:B5 only

• Rows where A >50 and B <100

• All cells in both columns

What does this do? =SUMIF(A1:A5, ">10")

• Sums all values in A1:A5

• Sums values above 10 only

• Counts values above 10

• Shows the largest number

What is the purpose of VLOOKUP()?

• To sort data

• To search vertically and return a value

• To count items

• To find averages

=HLOOKUP("Math", A1:D2, 2, FALSE) returns:

• "Math"

• A match from column

• A value from row 2 under "Math"

• An error

What does =SUM(5, 10, 15) return?

• 15

• 30

• 5

• 10

What does =MIN(8, 3, 12) return?

• 12

• 3

• 8

• 23

What does =MAX(2, 18, 9) return?

• 2

• 9

• 18

• 0

What is the average of 10, 20, and 30? Formula: =AVERAGE(10, 20, 30)

• 10

• 20

• 30

• 15