Excel Functions: COUNT, Small & Large

What does the MAX function in Excel do?

• Calculates the average of a set of values.

• Finds the sum of a set of values.

• Returns the smallest value in a set of values.

• Returns the largest value in a set of values.

Explain the purpose of the MIN function in Excel.

• The MIN function returns the maximum value from a set of values.

• The MIN function calculates the average of a set of values.

• The MIN function multiplies all values in a set.

• The MIN function returns the minimum value from a set of values.

How is the COUNT function used in Excel?

• The COUNT function is used in Excel by typing '=MAX(' followed by the range of cells you want to count, and closing the parentheses.

• The COUNT function is used in Excel by typing '=AVERAGE(' followed by the range of cells you want to count, and closing the parentheses.

• The COUNT function is used in Excel by typing '=SUM(' followed by the range of cells you want to count, and closing the parentheses.

• The COUNT function is used in Excel by typing '=COUNT(' followed by the range of cells you want to count, and closing the parentheses.

Describe the syntax of the IF function in Excel.

• =IF(logical_test, value_if_false, value_if_true)

• =IF(logical_test, value_if_true, value_if_false)

• =IF(logical_test, value_if_true, value_if_false, value_if_false)

• =IF(logical_test, value_if_true)

When would you use the LARGE function in Excel?

• To find the nth largest value in a range of data.

• To format cells based on specific conditions.

• To calculate the average of a range of data.

• To find the smallest value in a range of data.

In what scenarios would you utilize the SMALL function in Excel?

• To calculate the average of a range of cells

• To format cells based on specific conditions

• In scenarios where you need to identify the nth smallest value in a dataset.

• To find the largest value in a dataset

What is the result of the MAX function if the input range is {5, 10, 15, 20, 25}?

• 30

• 25

• 10

• 18

If the MIN function is applied to the range {30, 25, 20, 15, 10}, what value would it return?

• 5

• 18

• 10

• 22

How many cells with numerical values are counted using the COUNT function in the range {10, 'apple', 20, 'orange', 30}?

• 4

• 2

• 3

• 1

If the IF function is written as =IF(A1>10, 'Yes', 'No'), what would be the output if A1 contains the value 15?

• No

• Yes

• Maybe

• Sometimes