MS Excel Important MCQ Exam Questions with Answers

1.     MS Excel stands for _________________________
a. Microsoft Excel
b. Macrosoftware Excel
c. Microsoft Excess
d. Management Excel

2.     A collection of Worksheets is called?
a. Workbook
b. Spreadsheet
c. Worksheet
d. None of these

3.     What we have to type in the run dialog box to open Microsoft Excel?
a. Excel
b. MS Excel
c. Microsoft Excel
d. None of these

4.     How many sheets are there in Excel Workbook by default?
a. 5
b. 6
c. 2
d. 1

5.     In Excel, rows are labelled as _________?
a. 1, 2, 3 …………………………..
b. I, II, III …………………………...
c. A, B, C ………………………….
d. A1, B1, C1 ……………………..

6.     In Excel, columns are labelled as __________?
a. 1, 2, 3 ………………………….
b. I, II, III …………………………..
c. A, B, C ………………………...
d. A1, B1, C1 ……………………

7.     In Excel, cells are labelled as ______________?
a. 1, 2, 3 ………………………….
b. I, II, III …………………………..
c. A, B, C ………………………...
d. A1, B1, C1 ……………………

8.     In Excel, to create a new Workbook Shortcut is _____________?
a. Fn + N
b. Alt + N
c. Ctrl + N
d. Tab + N

9.     To create a chart in Excel, Press ____________?
a. F1
b. F10
c. F11
d. F12

10. In Excel, which shortcut key is used to open the Save as Dialog Box?
a. F2
b. F12
c. Ctrl+S
d. Ctrl+N

11. In Excel, Ctrl+S can be used to?
a. Save
b. Save As
c. Start New Workbook
d. Switch between opened Tab

12. In Excel, Workbook can be closed using ______________________?
a. Esc
b. Ctrl+C
c. Ctrl+E
d. Ctrl+W

13. While selecting multiple worksheets in Excel, the following key must also be used, when clicking the sheet tab?
a. Alt
b. Tab
c. Ctrl
d. Shift

14. What is the shortcut key to highlight entire column?
a. Ctrl + C
b. Ctrl + Enter
c. Ctrl + Page Up
d. Ctrl + Spacebar

15. What is the shortcut key to highlight the entire row?
a. Shift + C
b. Shift + Enter
c. Shift + Spacebar
d. Shift + Page Up

16. To select all rows and columns in the worksheet, press ___________?
a. Ctrl + A
b. Ctrl + E
c. Ctrl + T
d. Ctrl + S

17. What is the purpose of using AutoSum?
a. Display the sum of the selected cells directly after the selected cells
b. Display the sum of the selected cells directly before the selected cells
c. Automatically show the grand Total
d. All of the above

18. By Default the cell content alignment is?
a. Text right alignment and numbers left alignment
b. Text left alignment and numbers right alignment
c. Centrally Aligned
d. Left Aligned

19. Which of the following methods can not be used to edit the contents of a cell?
a. Press the Alt key
b. Pressing the F2 Key
c. Double clicking the cell
d. Clicking the formula bar

20. Which of the following is a MS Excel File Formats?
a. .xlsx
b. .xlsn
c. Both a & b
d. None of these

21. In Excel, Which one denoted a range from B1 through E9?
a. B1:E9
b. B1 –  E9
c. B1 to E9
d. B1 $ E9

22. Which of the following component displays the contents of active cell?
a. Menu Bar
b. Name Box
c. Formula Bar
d. Status Bar

23. Which function adds all the values of the cells in the argument?
a. ADD()
b. SUM()
c. Both a & b
d. None of these

24. Which shortcut key opens the Go to Dialog Box?
a. F2
b. F5
c. Ctrl + B
d. Ctrl + Shift + B

25. Which tab has wrap text feature in MS Excel 2019?
a. View
b. Insert
c. Home
d. Formulas

26. Which term is used to join the selected cells in to one cell?
a. Add
b. Merge
c. Combined
d. All of the above

27. Which of the following is not a valid function in MS Excel?
a. SUM()
b. Count()
c. Subtract()
d. Counta()