CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: shows worksheet content with page boundaries, margins, headers, and footers?
A. Page Layout view
B. MID
C. PROPER
D. WEEKDAY
Correct Answer: A
Page Layout view: shows worksheet content with page boundaries, margins, headers, and footers.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: changes the on-screen magnification of the worksheet?
A. Zoom
B. MAX
C. Name Box
D. TODAY
Correct Answer: A
Zoom: changes the on-screen magnification of the worksheet.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: divides the worksheet window into separate scrollable panes?
A. Split
B. Print Area
C. MONTH
D. VLOOKUP
Correct Answer: A
Split: divides the worksheet window into separate scrollable panes.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: a user-defined display pattern for numbers, dates, or text?
A. Custom number format
B. MAX
C. ROUNDDOWN
D. PivotChart
Correct Answer: A
Custom number format: a user-defined display pattern for numbers, dates, or text.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: controls how a numeric value is displayed without necessarily changing its stored value?
A. Sheet tab
B. Page Layout view
C. Number format
D. SUMIFS
Correct Answer: C
Number format: controls how a numeric value is displayed without necessarily changing its stored value.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: dialog used to control number, alignment, font, border, fill, and protection settings?
A. OR
B. Format Cells
C. Print Area
D. Circular reference
Correct Answer: B
Format Cells: dialog used to control number, alignment, font, border, fill, and protection settings.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: automatically formats cells when specified conditions are met?
A. SUMIF
B. OR
C. AutoFill
D. Conditional Formatting
Correct Answer: D
Conditional Formatting: automatically formats cells when specified conditions are met.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: a data-validation option that limits entries to values from a list?
A. Zoom
B. Drop-down list
C. DATE
D. #DIV/0!
Correct Answer: B
Drop-down list: a data-validation option that limits entries to values from a list.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: restricts or guides what users can enter in selected cells?
A. IFERROR
B. Data Validation
C. Scenario Manager
D. POWER
Correct Answer: B
Data Validation: restricts or guides what users can enter in selected cells.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: splits data in one column into multiple columns using delimiters or fixed widths?
A. LEN
B. Print Area
C. Fill handle
D. Text to Columns
Correct Answer: D
Text to Columns: splits data in one column into multiple columns using delimiters or fixed widths.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: deletes repeated records based on selected columns?
A. Remove Duplicates
B. TEXTJOIN
C. POWER
D. AND
Correct Answer: A
Remove Duplicates: deletes repeated records based on selected columns.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: filters data using more complex criteria and can copy unique results to another location?
A. Advanced Filter
B. AVERAGEIF
C. Data Validation
D. Freeze Panes
Correct Answer: A
Advanced Filter: filters data using more complex criteria and can copy unique results to another location.
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.