Question

53.the error #value occurs if the number is divided by zero.
True or false?
54.to use this sheet reference which address is appropriate out of the following
option
A.D4!sheet1
B.sheet1.d4
C.sheet1!d4
55.Which key combination is used to get the sum of the values of adjacent cells?
A.shift+s
B.ctrl+
C.alt+=
56. Which function finds the largest number in a range?
A. Average
B. Count
C.max
57. Which of the given cell reference can be used in relative reference?
A.$d6
B.a3
C.A$1
58. Which function is used to count the number of numeric values in a range?
A.count
B.sum
C.countnumber
59.Compound formulas are used when more than one operator is required to
perform calculation.​

Answer 1

Answer:

53.the error #value occurs if the number is divided by zero.

True or false?

54.to use this sheet reference which address is appropriate out of the following

option

A.D4!sheet1

B.sheet1.d4

C.sheet1!d4

55.Which key combination is used to get the sum of the values of adjacent cells?

A.shift+s

B.ctrl+

C.alt+=

56. Which function finds the largest number in a range?

A. Average

B. Count

C.max

57. Which of the given cell reference can be used in relative reference?

A.$d6

B.a3

C.A$1

58. Which function is used to count the number of numeric values in a range?

A.count

B.sum

C.countnumber

59.Compound formulas are used when more than one operator is required to