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**