Data Analysis Quiz

What is the basic syntax for a function?

• Minus sign, function name, and arguments

• Plus sign, function name, and arguments

• Equals sign, function name, and arguments

• Division sign, function name, and arguments

Which function finds the sum of cells A1 through A100?

• MAX

• SUM

• AVERAGE

• MIN

What does the COUNT function do?

• Calculates the sum of values based on a condition

• Finds the average of cells

• Counts the number of cells with numerical data

• Returns the highest number from cells

Which operator returns TRUE if D1 is less than F8?

• >

• <

• <=

• <>

• >=

What does the VLOOKUP function allow?

• Counts cells as specified

• Horizontal searches for values

• Vertical searches for values

• Calculates the sum of values based on a condition

What does the CONCAT function do?

• Calculates the average of a range

• Removes irregular spacing

• Assigns a rank to a number

• Links together the content of multiple cells

Which function removes irregular spacing, leaving one space between each value?

• VLOOKUP

• TRIM

• RANK

• CONCAT

What is the purpose of the COUNTA function?

• Links together the content of multiple cells

• Calculates the sum of values based on a condition

• Allows vertical searches for values

• Counts all cells in a range that has values

Which function calculates the average of a range based on a TRUE or FALSE condition?

• VLOOKUP

• AVERAGEIF

• COUNTIF

• SUMIF

What does the RANK function do?

• Calculates the sum of values based on a condition

• Counts all cells in a range that has values

• Assigns a rank to a number

• Removes irregular spacing