Sarkari Naukri

Government Exams Preparation

MS Excel MCQ 2

 5%

Question 1 of 20

1. Which of the cell pointer indicates you that you can make selection?

Question 1 of 20

Question 2 of 20

2. _________function in MS Excel worksheet represents the total number(s) of entries in the cell(s).

Question 2 of 20

Question 3 of 20

3. Which of the following is not the correct method of editing the cell content?

Question 3 of 20

Question 4 of 20

4. The advantage of using a spreadsheet is :

Question 4 of 20

Question 5 of 20

5. Which of the cell pointer indicates that you can fill series?

Question 5 of 20

Question 6 of 20

6. __________is NOT a Function in Microsoft Excel spreadsheets.

Question 6 of 20

Question 7 of 20

7. Which of the cell pointer indicates that you can fill series?

Question 7 of 20

Question 8 of 20

8. When you print preview a worksheet

Question 8 of 20

Question 9 of 20

9. Which of the cell pointer indicate that you can move the content to other cell?

Question 9 of 20

Question 10 of 20

10. In MS Excel spreadsheet, Data can be sorted using ________.

Question 10 of 20

Question 11 of 20

11. The __ feature of ms excel quickly completes a series of data.

Question 11 of 20

Question 12 of 20

12. Long text can be broken down into many lines within a cell. You can do this through

Question 12 of 20

Question 13 of 20

13. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

Question 13 of 20

Question 14 of 20

14. You can auto fit the width of column by

Question 14 of 20

Question 15 of 20

15. You can auto fit the width of column by

Question 15 of 20

Question 16 of 20

16. In MS Excel_________feature makes it easier to add repetitive data to a worksheet

Question 16 of 20

Question 17 of 20

17. Which of the following series type is not valid for Fill Series dialog box?

Question 17 of 20

Question 18 of 20

18. In Excel which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

Question 18 of 20

Question 19 of 20

19. Long text can be broken down into many lines within a cell. You can do this through

Question 19 of 20

Question 20 of 20

20. In MS Excel, Page border option is available under _______ tab.

Question 20 of 20