This Excel MCQ help you to gain an extra and fast knowledge on M.S Excel. Excel is a spreadsheet program that was first released by Microsoft in 1985. It has been a very popular spreadsheet program ever since.
It is used for creating and managing spreadsheets, or tables of data. Spreadsheets are used for many different purposes, but are most often used to make financial calculations, such as calculating loan payments or amortization schedules. Excel can also be used to keep track of the budgets of households and businesses.
Multiple Choice Questions and AnswersÂ
1. Microsoft Excel is a powerful __________ package
- Spreadsheet
- Communication
- Table
- Graph
Answer :-Â Spreadsheet
Â
2. Excel is a part of the ____________ suite of software
- Microsoft office
- Microsoft world
- Microsoft suite
- None of these
Answer :-Â Microsoft office
Â
3. Microsoft Excel is a collection ofÂ
- charts and Graphs
- Table and workbooks
- worksheets and charts
- All of the above
Answer :-Â worksheets and charts
Â
4. Which of the following is the default extension of excel file
- .Xlw
- .Xlsx
- .Xly
- .Xlts
Answer :-Â .Xlsx
Â
5. Which field in the Excel window allows values and formulas to be entered?
- Formula bar
- Title bar
- Menu bar
- Standard toolbox
Answer :-Â Formula bar
Â
6. In excel the formula must beings with which symbol?
- +
- =
- @
- (
Answer :-Â =
Â
7. To save a Microsoft Excel file you need to
- Select edit save
- Click the save option in file menu
- Press Ctrl + F5
- Click save on window start button
Answer :-Â Click the save option in file menu
Â
8. The first cell in a excel worksheet is labeled as
- A1
- A0
- Aa
- AA
Answer :-Â A1
Â
9. In which of the following excel displays the current cells address
- Formula bar
- Name box
- Title bar
- Status bar
Answer :-Â Name box
Â
10. The name box ?
- Appears below the menu bar
- Appears below the status bar
- Appears to the left of the formula bar
- None of these
Answer :-Â Appears to the left of the formula bar
Â
11. What is the shortcut key to hide the entire row in excel
- Ctrl + 2
- Ctrl + 9
- Ctrl + 6
- Ctrl + 3
Answer :-Â Ctrl + 9
Â
12. An Excel can have maximum ______ number of rows
- 10,45,963
- 10,78,896
- 10,48,576
- 10,55,569
Answer :-Â 10,48,576
Â
13. An Excel can have maximum _______ number of columns
- 16,384
- 15,298
- 12,548
- 17,895
Answer :-Â 16,384
Â
14. What will be the shortcut key to replace a date within sheet?
- Ctrl + R
- Ctrl + F
- Ctrl + H
- Ctrl + Shift + R
Answer :-Â Ctrl + H
Â
15. In MS Excel, what will the shortcut key to select an entire column?
- Ctrl + C
- Ctrl + S
- Ctrl + Arrow Key
- None of these
Answer :-Â None of these
Â
16. What do you mean by workspace?
- Groups of rows
- Groups of columns
- Groups of worksheets
- Group of workbooks
Answer :-Â Group of workbooks
Â
17. Which of the following syntax is correct regarding to SUM function in Excel?
- =SUM(A1,B1)
- =SUM(A1:B9)
- =SUM(A1:A9,B1:B9)
- All of the above
Answer :-Â All of the above
Â
18. What is the symbol of dividing in excel
- /
- %
- *
- –
Answer :-Â /
Â
19. Worksheet is also called an array of _________
- Column
- Cells
- Box
- Formula
Answer :-Â Cells
Â
20. what is the symbol of multiplying in excelÂ
- ^
- #
- *
- –
Answer :-Â *
Â
21. How cells are named in Ms excel?
- Numerically
- Alphanumerically
- Special Character
- Alphabetically
Answer :-Â Alphanumerically
Â
22. In excel screen, which bar lies top of the window
- Status bar
- Ruler
- Title bar
- Scroll bar
Answer :-Â Title bar
Â
23. Which tab is used to include pivot table, charts, hyperlink in a excel file?
- Insert
- Page layout
- Data
- Review
Answer :-Â Insert
Â
24. How does the single element in a worksheet known as in excel?
- Cell
- Column
- Range
- Row
Answer :-Â Â Cell