CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: converts text to lowercase?
A. Named range
B. LOWER
C. POWER
D. Goal Seek
Correct Answer: B
LOWER: converts text to lowercase.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: converts text to uppercase?
A. UPPER
B. YEAR
C. OR
D. PivotTable
Correct Answer: A
UPPER: converts text to uppercase.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: removes extra spaces from text while leaving single spaces between words?
A. XMATCH
B. #VALUE!
C. TRIM
D. VLOOKUP
Correct Answer: C
TRIM: removes extra spaces from text while leaving single spaces between words.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns the number of characters in text?
A. MID
B. Text to Columns
C. LEN
D. Print Area
Correct Answer: C
LEN: returns the number of characters in text.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns characters from the middle of text starting at a specified position?
A. Active cell
B. MID
C. INT
D. HLOOKUP
Correct Answer: B
MID: returns characters from the middle of text starting at a specified position.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns a specified number of characters from the end of text?
A. Slicer
B. RIGHT
C. #VALUE!
D. Formula bar
Correct Answer: B
RIGHT: returns a specified number of characters from the end of text.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns a specified number of characters from the beginning of text?
A. Print Titles
B. LEFT
C. Format Cells
D. PROPER
Correct Answer: B
LEFT: returns a specified number of characters from the beginning of text.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns the relative position of an item with newer matching/search options than MATCH?
A. Circular reference
B. Mixed reference
C. XMATCH
D. Active cell
Correct Answer: C
XMATCH: returns the relative position of an item with newer matching/search options than MATCH.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns the relative position of an item in a one-dimensional range or array?
A. LEN
B. MOD
C. MATCH
D. IF
Correct Answer: C
MATCH: returns the relative position of an item in a one-dimensional range or array.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns a value or reference from a specified row and column position in a range or array?
A. TRIM
B. INDEX
C. MONTH
D. #SPILL!
Correct Answer: B
INDEX: returns a value or reference from a specified row and column position in a range or array.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: searches one array/range for a value and returns a corresponding result from another array/range?
A. XLOOKUP
B. SEARCH
C. AND
D. REPLACE
Correct Answer: A
XLOOKUP: searches one array/range for a value and returns a corresponding result from another array/range.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: searches the top row of a table and returns a value from a specified row in the same column?
A. #DIV/0!
B. HLOOKUP
C. MONTH
D. TEXT
Correct Answer: B
HLOOKUP: searches the top row of a table and returns a value from a specified row in the same column.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: searches the first column of a table and returns a value from a specified column in the same row?
A. INDEX
B. VLOOKUP
C. Data Validation
D. Data Table
Correct Answer: B
VLOOKUP: searches the first column of a table and returns a value from a specified column in the same row.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns an alternative result when an expression produces an error?
A. Custom number format
B. INT
C. IFERROR
D. AND
Correct Answer: C
IFERROR: returns an alternative result when an expression produces an error.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: reverses TRUE to FALSE and FALSE to TRUE?
A. Freeze Panes
B. IF
C. TEXT
D. NOT
Correct Answer: D
NOT: reverses TRUE to FALSE and FALSE to TRUE.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns TRUE when at least one supplied logical condition is TRUE?
A. Filter
B. Protect Sheet
C. OR
D. Page Break
Correct Answer: C
OR: returns TRUE when at least one supplied logical condition is TRUE.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns TRUE only when all supplied logical conditions are TRUE?
A. Cell address
B. XMATCH
C. AND
D. Worksheet
Correct Answer: C
AND: returns TRUE only when all supplied logical conditions are TRUE.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: tests multiple conditions in order and returns the value for the first TRUE condition?
A. Filter
B. IFS
C. Split
D. COUNTBLANK
Correct Answer: B
IFS: tests multiple conditions in order and returns the value for the first TRUE condition.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns one result when a condition is TRUE and another when it is FALSE?
A. MONTH
B. TEXTJOIN
C. IF
D. SEARCH
Correct Answer: C
IF: returns one result when a condition is TRUE and another when it is FALSE.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: averages values that meet one criterion?
A. Conditional Formatting
B. AVERAGEIF
C. Goal Seek
D. MOD
Correct Answer: B
AVERAGEIF: averages values that meet one criterion.