Google Sheets Functions Quiz

What does the TRIM function do in Google Sheets?

• Removes extra spaces from text

• Combines multiple cells into one

• Looks up a value in a table

• Calculates the average of a range

Which function is used to combine text from multiple cells?

• VLOOKUP

• TRIM

• CONCATENATE

• SUMIF

What is the purpose of the VLOOKUP function?

• To calculate the sum of a range

• To find a value in a vertical column

• To remove spaces from text

• To average a set of numbers

Which function would you use to look up data horizontally?

• HLOOKUP

• SUMIFS

• AVERAGEIF

• TRIM

What does the SUMIF function do?

• Adds numbers based on a condition

• Calculates the average of a range

• Looks up a value in a table

• Combines text from multiple cells

What is the difference between SUMIF and SUMIFS?

• SUMIF is for horizontal data, SUMIFS is for vertical

• There is no difference

• SUMIF averages data, SUMIFS sums data

• SUMIF uses one condition, SUMIFS uses multiple

Which function calculates the average based on a condition?

• CONCATENATE

• TRIM

• SUMIF

• AVERAGEIF

What does the AVERAGEIFS function do?

• Looks up a value in a vertical column

• Adds numbers based on a single condition

• Calculates the average based on multiple conditions

• Removes extra spaces from text

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

• AVERAGEIF

• TRIM

• SUMIF

• HLOOKUP

What is the primary use of the CONCATENATE function?

• To remove spaces from text

• To combine text strings

• To calculate the sum of a range

• To find a value in a table