CSS - PMS - CCE - PCS - Basic Computing
MS Excel
What is the result of =ABS(-27)?
A. 0
B. -27
C. 27
D. 1
Correct Answer: C
ABS returns the magnitude without the sign.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
What is the result of =MOD(17,5)?
A. 12
B. 3
C. 5
D. 2
Correct Answer: D
17 divided by 5 leaves a remainder of 2.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
What is the result of =ROUNDDOWN(12.349,2)?
A. 13.00
B. 12.35
C. 12.30
D. 12.34
Correct Answer: D
ROUNDDOWN rounds toward zero.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
What is the result of =ROUNDUP(12.341,2)?
A. 12.35
B. 12.34
C. 13.00
D. 12.30
Correct Answer: A
ROUNDUP rounds away from zero at the requested precision.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
What is the result of =ROUND(12.345,2)?
A. 13.00
B. 12.35
C. 12.3
D. 12.34
Correct Answer: B
ROUND to two decimal places gives 12.35.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
What is the result of =NOT(TRUE)?
A. 0
B. TRUE
C. 1
D. FALSE
Correct Answer: D
NOT reverses TRUE to FALSE.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
What is the result of =OR(2>5,4=4)?
A. FALSE
B. TRUE
C. 2
D. 4
Correct Answer: B
At least one condition is TRUE.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
What is the result of =AND(3<5,10=10)?
A. 3
B. FALSE
C. TRUE
D. 10
Correct Answer: C
Both logical tests are TRUE.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
What is the result of =IF(7>5,"Yes","No")?
A. Yes
B. 7
C. TRUE
D. No
Correct Answer: A
Because 7>5 is TRUE, IF returns the first result.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
What is the result of =COUNTA(5,"A","",10) when the empty string is a formula result and therefore non-empty?
A. 4
B. 2
C. 1
D. 3
Correct Answer: A
COUNTA counts non-empty values, and a formula returning an empty string is still counted as non-empty.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
What is the result of =COUNT(5,"A",8,"",10)?
A. 4
B. 2
C. 5
D. 3
Correct Answer: D
COUNT counts numeric arguments/cells; 5, 8, and 10 are numeric.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
What is the result of =MAX(7,2,9,4)?
A. 4
B. 7
C. 2
D. 9
Correct Answer: D
MAX returns the largest value.
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.