Excel Functions Quiz

What is the primary purpose of the SUM function in Excel? Choose the best answer for each question.

• To count the number of cells in a range

• To calculate the average of a range of numbers

• To total up a selected range of numbers

• To find the maximum value in a range

When using the SUMIF function, what is required as the second argument? Choose the best answer for each question.

• The sum range

• The criteria to filter the data

• The cell reference

• The average value

If you wanted to sum sales from the "South" region using SUMIF, which of the following would be the correct criteria? Choose the best answer for each question.

• "South"

• South

• 'South'

• "South Region"

What distinguishes the SUMIFS function from the SUMIF function? Choose the best answer for each question.

• SUMIFS can only use one criterion

• SUMIFS can sum numbers based on multiple criteria

• SUMIFS is used for text data only

In the context of the video, what would be an example of a valid criteria for the SUMIFS function?

• greater than 10

• Lannister

• North

• All of the above

When entering criteria in the SUMIFS function, why are quotation marks necessary?

• They indicate the end of the formula

• They are used to define text strings

• They separate different criteria

• They are optional

If the result of a SUMIF function is 57,000, which of the following could be a reason for this result?

• The total of all sales from the "North" region

• The total number of customers in the "North" region

• The average sales from the "North" region

• The maximum sales figure from the "North" region

Based on the video, which of the following statements is true regarding the use of SUMIF and SUMIFS?

• SUMIF is used for summing numbers based on one criterion, while SUMIFS can handle multiple criteria.

• SUMIF can only be used for text data, while SUMIFS can handle numerical data.