Excel Functions and Formulas Quiz

What does the COUNTA function do in Excel?

• Reformats text to make the first letter of each word upper case and other letters lower case

• Returns the number of characters in a string

• Finds the arithmetic mean of a range of cells

• Counts the nonblank cells in a range

What is the purpose of the Cancel/Enter buttons in Excel?

• Show the underlying formulas of the selected cell

• Insert the SUM function into the selected cell

• Open the Function Arguments dialog box

• Perform the same action as pressing Esc on your keyboard

Which function in Excel returns the highest or lowest number in a range of cells?

• MAX and MIN Functions

• AVERAGE

• COUNT

• CONCAT

What does the CONCAT function do in Excel?

• Reformats text to make the first letter of each word upper case and other letters lower case

• Returns the number of characters in a string

• Takes multiple inputs and concatenates them into a single string

• Finds the arithmetic mean of a range of cells

What is the purpose of the AutoSum feature in Excel?

• Finds the arithmetic mean of a range of cells

• Inserts the SUM function into the selected cell

• Opens the Insert Function dialog box

• Counts the nonblank cells in a range

Which function in Excel concatenates multiple items using a delimiter?

• LEFT and RIGHT

• TEXTJOIN

• UPPER and LOWER

• MID

What does the MID function do in Excel?

• Returns the number of characters in a text string

• Reformats text to make the first letter of each word upper case and other letters lower case

• Returns characters from the middle of a text string

• Reformats text to all upper or lower case letters

What is the purpose of the Formula Bar in Excel?

• Performs the same action as pressing Esc on your keyboard

• Opens the Function Arguments dialog box

• Inserts the SUM function into the selected cell

• Shows the underlying formulas of the selected cell

Which function in Excel returns the number of characters in a text string?

• CONCAT

• TEXTJOIN

• LEN

• LEFT and RIGHT

What does the PROPER function do in Excel?

• Returns characters from the middle of a text string

• Finds the arithmetic mean of a range of cells

• Reformats text to all upper or lower case letters

• Reformats text to make the first letter of each word upper case and other letters lower case