Microsoft Excel MCQs (Set-1)

What does an Excel workbook contain?

A Only a single cell
B A slideshow of charts
C A database server
D One or more worksheets

What is a worksheet made of?

A Slides and notes
B Pages and chapters
C Rows and columns
D Files and folders

How is an individual Excel cell identified?

A Sheet name and font
B Column letter and row number
C Workbook title and date
D Chart type and axis

What does the range A1:C4 describe?

A A rectangular group of cells
B One worksheet tab
C A chart title
D A file format

Which character usually begins an Excel formula?

A Comma
B Colon
C Percent sign
D Equal sign

Where can users inspect or edit a selected cell's formula?

A Status bar
B Title bar
C Formula bar
D Sheet tab

What does SUM calculate?

A Finds the middle value
B Adds numeric values
C Counts text entries only
D Sorts cells alphabetically

Which function calculates the arithmetic mean?

A AVERAGE
B COUNT
C MAX
D ROUND

How does COUNT differ from COUNTA?

A COUNT counts all nonblank cells
B COUNTA counts only dates
C COUNTA counts formulas only
D COUNT counts numbers

What does the MAX function return?

A Smallest numeric value
B Total numeric value
C Largest numeric value
D Number of text cells

Which function can test a condition and return different results?

A SUM
B IF
C MIN
D CONCAT

What does COUNTIF do?

A Counts cells matching a condition
B Adds all visible cells
C Finds the largest text
D Changes cell formatting

What can SUMIF calculate?

A Count every blank cell
B Sort a table by color
C Find a chart title
D Sum values meeting a condition

What does a relative cell reference do when copied?

A Never changes location
B Locks only the row
C Adjusts based on new position
D Locks only the column

How does an absolute reference such as $A$1 behave when copied?

A Moves to the next cell
B Keeps row and column fixed
C Locks only the worksheet name
D Changes into plain text

What does a mixed reference such as A$1 lock?

A The row only
B The column only
C Both row and column
D Neither row nor column

What does AutoFill help users do?

A Add comments automatically
B Protect a workbook
C Create a PivotTable
D Extend patterns or formulas

What can Flash Fill recognize?

A A missing printer
B The workbook password
C A pattern in entered text
D A chart's color palette

How can users select cells in multiple worksheets?

A Use the formula bar
B Use the sheet tabs
C Use the chart legend
D Use the status bar

What can a table add to a data range?

A Structured headers and filters
B A new worksheet automatically
C A password to every cell
D A printed page number

Why format a data range as a table?

A Encrypt the workbook automatically
B Replace every formula
C Create a separate file
D Manage and filter data

What does Filter do to worksheet rows?

A Deletes every unmatched row
B Changes all cell values
C Shows rows meeting selected criteria
D Moves data to another file

What is a multi-level sort useful for?

A Changing chart colors
B Ordering by several columns
C Adding page numbers
D Protecting a workbook

Why confirm the header-row setting before sorting?

A Keep headers out of sort
B It increases the row height
C It formats dates
D It hides blank columns

What does Freeze Panes help keep visible?

A All chart titles
B Every hidden worksheet
C The formula bar text
D Selected rows or columns

What does Conditional Formatting do?

A Calculates every formula
B Adds a new worksheet
C Formats cells based on rules
D Exports data to PDF

How can Data Validation help control input?

A Hide all formulas
B Restrict allowed cell entries
C Sort rows by color
D Create chart labels

What can Remove Duplicates do?

A Remove duplicate records
B Find all spelling errors
C Recover an older workbook
D Freeze the top row

Why should users check selected columns before removing duplicates?

A It changes the workbook format
B It creates an automatic backup
C It makes formulas absolute
D It sets duplicate criteria

What does a PivotTable help summarize?

A Only cell colors
B A single chart image
C Large structured datasets
D A workbook password

Which area in a PivotTable commonly displays calculated totals?

A Title bar
B Values area
C Formula bar
D Name box

Why refresh a PivotTable after source data changes?

A Include new or updated records
B Change worksheet colors
C Unlock all formulas
D Convert dates to text

What does a PivotChart visualize?

A Only workbook comments
B A printed page margin
C Formula errors only
D PivotTable summary data

Which chart type is useful for comparing categories?

A Pie chart only
B Scatter chart only
C Column chart
D Stock chart

What should chart axes communicate clearly?

A Workbook file size
B Units and data scale
C Cell permissions
D The worksheet password

What does a named range provide?

A A name for cell references
B An automatic chart update
C A worksheet password
D A print setting

What does the #DIV/0! error commonly mean?

A A cell contains text
B A sheet name is missing
C The workbook is read-only
D A formula divides by zero

What can #REF! indicate?

A A duplicate worksheet
B A missing chart title
C An invalid cell reference
D An oversized column

Why might a cell display #### instead of a value?

A The worksheet is protected
B Column is too narrow
C The workbook is encrypted
D The formula uses SUM

How can users copy a formula without changing one reference?

A Use an absolute reference
B Change the font color
C Hide the row
D Sort the worksheet

What does the Name Box commonly show?

A The workbook password
B The current chart type
C The selected font color
D The active cell address

How does cell formatting affect the underlying value?

A It changes stored values
B It deletes the formula
C It changes display only
D It exports the sheet

Why can a date appear as a number in Excel?

A The cell is always corrupted
B Dates use serial values internally
C The worksheet has no formulas
D The workbook is read-only

What can a CSV file preserve from an Excel workbook?

A Plain tabular data
B Multiple worksheets and charts
C Every formula style
D All cell comments

What does Protect Sheet primarily restrict?

A All file sharing
B Every cloud backup
C The computer's keyboard
D Certain worksheet changes

What does workbook structure protection help control?

A Changing internet settings
B Sorting cell values
C Adding, deleting, or moving sheets
D Updating charts automatically

What can Print Area specify?

A The chart's data source
B The cells to print
C A table's filter rule
D The workbook's password

Why repeat header rows when printing long tables?

A Repeat column labels
B Sort rows automatically
C Freeze cells in the workbook
D Create a new worksheet

What does Undo do?

A Refreshes a PivotTable
B Protects a worksheet
C Calculates a formula
D Reverses a recent action

How can a formula refer to a cell on another worksheet?

A Use only the chart title
B Turn on Filter
C Include the sheet reference
D Change the page layout