Question

A. Multiple choice questions.
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 the 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 function returns the remainder after a number is divided by the divisor ?
(a) MOD
(b) POWER
(c) SUM
5. Which of the given cell references can be used in a relative reference?
(a) $D6
(b) A3
(c) A$1
6. Which function is used to count the number of numeric values in a range?
(a) Count( )
(b) SUM ( )
(c) COUNTNUMBERS ( )
​

Answer 1

Answer:

1)D4!sheet 1

2)Alt+=

3)Max

4)MOD

5)A3

6)Count