Questions 26–50 with Answers & Explanations
26. Which function joins text from multiple cells into one cell?
A) JOIN()
B) CONCAT()
C) TEXT()
D) SPLIT()
✅ Correct Answer: B) CONCAT()
Explanation: The CONCAT() function combines text from multiple cells into a single string.
27. Which Excel function converts text to uppercase?
A) UPPER()
B) CAPITAL()
C) UCASE()
D) LARGE()
✅ Correct Answer: A) UPPER()
Explanation: UPPER() converts all letters in a text string to uppercase.
28. Which function converts text to lowercase?
A) LOWER()
B) SMALL()
C) CASE()
D) LCASE()
✅ Correct Answer: A) LOWER()
Explanation: LOWER() changes all letters in a text string to lowercase.
29. Which function counts blank cells?
A) COUNT()
B) COUNTA()
C) COUNTBLANK()
D) COUNTIF()
✅ Correct Answer: C) COUNTBLANK()
Explanation: COUNTBLANK() counts only empty cells within a specified range.
30. Which function finds the length of a text string?
A) SIZE()
B) LEN()
C) TEXTLEN()
D) COUNT()
✅ Correct Answer: B) LEN()
Explanation: LEN() returns the number of characters in a text string.
31. Which function returns the current year from a date?
A) TODAY()
B) YEAR()
C) DATE()
D) MONTH()
✅ Correct Answer: B) YEAR()
Explanation: YEAR() extracts the year from a valid date.
32. Which function extracts the month from a date?
A) MONTH()
B) DATE()
C) DAY()
D) WEEK()
✅ Correct Answer: A) MONTH()
Explanation: MONTH() returns the month number (1–12).
33. Which function extracts the day from a date?
A) TODAY()
B) DAY()
C) DATE()
D) YEAR()
✅ Correct Answer: B) DAY()
Explanation: DAY() returns the day of the month.
34. Which keyboard shortcut opens the Find dialog box?
A) Ctrl + F
B) Ctrl + H
C) Ctrl + G
D) Ctrl + K
✅ Correct Answer: A) Ctrl + F
Explanation: Ctrl + F is used to search for specific text or values.
35. Which shortcut opens the Replace dialog box?
A) Ctrl + G
B) Ctrl + H
C) Ctrl + R
D) Ctrl + Shift + H
✅ Correct Answer: B) Ctrl + H
Explanation: Ctrl + H opens the Find and Replace window.
36. Which Ribbon tab contains the Conditional Formatting option?
A) Home
B) Insert
C) Data
D) Review
✅ Correct Answer: A) Home
Explanation: Conditional Formatting is available on the Home tab.
37. Which feature removes duplicate values from a list?
A) Filter
B) Remove Duplicates
C) Sort
D) Group
✅ Correct Answer: B) Remove Duplicates
Explanation: The Remove Duplicates tool deletes duplicate records while keeping unique values.
38. Which Excel feature automatically fills a series of values?
A) AutoFill
B) AutoSum
C) Flash Fill
D) Data Validation
✅ Correct Answer: A) AutoFill
Explanation: AutoFill quickly copies formulas or creates sequences such as numbers and dates.
39. Which function is commonly used to round a number?
A) ROUND()
B) FIX()
C) TRIM()
D) ABS()
✅ Correct Answer: A) ROUND()
Explanation: ROUND() rounds a number to the specified number of decimal places.
40. Which keyboard shortcut inserts a new worksheet?
A) Shift + F11
B) Ctrl + N
C) Ctrl + Shift + N
D) Alt + N
✅ Correct Answer: A) Shift + F11
Explanation: Shift + F11 inserts a new worksheet into the workbook.
41. Which feature protects a worksheet from unauthorized changes?
A) Freeze Panes
B) Protect Sheet
C) Split
D) Sort
✅ Correct Answer: B) Protect Sheet
Explanation: Protect Sheet prevents users from editing locked cells.
42. Which Ribbon tab contains the Sort and Filter commands?
A) Home
B) Data
C) View
D) Review
✅ Correct Answer: B) Data
Explanation: The Data tab contains Sort, Filter, Remove Duplicates, and Data Validation tools.
43. Which chart is best for showing trends over time?
A) Pie Chart
B) Line Chart
C) Doughnut Chart
D) Radar Chart
✅ Correct Answer: B) Line Chart
Explanation: A Line Chart is ideal for displaying changes or trends over time.
44. Which function returns the absolute value of a number?
A) ABS()
B) MOD()
C) SIGN()
D) ROUND()
✅ Correct Answer: A) ABS()
Explanation: ABS() converts negative numbers into positive values.
45. Which shortcut selects the entire worksheet?
A) Ctrl + A
B) Ctrl + S
C) Ctrl + D
D) Ctrl + E
✅ Correct Answer: A) Ctrl + A
Explanation: Ctrl + A selects all cells in the worksheet.
46. Which Excel feature highlights cells based on rules?
A) Conditional Formatting
B) Data Validation
C) Freeze Panes
D) Filter
✅ Correct Answer: A) Conditional Formatting
Explanation: Conditional Formatting automatically changes cell formatting based on specified conditions.
47. Which function returns the remainder after division?
A) DIV()
B) MOD()
C) REM()
D) ROUND()
✅ Correct Answer: B) MOD()
Explanation: MOD() returns the remainder after one number is divided by another.
48. Which function removes extra spaces from text?
A) TRIM()
B) CLEAN()
C) SPACE()
D) LEN()
✅ Correct Answer: A) TRIM()
Explanation: TRIM() removes unnecessary spaces except single spaces between words.
49. Which feature creates graphical representations of data?
A) Tables
B) Charts
C) Pivot Tables
D) Comments
✅ Correct Answer: B) Charts
Explanation: Charts help visualize data using bars, lines, pies, and other graphical formats.
50. Which formula is used to add values from cells A1 to A10?
A) =ADD(A1:A10)
B) =SUM(A1:A10)
C) =TOTAL(A1:A10)
D) =COUNT(A1:A10)
✅ Correct Answer: B) =SUM(A1:A10)
Explanation: =SUM(A1:A10) adds all numeric values from cells A1 through A10.