Microsoft Excel Excel MCQ 2 — Questions and Answers
Question 1: Which Excel function returns the position of a value within a range?
- FIND
- MATCH (Correct answer)
- INDEX
- LOOKUP
Correct answer: MATCH
MATCH returns the relative position of a lookup value within a range.
Question 2: What does the $ symbol do when placed before a column letter in a cell reference (e.g., $A1)?
- Locks both the row and column
- Locks only the column (Correct answer)
- Locks only the row
- Converts the value to currency
Correct answer: Locks only the column
A $ before the column letter (e.g., $A1) locks the column while allowing the row to change when copied.
Question 3: Which keyboard shortcut inserts the current date in Excel?
- Ctrl + Shift + T
- Ctrl + ; (Correct answer)
- Ctrl + D
- Ctrl + Shift + D
Correct answer: Ctrl + ;
Ctrl + ; inserts the current static date into the selected cell.
Question 4: What is the result of =MOD(17, 5)?
- 3
- 2 (Correct answer)
- 4
- 1
Correct answer: 2
MOD(17, 5) returns 2 because 17 divided by 5 equals 3 with a remainder of 2.
Question 5: Which chart type is best suited for showing the proportion of parts to a whole?
- Bar chart
- Line chart
- Pie chart (Correct answer)
- Scatter chart
Correct answer: Pie chart
Pie charts are designed to show how individual parts contribute to a total whole.
Question 6: What does the TRIM function do in Excel?
- Removes all spaces from a text string
- Removes leading, trailing, and extra internal spaces (Correct answer)
- Shortens text to a specified length
- Removes numbers from a text string
Correct answer: Removes leading, trailing, and extra internal spaces
TRIM removes leading and trailing spaces and reduces multiple internal spaces to a single space.
Question 7: In Excel, which function would you use to count cells that meet multiple criteria?
- COUNTIF
- COUNTIFS (Correct answer)
- SUMIF
- COUNT
Correct answer: COUNTIFS
COUNTIFS counts cells that meet two or more criteria across one or more ranges.
Microsoft Excel Excel MCQ 2
Which Excel function returns the position of a value within a range?