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.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: extracts the year number from a date?
A. PROPER
B. DATE
C. COUNT
D. YEAR
Correct Answer: D
YEAR: extracts the year number from a date.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: constructs a date from year, month, and day numbers?
A. DATE
B. Advanced Filter
C. NOT
D. Print Titles
Correct Answer: A
DATE: constructs a date from year, month, and day numbers.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns the current date and time?
A. NOW
B. PROPER
C. Data Table
D. SUM
Correct Answer: A
NOW: returns the current date and time.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns the current date?
A. MONTH
B. TODAY
C. EOMONTH
D. Print Titles
Correct Answer: B
TODAY: returns the current date.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: raises a number to a specified power?
A. Range
B. ABS
C. POWER
D. FIND
Correct Answer: C
POWER: raises a number to a specified power.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns the positive square root of a number?
A. #N/A
B. SQRT
C. SUM
D. VLOOKUP
Correct Answer: B
SQRT: returns the positive square root of a number.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns the absolute value of a number?
A. Active cell
B. LEN
C. ABS
D. Formula bar
Correct Answer: C
ABS: returns the absolute value of a number.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns the remainder after division?
A. MOD
B. Flash Fill
C. Formula bar
D. ROUNDDOWN
Correct Answer: A
MOD: returns the remainder after division.