MS EXCEL MCQS
ABOUT MS EXCEL MCQS
Microsoft Excel was developed by Microsoft in 1985. It is one of the most widely used spreadsheet applications. It is created for data manipulation and analysis. Excel offers powerful functions for calculating, organizing, and visualizing data by using many formulas, charts, and pivot tables.It has evolved from a basic spreadsheet tool into a complex data analysis platform. Microsoft owned ms word, ms excel and ms powerpoint
TOP MS EXCEL MCQS
- The default file extension for an Excel workbook ?
a) .xlsx
b) .xls
c) PPT
d) .docx - The option is used to save an Excel workbook with a different name?
a) Save As
b) Save As
c) Export
d) Save Template - The maximum number of worksheets that can be added to an Excel workbook?
a) 25
b) Limited only by memory
c) 1200
d) 513 - What is the default number of worksheets in a new Excel workbook?
a) 3
b) 1
c) 4
d) 2 - To change the paper size in Excel for printing?
a) Page Setup
b) Orientation
c) Print Preview
d) none of these - The maximum number of rows in an Excel worksheet?
a) 65535
b) 1048576
c) 104856
d) 10485750 - Total number of columns in an Excel worksheet?
a) 2024
b) 16384
c) 163830
d) 266 - To keep certain rows or columns visible while scrolling through an Excel worksheet?
a) Split Panes
b) Hide
c) Freeze Panes Hide
d) Both a and b - What is the default view in Excel?
a) Custom View
b) Normal View
c) Page Break Preview
d) Page Layout View - Which Excel view shows a preview of how your sheet will look when printed?
a) Normal View
b) Page Break Preview
c) Page Layout View
d) None of these - Which option is used to display the page breaks in an Excel worksheet?
a) Normal View
b) Page Break view
c) Page Break Preview
d) Print Preview - The view in Excel allows you to manage headers, footers, and margins?
a) Normal View
b) Page Break Preview
c) Page Layout View
d) Full Screen View - What is the use of the “Zoom” feature in Excel?
a) To enlarge the font size
b) To change the worksheet layout
c) To increase or decrease the view size of the worksheet
d) To fit content on the page - Which feature is used to zoom in or out of a worksheet in Excel?
a) Magnifier
b) Zoom Slider
c) Layout
d) View Mode - What is the default zoom percentage in Excel?
a) 120%
b) 75%
c) 80%
d) 100% - Which option allows you to display gridlines on an Excel worksheet?
a) Print Layout
b) View Tab
c) Page Setup
d) Format Tab - What is the maximum zoom percentage available in Excel?
a) 150%
b) 200%
c) 250%
d) 400% - Which option in Excel allows you to insert a new worksheet?
a) Format
b) View
c) Insert
d) Data - Which setting is used to fit content on a single page when printing in Excel?
a) Page Layout
b) Margins
c) Fit to Page
d) Header and Footer - Which function is used to hide a sheet in Excel?
a) Delete Sheet
b) Hide Sheet
c) Protect Sheet
d) Group Sheet
MS EXCEL MCQS MS EXCEL MCQS MS EXCEL MCQS MS EXCEL MCQS MS EXCEL MCQS
- How can you display hidden sheets in Excel?
a) Group Sheet
b) Unfreeze Panes
c) Unhide Sheet
d) Show Gridlines - What is the primary use of the “Split” feature in Excel?
a) To create new sheets
b) To split the window into multiple resizable panes
c) To merge cells
d) To insert tables - Which feature allows you to filter data in a selected range?
a) Sort
b) Filter
c) Data Validation
d) Conditional Formatting - What is the use of the “Group” feature in Excel?
a) Create a chart
b) Group rows or columns to expand/collapse
c) Merge cells
d) Create formulas - Which Excel feature is used to merge adjacent cells into a single cell?
a) Concatenate
b) Merge & Center
c) Wrap Text
d) Combine Cells - How many sheets are visible in an Excel workbook by default?
a) 1
b) 2
c) 3
d) 4 - What happens when you change the column width in Excel?
a) It adjusts the row height
b) It changes the width of the selected column(s)
c) It zooms the worksheet
d) It locks the column - Which option is used to rename a worksheet in Excel?
a) Insert
b) View
c) Right-click the sheet tab and select “Rename”
d) Data - Which tab contains the “Zoom” settings in Excel?
a) Home
b) Insert
c) View
d) Layout - What does the “Fit to One Page” option do when printing an Excel worksheet?
a) Expands the data across multiple pages
b) Shrinks the worksheet to fit on one page
c) Increases the font size
d) Changes the layout to landscape - How do you add a comment to a cell in Excel?
a) View → Add Comment
b) Insert → Note
c) Right-click the cell → New Comment
d) Data → Comment - Which option is used to adjust the print area in Excel?
a) Page Layout → Breaks
b) Page Layout → Print Area
c) View → Print Preview
d) Data → Page Setup - What is a cell range in Excel?
a) A single cell
b) A group of contiguous cells
c) A formula
d) A chart - Which feature allows you to restrict data entry within a specific range of cells?
a) Sort
b) Data Validation
c) Conditional Formatting
d) Filter - What happens when you merge cells in Excel?
a) The data in all cells is combined
b) The selected cells are combined into a single cell
c) The columns are hidden
d) A new sheet is created - Which feature is used to change the appearance of gridlines on a worksheet?
a) Insert
b) View → Gridlines
c) Data → Gridlines
d) Format → Gridlines - How can you add multiple sheets to an Excel workbook?
a) File → Insert Sheets
b) Right-click a sheet tab → Insert
c) Data → Insert Sheet
d) View → New Sheet - Which feature allows you to fit the contents of a worksheet on one page without adjusting margins?
a) Page Break Preview
b) Custom View
c) Scale to Fit
d) Zoom to Selection - How do you remove gridlines from a worksheet when printing?
a) View → Remove Gridlines
b) Page Layout → Uncheck “Print Gridlines”
c) Format → Gridlines
d) Insert → Remove Gridlines - What is the use of the “Conditional Formatting” feature in Excel?
a) To create charts
b) To format cells based on specific conditions
c) To insert comments
d) To protect cells
MS EXCEL MCQS MS EXCEL MCQS MS EXCEL MCQ SMS EXCEL MCQS MS EXCEL MCQS MS EXCEL MCQS MS EXCEL MCQS