CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: rounds a number down to the nearest integer?
A. Active cell
B. Print Titles
C. AVERAGE
D. INT
Correct Answer: D
INT: rounds a number down to the nearest integer.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: rounds a number toward zero to a specified number of digits?
A. ROUNDDOWN
B. SQRT
C. Cell address
D. SEARCH
Correct Answer: A
ROUNDDOWN: rounds a number toward zero to a specified number of digits.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: rounds a number away from zero to a specified number of digits?
A. ROUNDUP
B. #NAME?
C. Structured reference
D. Data Table
Correct Answer: A
ROUNDUP: rounds a number away from zero to a specified number of digits.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: rounds a number to a specified number of digits?
A. Custom number format
B. IF
C. NOT
D. ROUND
Correct Answer: D
ROUND: rounds a number to a specified number of digits.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: formats a value as text according to a format code?
A. TEXT
B. Drop-down list
C. #NAME?
D. AVERAGE
Correct Answer: A
TEXT: formats a value as text according to a format code.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: replaces characters at a specified position and length in a text string?
A. Slicer
B. Protect Workbook
C. REPLACE
D. Text to Columns
Correct Answer: C
REPLACE: replaces characters at a specified position and length in a text string.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: replaces matching text within a string?
A. Sort
B. SUBSTITUTE
C. LOWER
D. Solver
Correct Answer: B
SUBSTITUTE: replaces matching text within a string.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns the position of one text string inside another and is not case-sensitive?
A. Page Break
B. SUM
C. Range
D. SEARCH
Correct Answer: D
SEARCH: returns the position of one text string inside another and is not case-sensitive.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: returns the position of one text string inside another and is case-sensitive?
A. FIND
B. Sort
C. AutoFill
D. Circular reference
Correct Answer: A
FIND: returns the position of one text string inside another and is case-sensitive.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: joins text using a specified delimiter and can ignore empty cells?
A. Filter
B. TEXTJOIN
C. #DIV/0!
D. Excel Table
Correct Answer: B
TEXTJOIN: joins text using a specified delimiter and can ignore empty cells.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: joins text from multiple arguments or ranges?
A. CONCAT
B. Comment
C. FILTER
D. FIND
Correct Answer: A
CONCAT: joins text from multiple arguments or ranges.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: capitalizes the first letter of each word in text?
A. Zoom
B. NOW
C. SUBTOTAL
D. PROPER
Correct Answer: D
PROPER: capitalizes the first letter of each word in text.
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.