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()
Answers
Answered by
0
Answer:
1.Sheet1!D4
2.C
3.C
4.A
5.A
Similar questions
English,
5 months ago
Science,
5 months ago
English,
5 months ago
Social Sciences,
11 months ago
CBSE BOARD XII,
11 months ago
English,
1 year ago
English,
1 year ago