MCQS ON MS EXCEL
1. Which of the following is not a function of Microsoft Excel?
a) Data Analysis
b) Word Processing
c) Calculation
d) Data Visualization
The correct answer is b) Word Processing.
2. What does the acronym “URL” stand for?
a) Uniform Resource Locator
b) Universal Remote Locator
c) Uniform Retrieval Link
d) Unified Resource Locator
The correct answer is a) Uniform Resource Locator.
3. Which Excel feature allows you to combine data from multiple sources?
a) Pivot Tables
b) Conditional Formatting
c) Data Consolidation
d) VLOOKUP
The correct answer is c) Data Consolidation.
4. Which function is used to find the highest value in a range?
a) MAX
b) MIN
c) AVG
d) SUM
The correct answer is a) MAX.
5. Which chart type is used to show the relationship between two variables?
a) Bar Chart
b) Scatter Plot
c) Pie Chart
d) Line Chart
The correct answer is b) Scatter Plot.
6. What does the “IF” function in Excel do?
a) Evaluates a condition and returns a value based on the result
b) Adds a range of values
c) Sorts data in ascending order
d) Converts text to uppercase
The correct answer is a) Evaluates a condition and returns a value based on the result.
7. What does the “COUNT” function in Excel do?
a) Adds up a range of numbers
b) Finds the average of a range of numbers
c) Counts the number of cells with numbers in a range
d) Sorts data in descending order
The correct answer is c) Counts the number of cells with numbers in a range.
8. What is the keyboard shortcut to paste special in Excel?
a) Ctrl + V
b) Ctrl + P
c) Ctrl + Alt + V
d) Ctrl + C
The correct answer is c) Ctrl + Alt + V.
9. Which Excel feature allows you to filter and analyze data based on specific criteria?
a) AutoFill
b) Subtotals
c) Data Validation
d) Advanced Filter
The correct answer is d) Advanced Filter.
10. What function is used to round a number to the nearest integer in Excel?
a) ROUND
b) INT
c) CEILING
d) FLOOR
The correct answer is a) ROUND.
11. Which function is used to perform a logical test in Excel?
a) IF
b) AND
c) OR
d) NOT
The correct answer is a) IF.
12. Which chart type is used to display data values as percentages of a whole?
a) Bar Chart
b) Pie Chart
c) Line Chart
d) Scatter Plot
The correct answer is b) Pie Chart.
13. What function is used to find the average of a range of numbers in Excel?
a) AVG
b) SUM
c) AVERAGE
d) MEAN
The correct answer is c) AVERAGE.
14. Which Excel function is used to combine text strings from multiple cells?
a) CONCATENATE
b) TEXTJOIN
c) MERGE
d) COMBINE
The correct answer is a) CONCATENATE.
15. Which Excel feature allows you to automate repetitive tasks by recording a series of actions?
a) AutoFormat
b) Macro
c) Template
d) Hyperlink
The correct answer is b) Macro.
16. Which Excel feature allows you to combine data from multiple sheets into a single sheet?
a) Cell References
b) Formula Bar
c) Consolidate
d) Data Validation
The correct answer is c) Consolidate.
17. What is the purpose of the “Freeze Panes” feature in Excel?
a) To lock a specific cell
b) To freeze rows and columns for easy viewing
c) To hide formulas in a worksheet
d) To split a worksheet into multiple windows
The correct answer is b) To freeze rows and columns for easy viewing.
18. What does the “VLOOKUP” function do in Excel?
a) Searches for a value in the first column of a range and returns a corresponding value
b) Adds a range of values
c) Finds the average of a range of numbers
d) Converts text to uppercase
The correct answer is a) Searches for a value in the first column of a range and returns a corresponding value.
19. Which Excel function is used to count the number of cells that meet a specific condition?
a) COUNTIF
b) SUMIF
c) AVERAGEIF
d) IF
The correct answer is a) COUNTIF.
20. Which keyboard shortcut is used to insert a new worksheet in Excel?
a) Shift + F11
b) Ctrl + N
c) Ctrl + Shift + N
d) Ctrl + Insert
The correct answer is a) Shift + F11.
21. Which function is used to find the largest value that is less than or equal to a given value in a sorted range?
a) VLOOKUP
b) HLOOKUP
c) MATCH
d) INDEX
The correct answer is c) MATCH.
22. What does the “PMT” function do in Excel?
a) Calculates the payment for a loan based on constant payments and a constant interest rate
b) Finds the percentage change between two values
c) Rounds a number up to the nearest integer
d) Counts the number of cells that meet a specific condition
The correct answer is a) Calculates the payment for a loan based on constant payments and a constant interest rate.
23. Which Excel function is used to find the position of a value in a range?
a) VLOOKUP
b) HLOOKUP
c) MATCH
d) INDEX
The correct answer is c) MATCH.
24. Which Excel feature is used to apply formatting based on specified conditions?
a) AutoFormat
b) Conditional Formatting
c) Data Validation
d) Data Consolidation
The correct answer is b) Conditional Formatting.
25. What function is used to find the smallest value in a range?
a) MAX
b) MIN
c) AVG
d) SUM
The correct answer is b) MIN.
26. Which Excel function is used to count the number of cells with text in a range?
a) COUNT
b) COUNTA
c) COUNTIF
d) SUM
The correct answer is b) COUNTA.
27. Which Excel function is used to remove duplicate values from a range?
a) REMOVE_DUPLICATES
b) DUPLICATE_REMOVAL
c) DELETE_DUPLICATES
d) REMOVE_DUPS
The correct answer is c) DELETE_DUPLICATES.
28. Which Excel function is used to calculate the compound interest for an investment?
a) SIMPLE
b) COMPOUND
c) COMPOUNDINTEREST
d) FV
The correct answer is d) FV.
29. What function is used to find the remainder of a division in Excel?
a) MOD
b) REM
c) DIV
d) QUOTIENT
The correct answer is a) MOD.
30. Which Excel function is used to find the largest value in a range?
a) MAX
b) MIN
c) AVG
d) SUM
The correct answer is a) MAX.