Sumati has to calculate the average of a range of cells of a spread sheet. She…
2023
Sumati has to calculate the average of a range of cells of a spread sheet. She has to display the average of each row and sum of each column. She also has to display the average of all the rows and columns. Consider the range of cells from A1 to H100. Identify the correct answer which can be used by her.
- A.
[for rows = Average (A1 : A100)] [for columns = Sum (A1 : H1)] Copy to all rows and column
- B.
[for rows = Average (A1 : H1)] [for columns = Sum (A1 : A100)] Copy to all rows and column
- C.
[for rows = Sum (A1 : H1)] [for columns = Average (A1 : H100)] Copy to all rows and column
- D.
[for rows = Average (A1 : A100)] [for columns = Average (A1 : H1)] Copy to all rows and column and use it for entire sheet
- E.
Question not attempted
Attempted by 1140 students.
Show answer & explanation
Correct answer: B
To calculate the average of each row, use the formula Average(A1:H1) in the first row and copy it across to all columns. This will give the average of each row. To calculate the sum of each column, use the formula Sum(A1:A100) in the first column and copy it down to all rows. This will give the sum of each column. To calculate the average of all rows and columns, use the formula Average(A1:H100) in a separate cell. This will give the average of all the values in the range.