Question

1. To use the Sheet reference, which address is appropriate out of the following options?
a. D4!Sheet1
b. Sheet1,D4
c. Sheet1!D4
2. 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. SUM()
C. MAX()​

Answer 1

Answer:

1.Sheet1!D4

2.C

3.C

4.A

5.A