CSS - PMS - CCE - PCS - Basic Computing
MS Excel
What is the result of =POWER(3,4)?
A. 12
B. 27
C. 64
D. 81
Correct Answer: D
3 raised to the fourth power is 81.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
What is the result of =SQRT(144)?
A. 72
B. 14
C. 24
D. 12
Correct Answer: D
The positive square root of 144 is 12.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
What is the result of =PROPER("basic computing")?
A. BASIC COMPUTING
B. Basic Computing
C. basic computing
D. Basic computing
Correct Answer: B
PROPER capitalizes the initial letter of each word.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
What is the result of =LOWER("DATA")?
A. Data
B. DATA
C. dATA
D. data
Correct Answer: D
LOWER converts all letters to lowercase.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
What is the result of =MID("Computer",2,3)?
A. Com
B. put
C. mpu
D. omp
Correct Answer: D
Starting at character 2 and taking 3 characters yields 'omp'.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
What is the result of =RIGHT("Computer",3)?
A. Com
B. ter
C. uter
D. put
Correct Answer: B
RIGHT returns the last three characters.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
What is the result of =LEFT("Computer",3)?
A. Com
B. put
C. Comp
D. ter
Correct Answer: A
LEFT returns the first three characters.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
What is the result of =LEN("Pakistan")?
A. 9
B. 10
C. 8
D. 7
Correct Answer: C
Pakistan contains eight characters.
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.