Question

B. What happens when:
1. you double-click any active cell in MS Excel 2010.
2. the width of the column to display the output is less.
3. the value given for division is divided by 0.
4. you forget to put'='symbol before the formula.
5. you used an invalid operator.
C. Write the formulae to get the following results.
1. Add the values from cell A2:D2 and display the result in E2.
2. Find the average of values from C2:E2.
3. Find the minimum value from the numbers given in cells A2:A4.
4. Find the maximum value from the numbers given in cells B1:B6.
5. Find the count of values from cells A5:E12.

Pls tell all the answers.. If u do I will mark u as brilliant ​

Answer 1

Answer:

not understand your question sorry for it

Explanation:

please follow me and mark as brainlist

Answer 2

B. Answers to the given question:

1. Double clicking on the border of an active cell, the selected cell jumps to the first empty cell to the left in the same row or up in the same column.
2. The #### Error code is displayed when the column is not wide enough to display the output in the cell.
3. Microsoft Excel shows this #DIV/0! error when a value is divided by zero (0). It happens when you enter a formula like = 7/0.
4. If user forgets to put the '=' symbol before a formula, then the data is taken to be a Text value.
5. #NULL! error occurs when the two or more cells are separated incorrectly with an operator.

C. The formulae to get the following results:

1. In cell E2 = SUM (A2:D2)
2. formula =AVERAGE(C2:E2)
3. formula = MIN(A2:A4)
4. formula  = MAX(B1:B6)
5. formula = COUNT(A5:E12)

#SPJ2