CSS - PMS - CCE - PCS - Basic Computing
MS Excel
What is the result of =MIN(7,2,9,4)?
A. 7
B. 2
C. 4
D. 9
Correct Answer: B
MIN returns the smallest value.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
What is the result of =AVERAGE(4,8,12)?
A. 10
B. 6
C. 24
D. 8
Correct Answer: D
The arithmetic mean is (4+8+12)/3 = 8.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
What is the result of =SUM(4,6,10)?
A. 14
B. 16
C. 20
D. 24
Correct Answer: C
SUM adds all supplied numbers.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: occurs when a formula directly or indirectly refers back to its own cell?
A. Circular reference
B. AVERAGEIF
C. REPLACE
D. NOT
Correct Answer: A
Circular reference: occurs when a formula directly or indirectly refers back to its own cell.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: indicates a dynamic-array formula cannot place all its results into the required spill range?
A. IF
B. Comment
C. Split
D. #SPILL!
Correct Answer: D
#SPILL!: indicates a dynamic-array formula cannot place all its results into the required spill range.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: indicates an invalid cell reference, often because referenced cells were deleted?
A. AND
B. #REF!
C. Fill handle
D. MONTH
Correct Answer: B
#REF!: indicates an invalid cell reference, often because referenced cells were deleted.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: indicates Excel does not recognize text in a formula, often a misspelled function or name?
A. Conditional Formatting
B. #NAME?
C. Page Break
D. MONTH
Correct Answer: B
#NAME?: indicates Excel does not recognize text in a formula, often a misspelled function or name.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: indicates a requested value is not available, commonly from an unsuccessful lookup?
A. Slicer
B. Page Break
C. #N/A
D. Comment
Correct Answer: C
#N/A: indicates a requested value is not available, commonly from an unsuccessful lookup.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: indicates a formula attempted to divide by zero or an empty denominator?
A. #DIV/0!
B. Sort
C. #SPILL!
D. OR
Correct Answer: A
#DIV/0!: indicates a formula attempted to divide by zero or an empty denominator.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: calculates summary functions and can ignore filtered-out rows depending on function number?
A. Cell address
B. SUBTOTAL
C. Freeze Panes
D. IFS
Correct Answer: B
SUBTOTAL: calculates summary functions and can ignore filtered-out rows depending on function number.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: switches rows and columns in an array or range result?
A. CONCAT
B. EOMONTH
C. #SPILL!
D. TRANSPOSE
Correct Answer: D
TRANSPOSE: switches rows and columns in an array or range result.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns rows or values that meet specified criteria in supported modern Excel versions?
A. FILTER
B. COUNT
C. AVERAGE
D. Cell address
Correct Answer: A
FILTER: returns rows or values that meet specified criteria in supported modern Excel versions.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns a sorted version of a range or array in supported modern Excel versions?
A. MONTH
B. SORT
C. AutoFill
D. LEFT
Correct Answer: B
SORT: returns a sorted version of a range or array in supported modern Excel versions.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns distinct values from a range or array in supported modern Excel versions?
A. OR
B. UNIQUE
C. Advanced Filter
D. TRIM
Correct Answer: B
UNIQUE: returns distinct values from a range or array in supported modern Excel versions.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns a date a specified number of working days before or after a start date?
A. Excel Table
B. Sparkline
C. #VALUE!
D. WORKDAY
Correct Answer: D
WORKDAY: returns a date a specified number of working days before or after a start date.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: counts working days between two dates, excluding weekends and optionally holidays?
A. WORKDAY
B. Scenario Manager
C. Custom number format
D. NETWORKDAYS
Correct Answer: D
NETWORKDAYS: counts working days between two dates, excluding weekends and optionally holidays.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns the last day of a month a specified number of months before or after a date?
A. UNIQUE
B. #REF!
C. EOMONTH
D. #N/A
Correct Answer: C
EOMONTH: returns the last day of a month a specified number of months before or after a date.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns a number representing the day of week for a date?
A. WEEKDAY
B. Protect Sheet
C. SORT
D. TRANSPOSE
Correct Answer: A
WEEKDAY: returns a number representing the day of week for a date.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: extracts the day of month from a date?
A. RIGHT
B. SUBTOTAL
C. DAY
D. NETWORKDAYS
Correct Answer: C
DAY: extracts the day of month from a date.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: extracts the month number from a date?
A. Format Cells
B. MONTH
C. INT
D. YEAR
Correct Answer: B
MONTH: extracts the month number from a date.