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.
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.