Excel Function

What does the AND function return in Excel?

• Multiple values

• TRUE or FALSE

How many conditions does the AND function take?

• Exactly two

• Two or more

Which symbol separates different parts of the AND function?

• Plus (+)

• Comma (,)

How are text values represented in the AND function?

• In parentheses ()

• In quotes (" ")

What does the IF function return?

• TRUE or FALSE

• Specified values based on a condition

What does the AVERAGE function do in Excel?

• Calculates the total sum

• Calculates the average

How is the AVERAGE function typed in Excel?

• =SUM

• =AVERAGE

How does the AVERAGE function calculate the average?

• Adds the range and multiplies it by the number of observations

• Adds the range and divides it by the number of observations

What type of mean does the AVERAGE function calculate?

• Arithmetic mean

• Geometric mean

What does the AVERAGE function ignore?

• Numbers

• Cells with text