Question

D. Multiple Choice Questions:
1. To use the Sheet reference, which address is appropriate ou
address is anpropriate out of the following options
a. D4! Sheet1
b. Sheet1, D4
C. Sheet1! D4
which key combination is used to get the sum of the values of adjacent cells?
a. Shift + S
b. Ctrl +'
c. Alt + =
3. Which function finds the largest number in a range?
a. AVERAGE() b.COUNT() C. MAX()
4. Which of the given cell references can be used in a relative reference?
a. $D6
b. A3
C. A$1
5. Which function is used to count the number of numeric values in a range?
a. COUNT() b. SUMC) C. MAX()​

Answer 1

Answer:

1) ans - b) Sheet1! D4

2) ans- c) alt+=

3) ans- c) max()

4) ans- sry don't know the ans

5) ans- a) count()

Explanation:

hope it will help

Answer 2

Answer:

1)b

2)c

3)c

4)b

5}a

......