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
Answer: D. One or more worksheets. A workbook can contain multiple worksheets.
What is a worksheet made of?
A Slides and notes
B Pages and chapters
C Rows and columns
D Files and folders
Answer: C. Rows and columns. A worksheet organizes data in a grid of rows and columns.
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
Answer: B. Column letter and row number. A cell address combines its column letter and row number, such as B3.
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
Answer: A. A rectangular group of cells. A range reference uses endpoints to specify a group of cells.
Which character usually begins an Excel formula?
A Comma
B Colon
C Percent sign
D Equal sign
Answer: D. Equal sign. Excel formulas begin with an 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
Answer: C. Formula bar. The formula bar displays or lets users edit the selected cell's contents.
What does SUM calculate?
A Finds the middle value
B Adds numeric values
C Counts text entries only
D Sorts cells alphabetically
Answer: B. Adds numeric values. SUM adds values in specified cells or ranges.
Which function calculates the arithmetic mean?
A AVERAGE
B COUNT
C MAX
D ROUND
Answer: A. AVERAGE. AVERAGE returns the arithmetic mean of numeric values.
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
Answer: D. COUNT counts numbers. COUNT counts numeric entries, while COUNTA counts nonempty cells.
What does the MAX function return?
A Smallest numeric value
B Total numeric value
C Largest numeric value
D Number of text cells
Answer: C. Largest numeric value. MAX returns the largest value from a set of numeric values.
Which function can test a condition and return different results?
A SUM
B IF
C MIN
D CONCAT
Answer: B. IF. IF evaluates a condition and returns one result when true and another when false.
What does COUNTIF do?
A Counts cells matching a condition
B Adds all visible cells
C Finds the largest text
D Changes cell formatting
Answer: A. Counts cells matching a condition. COUNTIF counts cells in a range that meet a specified criterion.
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
Answer: D. Sum values meeting a condition. SUMIF adds values that meet a specified 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
Answer: C. Adjusts based on new position. Relative references shift when formulas are copied to another position.
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
Answer: B. Keeps row and column fixed. Dollar signs fix both the column and row in an absolute reference.
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
Answer: A. The row only. A$1 fixes row 1 while allowing the column to change.
What does AutoFill help users do?
A Add comments automatically
B Protect a workbook
C Create a PivotTable
D Extend patterns or formulas
Answer: D. Extend patterns or formulas. The fill handle can extend values, patterns, or formulas into nearby cells.
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
Answer: C. A pattern in entered text. Flash Fill can infer a text pattern from examples and fill matching entries.
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
Answer: B. Use the sheet tabs. Grouping sheet tabs can apply some actions across selected worksheets.
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
Answer: A. Structured headers and filters. Excel tables provide named columns and convenient filtering or formatting options.
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
Answer: D. Manage and filter data. Tables make it easier to sort, filter, and work with structured 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
Answer: C. Shows rows meeting selected criteria. Filtering hides rows that do not meet selected criteria without deleting them.
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
Answer: B. Ordering by several columns. A multi-level sort applies one ordering and then another within matching values.
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
Answer: A. Keep headers out of sort. Treating headers correctly keeps column labels from being mixed with records.
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
Answer: D. Selected rows or columns. Freeze Panes keeps selected rows or columns visible while scrolling.
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
Answer: C. Formats cells based on rules. Conditional formatting changes appearance based on values or conditions.
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
Answer: B. Restrict allowed cell entries. Data Validation can limit acceptable values or provide a drop-down list.
What can Remove Duplicates do?
A Remove duplicate records
B Find all spelling errors
C Recover an older workbook
D Freeze the top row
Answer: A. Remove duplicate records. Remove Duplicates deletes records that match based on selected columns.
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
Answer: D. It sets duplicate criteria. The chosen columns determine which records Excel treats as duplicates.
What does a PivotTable help summarize?
A Only cell colors
B A single chart image
C Large structured datasets
D A workbook password
Answer: C. Large structured datasets. PivotTables group and summarize data for analysis.
Which area in a PivotTable commonly displays calculated totals?
A Title bar
B Values area
C Formula bar
D Name box
Answer: B. Values area. Numeric fields placed in Values are summarized with functions such as Sum or Count.
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
Answer: A. Include new or updated records. Refreshing updates the PivotTable from its current data source.
What does a PivotChart visualize?
A Only workbook comments
B A printed page margin
C Formula errors only
D PivotTable summary data
Answer: D. PivotTable summary data. PivotCharts present PivotTable summaries as charts.
Which chart type is useful for comparing categories?
A Pie chart only
B Scatter chart only
C Column chart
D Stock chart
Answer: C. Column chart. Column charts compare values across categories.
What should chart axes communicate clearly?
A Workbook file size
B Units and data scale
C Cell permissions
D The worksheet password
Answer: B. Units and data scale. Clear axis labels help readers interpret what the chart values represent.
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
Answer: A. A name for cell references. Named ranges let formulas refer to cells using a descriptive name.
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
Answer: D. A formula divides by zero. #DIV/0! appears when a formula divides by zero or an empty divisor.
What can #REF! indicate?
A A duplicate worksheet
B A missing chart title
C An invalid cell reference
D An oversized column
Answer: C. An invalid cell reference. #REF! indicates that a formula contains a reference Excel cannot resolve.
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
Answer: B. Column is too narrow. Widening the column can reveal values that do not fit in the displayed cell width.
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
Answer: A. Use an absolute reference. Absolute references stay fixed when a formula is copied.
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
Answer: D. The active cell address. The Name Box displays a cell reference and can be used to navigate to a range.
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
Answer: C. It changes display only. Number formats affect how values appear without necessarily changing the stored data.
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
Answer: B. Dates use serial values internally. Excel stores dates as serial values and displays them according to formatting.
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
Answer: A. Plain tabular data. CSV stores delimited text and does not preserve many workbook features or multiple sheets.
What does Protect Sheet primarily restrict?
A All file sharing
B Every cloud backup
C The computer's keyboard
D Certain worksheet changes
Answer: D. Certain worksheet changes. Sheet protection can restrict selected edits, but it is not the same as file encryption.
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
Answer: C. Adding, deleting, or moving sheets. Workbook structure protection can restrict changes to worksheet organization.
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
Answer: B. The cells to print. Print Area defines which worksheet cells are included when printing.
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
Answer: A. Repeat column labels. Repeating title rows makes printed pages easier to read.
What does Undo do?
A Refreshes a PivotTable
B Protects a worksheet
C Calculates a formula
D Reverses a recent action
Answer: D. Reverses a recent action. Undo reverses recent supported actions in the workbook.
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
Answer: C. Include the sheet reference. Cross-sheet references identify the worksheet and cell used in a formula.