Excel Functions and Formulas Quiz

What is the basic syntax of a function in Excel?

• =FunctionName(Arguments)
• =Arguments(FunctionName)
• =FunctionName=Arguments
• =FunctionName:Arguments

Which function would you use to find the average of a set of numbers?

• SUM
• AVERAGE
• COUNT
• MAX

What does the COUNT function do?

• Counts all cells
• Counts only cells with text
• Counts only cells with numerical data
• Counts empty cells

If you want to add the values in cells A1 to A10, which function would you use?

• =ADD(A1:A10)
• =SUM(A1:A10)
• =TOTAL(A1:A10)
• =SUMMATION(A1:A10)

What is the purpose of the AutoSum command?

• To automatically format cells
• To insert common functions quickly
• To create charts
• To delete cell contents

How can you access the Function Library in Excel?

• From the Home tab
• From the Formulas tab
• From the View tab
• From the Data tab

What does the MAX function do?

• Finds the minimum value
• Finds the maximum value
• Calculates the average
• Counts the number of cells

Which function would you use to count non-empty cells?

• COUNT
• COUNTA
• SUM
• AVERAGE

What is the result of the function =SUM(A1:A3, C1:C2, E1)?

• Adds values from A1 to A3 only
• Adds values from A1 to A3 and C1 to C2 and E1
• Calculates the average of A1 to A3
• Counts the number of cells

What is the purpose of the Insert Function command?

• To delete functions
• To search for functions
• To create new functions
• To format functions