Question

1. what formula function would you use to get the maximum of a group of numbers?

count
average
max
sum

1. what formula function would you use to get the count of a group of numbers?

count
max
average
sum

Explanation:

• For question 9:
• The COUNT function is used to count the number of cells in a range that contain numbers.
• The AVERAGE function calculates the arithmetic mean of a set of numbers.
• The MAX function returns the largest value in a set of values.
• The SUM function adds up a range of numbers.
• For question 10:
• As mentioned above, the COUNT function is for counting the number of cells with numbers.
• MAX is for finding the maximum value.
• AVERAGE is for calculating the average.
• SUM is for adding numbers.

Answer:

1. MAX
2. COUNT