Question

1 What will be the cell address of a cell falling in column D and row 5?
(a)D-5 (b)D,5 (c)D:5
(d) D5
2. How will you refer a range containing cells c2, C3, C4, C5, D2, D3, D4, D5, E2, E3, E4 and E5?
(a) C2-E5
(b) C2, E5
(c) C2:E5
(d) C2 to E5
3. Which of the following is not found in Home tab of MS-Word window but found in Home tab of
MS-Excel window?
(a) Clipboard group
(c) Editing group
(d) Cells group
4. A formula in a cell must start with the following character :
(a) #
(b) =
(c) $
(d) @
5. Which of the following is not a correct type of reference in Excel?
(a) Absolute
(b) Relative
(c) Mixed
(d) Comparative
6. A formula filled in a cell may be up to :
(a) 256 Characters
(b) 255 Characters
(c) 8192 Characters
(d) No limit
7. How many columns are there in an Excel worksheet?
(a) 256
(b) 16384
(c) 1024
(d) No limit
8. A collection of worksheets is called:
(a) Workbook
(b) Excel file
(c) Excel document
(d) All of these
9. By default the date in Excel is entered in the following format :
(a) DD-MM-YY
(b) DD/MM/YY (c) MM/DD/YY
(d) YY/MM/DD
10. Which of the following is not a built-in function in Excel?
(a) TOTAL
(b) SUM
(c) MAX
(d) AVERAGE​

Answer 1

Explanation:

answer.answer.answer

Answer 2

Answer:

1. D5

2. C2:E5

3. as mentioned in question all three are present

4. =

5. comparative

6. 8192 character

7. 16384 columns

8. workbook

9.MM/DD/YY

10. average

hope it helps :)