Question

Use the Excel worksheet data below to solve the following questions.

H
1
J
5
6
7
7
8
5
do 00
9
10
A
12
8
11
9
T
9
3
4
w
9
11
12
13
14
15
17
15
7
M
column H 2n cicle de genula
ingles are creation CHF HIM)
2. Write the function that would find the average cells in
(2 marks)
3. Write the function that would find the total values in column J (2 marks)
4. Write the function that would count all values.
(2 marks)
5. Write the function that would count the number of
occurrences of 9 in the entire range
(3 marks)

Answer 1

I love Microsoft Excel!

Step-by-step explanation:

2 - The function that would find the average of a particular range is =AVERAGE(). This is used to find the average of something by calculating the arithmetic mean (or just "mean").

3 - The function that would find the total values within a particular range---or in this case, Column J---you would use the =SUM() function. This will add up all of the values in the range you selected. An example could be that Column X has the values of 5, 6, 12, 45, 3. =SUM(X1:X5) = 71.

4 - The function that would count all values is defined as =COUNT(). An example would be =COUNT(A1:A10).

5 - The function that would count the number of occurrences within a particular range is defined as =COUNTIF(). Within the parentheses, you would put the range of data that you are working with. Then, in quotations, you would put the name or value that you are trying to find.

In your case, it would be =COUNTIF(range,"9") ((I put range in there since I do not know what your range is as it is not defined within the context of this question))