CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: temporarily hides rows that do not meet specified criteria?
A. NOT
B. HLOOKUP
C. Filter
D. Excel Table
Correct Answer: C
Filter: temporarily hides rows that do not meet specified criteria.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: reorders rows according to selected values or criteria?
A. MOD
B. Sort
C. Data Table
D. ABS
Correct Answer: B
Sort: reorders rows according to selected values or criteria.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: a structured data range with headers, filtering, styles, and automatic expansion?
A. Absolute reference
B. Filter
C. Excel Table
D. COUNTIF
Correct Answer: C
Excel Table: a structured data range with headers, filtering, styles, and automatic expansion.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: a table-based reference that uses table and column names in formulas?
A. HLOOKUP
B. #DIV/0!
C. PivotTable
D. Structured reference
Correct Answer: D
Structured reference: a table-based reference that uses table and column names in formulas.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: a user-defined name that refers to a cell, range, constant, or formula?
A. UNIQUE
B. Named range
C. CONCAT
D. MONTH
Correct Answer: B
Named range: a user-defined name that refers to a cell, range, constant, or formula.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: a reference that locks either the row or the column but not both, such as $A1 or A$1?
A. Mixed reference
B. Relative reference
C. Number format
D. #REF!
Correct Answer: A
Mixed reference: a reference that locks either the row or the column but not both, such as $A1 or A$1.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: a cell reference with locked row and column, such as $A$1?
A. Split
B. Workbook
C. COUNTIFS
D. Absolute reference
Correct Answer: D
Absolute reference: a cell reference with locked row and column, such as $A$1.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: a cell reference that adjusts when a formula is copied, such as A1?
A. Sheet tab
B. Worksheet
C. Relative reference
D. NOT
Correct Answer: C
Relative reference: a cell reference that adjusts when a formula is copied, such as A1.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: detects a text/data pattern and fills values based on examples?
A. Flash Fill
B. Excel Table
C. Solver
D. Range
Correct Answer: A
Flash Fill: detects a text/data pattern and fills values based on examples.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: automatically extends data patterns, series, or formulas into adjacent cells?
A. TEXT
B. Split
C. AutoFill
D. XLOOKUP
Correct Answer: C
AutoFill: automatically extends data patterns, series, or formulas into adjacent cells.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: the small handle on a selected cell/range used to copy formulas or continue series?
A. Fill handle
B. Print Area
C. Number format
D. DATE
Correct Answer: A
Fill handle: the small handle on a selected cell/range used to copy formulas or continue series.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: the tab used to select, rename, move, copy, or manage worksheets?
A. RIGHT
B. Sheet tab
C. Split
D. PivotChart
Correct Answer: B
Sheet tab: the tab used to select, rename, move, copy, or manage worksheets.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: the box that displays the active cell reference and can navigate to named ranges or addresses?
A. Goal Seek
B. ROUND
C. AVERAGEIF
D. Name Box
Correct Answer: D
Name Box: the box that displays the active cell reference and can navigate to named ranges or addresses.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: the area used to view or edit a cell's value or formula?
A. Drop-down list
B. Goal Seek
C. Formula bar
D. Named range
Correct Answer: C
Formula bar: the area used to view or edit a cell's value or formula.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: the currently selected cell where data can be entered?
A. Text to Columns
B. Active cell
C. Fill handle
D. ROUND
Correct Answer: B
Active cell: the currently selected cell where data can be entered.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: a group or block of one or more cells?
A. Named range
B. Mixed reference
C. Sort
D. Range
Correct Answer: D
Range: a group or block of one or more cells.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: the combination of column letter and row number that identifies a cell, such as B7?
A. VLOOKUP
B. Split
C. Mixed reference
D. Cell address
Correct Answer: D
Cell address: the combination of column letter and row number that identifies a cell, such as B7.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: a spreadsheet page made of rows and columns within a workbook?
A. #NAME?
B. INT
C. Worksheet
D. Timeline
Correct Answer: C
Worksheet: a spreadsheet page made of rows and columns within a workbook.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Sorting in Excel is used to:
A. Arrange data
B. Delete formulas
C. Hide workbook
D. Close Excel
Correct Answer: A
Correct Answer: A. Arrange data
Fact Check: Sorting arranges data in order, such as A to Z, Z to A, smallest to largest, or largest to smallest.
A. Correct — Arrange data is right because Sorting arranges data in order, such as A to Z, Z to A, smallest to largest, or largest to smallest.
B. Delete formulas is not correct because it does not match the verified fact: Sorting arranges data in order, such as A to Z, Z to A, smallest to largest, or largest to smallest.
C. Hide workbook is not correct because it does not match the verified fact: Sorting arranges data in order, such as A to Z, Z to A, smallest to largest, or largest to smallest.
D. Close Excel is not correct because it does not match the verified fact: Sorting arranges data in order, such as A to Z, Z to A, smallest to largest, or largest to smallest.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
To freeze first row and first column, select:
A. A1
B. B2
C. C3
D. A2
Correct Answer: B
Correct Answer: B. B2
Fact Check: Select B2, then use View → Freeze Panes. Excel freezes rows above and columns to the left.
A. A1 is not correct because it does not match the verified fact: Select B2, then use View → Freeze Panes. Excel freezes rows above and columns to the left.
B. Correct — B2 is right because Select B2, then use View → Freeze Panes. Excel freezes rows above and columns to the left.
C. C3 is not correct because it does not match the verified fact: Select B2, then use View → Freeze Panes. Excel freezes rows above and columns to the left.
D. A2 is not correct because it does not match the verified fact: Select B2, then use View → Freeze Panes. Excel freezes rows above and columns to the left.