CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns the smallest numeric value?
A. Advanced Filter
B. MIN
C. Solver
D. IFERROR
Correct Answer: B
MIN: returns the smallest numeric value.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: adds numeric values?
A. SUM
B. Format Cells
C. Cell
D. Freeze Panes
Correct Answer: A
SUM: adds numeric values.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: an add-in that finds optimal values subject to constraints?
A. SUM
B. COUNTIFS
C. Solver
D. SUMIFS
Correct Answer: C
Solver: an add-in that finds optimal values subject to constraints.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: a What-If Analysis tool that shows formula results for one or two varying inputs?
A. COUNTBLANK
B. Circular reference
C. TRANSPOSE
D. Data Table
Correct Answer: D
Data Table: a What-If Analysis tool that shows formula results for one or two varying inputs.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: stores and compares different sets of input values?
A. LEN
B. Scenario Manager
C. INDEX
D. FIND
Correct Answer: B
Scenario Manager: stores and compares different sets of input values.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: changes one input value to make a formula reach a specified result?
A. Goal Seek
B. Page Layout view
C. Workbook
D. TODAY
Correct Answer: A
Goal Seek: changes one input value to make a formula reach a specified result.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: a tiny chart displayed inside a single cell?
A. WORKDAY
B. Sparkline
C. Flash Fill
D. Header/Footer
Correct Answer: B
Sparkline: a tiny chart displayed inside a single cell.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: provides date-based visual filtering for PivotTables?
A. Timeline
B. Protect Sheet
C. COUNTIF
D. XMATCH
Correct Answer: A
Timeline: provides date-based visual filtering for PivotTables.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: provides button-based visual filtering for tables or PivotTables?
A. IF
B. Formula bar
C. #DIV/0!
D. Slicer
Correct Answer: D
Slicer: provides button-based visual filtering for tables or PivotTables.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: is a chart linked to PivotTable data and filtering?
A. NETWORKDAYS
B. Format Cells
C. Formula bar
D. PivotChart
Correct Answer: D
PivotChart: is a chart linked to PivotTable data and filtering.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: summarizes and analyzes large datasets by dynamically arranging fields?
A. Flash Fill
B. PivotTable
C. IF
D. XLOOKUP
Correct Answer: B
PivotTable: summarizes and analyzes large datasets by dynamically arranging fields.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: allows multiple users to edit a shared workbook concurrently when supported?
A. Co-authoring
B. Remove Duplicates
C. Protect Workbook
D. #VALUE!
Correct Answer: A
Co-authoring: allows multiple users to edit a shared workbook concurrently when supported.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: a traditional cell annotation formerly called a comment in older Excel versions?
A. VLOOKUP
B. #VALUE!
C. Number format
D. Note
Correct Answer: D
Note: a traditional cell annotation formerly called a comment in older Excel versions.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: a threaded discussion attached to a cell in modern Excel collaboration?
A. MAX
B. FIND
C. MIN
D. Comment
Correct Answer: D
Comment: a threaded discussion attached to a cell in modern Excel collaboration.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: can restrict structural changes such as adding, deleting, moving, or renaming sheets?
A. UNIQUE
B. NOW
C. Protect Workbook
D. MAX
Correct Answer: C
Protect Workbook: can restrict structural changes such as adding, deleting, moving, or renaming sheets.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: restricts editing actions on a worksheet according to configured permissions?
A. Cell address
B. ABS
C. HLOOKUP
D. Protect Sheet
Correct Answer: D
Protect Sheet: restricts editing actions on a worksheet according to configured permissions.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: repeating information placed at the top or bottom of printed pages?
A. SUMIFS
B. Header/Footer
C. Protect Sheet
D. AND
Correct Answer: B
Header/Footer: repeating information placed at the top or bottom of printed pages.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: marks where one printed page ends and another begins?
A. Sparkline
B. Page Break
C. #NAME?
D. Mixed reference
Correct Answer: B
Page Break: marks where one printed page ends and another begins.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: repeats selected rows or columns on each printed page?
A. ROUNDDOWN
B. Co-authoring
C. MID
D. Print Titles
Correct Answer: D
Print Titles: repeats selected rows or columns on each printed page.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: defines the cells that Excel should print?
A. MAX
B. Print Area
C. Co-authoring
D. COUNTIFS
Correct Answer: B
Print Area: defines the cells that Excel should print.