MS Excel Objective Questions with Explanation
MS Excel MCQ Questions and Answers with Explanation
1. Short command to open excel sheet from command prompt is
a) excel.start
b) winexcel
c) excel.exe
d) excel.open
2. ____ appear at the bottom of the Excel window.
a) Naming Box
b) Title Bar
c) Work sheet tabs
d) Formula bar
3. What are the basic rectangular building blocks of a spreadsheet?
a) Cells
b) Zoom slider
c) Help button
d) All of these
4. Which of the following is not a term pertaining to spreadsheets?
a) Cell
b) Character
c) Browser
d) Formula
5. Which of the following format can be applied in AutoFormat dialog box?
a) Number Format
b) Border Format
c) Font Format
d) All of the above
6. What is the use of Shift+F3 shortcut key in MS-Excel 2010?
a) To insert an image
b) To open a new sheet
c) To save the existing sheet
d) To insert a function
7. Which key is used to open Data Tab in Excel sheet?
a) Alt + A
b) Alt + X
c) Shift + F3
d) Shift + F5
8. Which key is used to create a new workbook in Excel?
a) Ctrl + O
b) Ctrl + N
c) Ctrl + S
d) Ctrl + W
9. Which key is used to close Excel?
a) Ctrl + F2
b) Ctrl + F3
c) Ctrl + F4
d) Ctrl + F5
10. Which method is applied to remove the applied border on the cells?
a) Select none on border tab of format cells.
b) Open the list on border tool in format cell toolbar then choose first tool
c) Both of the above
d) None of the above
Correct Answers of MS Excel Objective Questions
1. Correct Answer: c) excel.exe
Explanation: excel.exe is used on command prompt to open excel sheet.
2. Correct Answer: c) Worksheet tabs
Explanation: Worksheet tabs appear at the bottom of the Excel window.
3. Correct Answer: a) cells
Explanation: cells are the basic rectangular building blocks of a spreadsheet.
4. Correct Answer: c) Browser
5. Correct Answer: d) All of the above
Explanation: AutoFormat option in excel is a unique way of formatting data quickly, the first step is we need to select the entire data we need to format and then the second step we need to click on auto-format from the QAT and third step we need to choose the format from the different options.
6. Correct Answer: d) to insert a function
Explanation: Shift+F3 opens the Excel Formula Window and Shift+F5 brings up the search box.
7. Correct Answer: a) Alt + A
Explanation: Alt + A is used to open data tab.
8. Correct Answer: b) Ctrl + N
Explanation:
To save a workbook/spreadsheet Ctrl + S
To open an existing workbook Ctrl + O
To close the current workbook. Ctrl + W
9. Correct Answer: c) Ctrl + F4
Explanation:
To save a workbook/spreadsheet Ctrl + S
To open an existing workbook Ctrl + O
To close the current workbook. Ctrl + W
10. Correct Answer: c) both of the above
Explanation: On the Home tab, in the Font group, click the arrow next to Borders Button, and then click No Border Button.
--OR--
Click Home > the Borders arrow > Erase Border, and then select the cells with the border you want to erase.
We hope that you must have found this exercise quite useful. If you wish to improve your English in spoken, written, reading level, feel free to contact us at +91-9936804420 or email us at aditya.inspiron@gmail.com.
Happy Learning
Team Inspiron Technologies
Leave a comment