MS Excel Formulas and Functions in PSC Exams MCQs

1. Which symbol is always used to begin a formula in MS Excel?
(A) +
(B) =
(C) #
(D) $

2. Which function is used to calculate the average of a range of numbers?
(A) SUM
(B) COUNT
(C) AVERAGE
(D) MAX

3. What does the function =LEN("PSC Exam") return?
(A) 7
(B) 8
(C) 10
(D) 9

4. Which function is used to count only numeric values in a range?
(A) COUNTA
(B) COUNT
(C) COUNTIF
(D) COUNTBLANK

5. What does the function =ROUND(12.567,2) return?
(A) 12.57
(B) 12.60
(C) 12.56
(D) 13.00

6. Which function is used to find the largest number in a range?
(A) MIN
(B) MAX
(C) LARGE
(D) RANK

7. Which function will return the current system date in Excel?
(A) TODAY()
(B) NOW()
(C) DATE()
(D) TIME()

8. Which Excel function is used to combine text from two or more cells?
(A) JOINCELLS
(B) TEXTJOIN
(C) MERGE
(D) CONCATENATE / CONCAT

9. If a cell contains =IF(5>3,"Yes","No"), what will be displayed?
(A) 5
(B) 3
(C) Yes
(D) No

10. Which function is used to look up a value in the leftmost column and return a value from another column in the same row?
(A) HLOOKUP
(B) MATCH
(C) INDEX
(D) VLOOKUP