Computer Fundamentals MCQ – MS Excel Quiz

1. The intersection of column and rows in Microsoft Excel worksheet is called __________.

1. Column
2. Cell
3. Address
4. Schema

Answer

2. Which of the following features allow the display of only required data in a column as per the specified criteria?

1. Sorting
2. Pivot
3. Filtering
4. Searching 

Answer

3. Any formula or a function in Excel starts with ________ .

1. ( ) Sign
2. = Sign 
3. ; Sign 
4. # sign 

Answer

4. Which of the following options are helpful in arranging the data of a column in ascending or descending order?

1. Arranging
2. Sorting
3. Sequencing
4. Filtering

Answer

1. Cell
2. Table
3. Row
4. Column

Answer

1. 3
2. 5
3. 7
4. 10

Answer

1. Numbers
2. Letters
3. Both numbers and letters
4. All of the above

Answer

8. Column in MS Excel is identified by _________.

1. Numbers
2. Letters
3. Both numbers and letters
4. All of the above

Answer

1. Cell range
2. Multi cell
3. Cell cluster
4. Chart

Answer

1. #B#2
2. $B$2
3. B2
4. B:2

Answer

11. Which of the following are the valid way of adding the cell value in B1, B2 and B3 ?

1. =B1+B2+B3
2. =SUM(B1:B3)
3. Select B1, B2 and B3 together and then Auto sum
4. All of the above

Answer

12. Which of the following keyboard command will let you go to the last column of the worksheet?

1. Alt + left arrow key
2. Alt + right arrow key
3. Control + left arrow key
4. Control + right arrow key

Answer

1. Alt + up arrow key
2. Alt + down arrow key
3. Control + up arrow key
4. Control + down arrow key

Answer

1. F3
2. F5
3. F7
4. F11

Answer

1. Logical
2. Text
3. Financial
4. Data series

Answer

16. Which of the following short cut command is used to go to the formula tab?

1. Control + C
2. Control + M
3. Alt +   F
4. Alt + M

Answer

1. 255
2. 1024
3. 2048
4. 32767

Answer

18. Which of the following option is used with control key to open a new worksheet?

1. M
2. O
3. P
4. N

Answer

19. The file extension name for MS Excel 2010 workbook is _______.

1. .excel
2. .xls
3. .xlsx
4. .xlcs

Answer

20. Which of the following option will denote the cell range from C5 to C10?

1. (C5-C10)
2. (C5:C10)
3. (C10-C5)
4. (C10:C5)

Answer