MCQs on Excel Basics and Navigation | Excel MCQ Questions
Microsoft Excel is a powerful tool for data analysis, organization, and visualization. Understanding the basics of Excel, including the interface, workbook management, and cell organization, is crucial for users to navigate the software efficiently. In this chapter, we explore topics such as creating and saving workbooks, managing sheets, and understanding Excel file formats. These 30 multiple-choice questions will help you test your knowledge on the essential elements of Excel’s interface and navigation.
MCQs on Introduction to Excel Interface
- Which of the following is part of the Excel interface?
a) Ribbon
b) Taskbar
c) Menu bar
d) Dashboard - What does the ‘Formula Bar’ in Excel display?
a) The entire worksheet
b) The contents of the active cell
c) Only numbers in the active cell
d) Excel settings - Where can you find the ‘Home’ tab in Excel?
a) Top left of the screen
b) Bottom left of the screen
c) On the Ribbon at the top of the screen
d) On the toolbar at the bottom - Which part of the Excel interface allows you to enter data into the cells?
a) Status bar
b) Formula bar
c) Menu bar
d) Quick Access Toolbar - What is the purpose of the ‘Status Bar’ in Excel?
a) To show the document title
b) To show the current worksheet tab
c) To display information such as sum, average, or count
d) To display error messages
MCQs on Creating and Saving Workbooks
- Which option would you choose to create a new Excel workbook?
a) File > New
b) Home > New
c) View > New
d) Insert > New - What happens when you click ‘Save’ in Excel?
a) It saves the workbook as a new file
b) It saves the changes to the current workbook
c) It closes the workbook without saving
d) It saves the workbook as a PDF - Which of the following is a valid way to save a workbook in Excel?
a) File > Save As > PDF
b) File > Save As > Image
c) File > Save As > Video
d) File > Save As > Text - What file extension is used for Excel 2016 workbooks?
a) .xlsx
b) .xlsm
c) .csv
d) .txt - Which shortcut key saves the current workbook in Excel?
a) Ctrl + S
b) Ctrl + N
c) Ctrl + P
d) Ctrl + W
MCQs on Working with Sheets
- Which option is used to add a new sheet in an Excel workbook?
a) Right-click on a tab and select ‘Insert’
b) File > Add Sheet
c) Home > New Sheet
d) Insert > Add Sheet - How can you delete a sheet in Excel?
a) Right-click on the sheet tab and select ‘Delete’
b) Select the sheet and press the ‘Delete’ key
c) File > Delete Sheet
d) Click ‘Clear All’ in the Ribbon - How do you rename a sheet in Excel?
a) Double-click on the sheet tab
b) Right-click on the sheet tab and select ‘Rename’
c) Select the sheet and click on ‘Rename’ in the Ribbon
d) Both a and b - Which option allows you to move a sheet within the workbook?
a) Right-click on the sheet tab and select ‘Move or Copy’
b) Drag the sheet tab to the desired position
c) Click ‘Move’ in the Ribbon
d) Both a and b - What is the maximum number of sheets allowed in a single Excel workbook?
a) 256
b) 512
c) 1024
d) There is no fixed limit
MCQs on Understanding Rows, Columns, and Cells
- What is the intersection of a row and a column called in Excel?
a) Table
b) Cell
c) Range
d) Chart - In Excel, what letter represents the first column?
a) A
b) 1
c) Z
d) AA - What is the maximum number of rows in a worksheet in Excel?
a) 1,000
b) 10,000
c) 1,048,576
d) 10 million - How do you reference a specific cell in Excel?
a) By typing the row and column number
b) By typing the column letter and row number
c) By typing the cell content
d) By using the name box - Which of the following is used to select an entire column in Excel?
a) Click the column letter at the top
b) Press Ctrl + Space
c) Both a and b
d) Double-click the column header
MCQs on Excel File Formats
- Which of the following file formats is used for Excel workbooks?
a) .csv
b) .xlsx
c) .xml
d) All of the above - What is the main difference between .xlsx and .xls file formats?
a) .xlsx is used for Excel 2007 and newer versions
b) .xls is for Excel 2007 and newer versions
c) .xlsx supports macros, .xls does not
d) There is no difference - Which Excel file format is used for exporting data to be opened in a text editor?
a) .xls
b) .xlsx
c) .csv
d) .pdf - What does the .xlsm format support that .xlsx does not?
a) Macros
b) Large datasets
c) Data validation
d) Pivot tables - Which file format would you use to save an Excel workbook as a PDF?
a) .xlsx
b) .pdf
c) .xlsm
d) .csv
MCQs on Navigation and Shortcuts
- What is the shortcut for opening an existing workbook in Excel?
a) Ctrl + N
b) Ctrl + O
c) Ctrl + P
d) Ctrl + S - Which key combination allows you to move to the last cell in a worksheet?
a) Ctrl + Down Arrow
b) Ctrl + Right Arrow
c) Ctrl + End
d) Ctrl + Home - How can you quickly select an entire row in Excel?
a) Click the row number on the left
b) Press Shift + Space
c) Both a and b
d) Right-click the row and select ‘Select All’ - What is the shortcut for inserting a new row in Excel?
a) Ctrl + R
b) Ctrl + Shift + “+”
c) Ctrl + Insert
d) Alt + N - Which key combination allows you to open the “Find and Replace” dialog in Excel?
a) Ctrl + F
b) Ctrl + H
c) Ctrl + Shift + F
d) Both a and b
Answer Key
| Qno | Answer |
|---|---|
| 1 | a) Ribbon |
| 2 | b) The contents of the active cell |
| 3 | c) On the Ribbon at the top of the screen |
| 4 | b) Formula bar |
| 5 | c) To display information such as sum, average, or count |
| 6 | a) File > New |
| 7 | b) It saves the changes to the current workbook |
| 8 | a) File > Save As > PDF |
| 9 | a) .xlsx |
| 10 | a) Ctrl + S |
| 11 | a) Right-click on a tab and select ‘Insert’ |
| 12 | a) Right-click on the sheet tab and select ‘Delete’ |
| 13 | d) Both a and b |
| 14 | d) Both a and b |
| 15 | d) There is no fixed limit |
| 16 | b) Cell |
| 17 | a) A |
| 18 | c) 1,048,576 |
| 19 | b) By typing the column letter and row number |
| 20 | c) Both a and b |
| 21 | d) All of the above |
| 22 | a) .xlsx is used for Excel 2007 and newer versions |
| 23 | c) .csv |
| 24 | a) Macros |
| 25 | b) .pdf |
| 26 | b) Ctrl + O |
| 27 | c) Ctrl + End |
| 28 | c) Both a and b |
| 29 | b) Ctrl + Shift + “+” |
| 30 | d) Both a and b |