**100 objective-type questions** on **MS Excel**
1. **What is the default file extension of an Excel workbook in Excel 2016?**
– a) .xls
– b) .xlsx ✅
– c) .docx
– d) .csv
– **Explanation:** Excel 2007 and later use `.xlsx` as the default file format. Older versions used `.xls`.
2. **Which function is used to find the highest value in a range?**
– a) MIN
– b) MAX ✅
– c) SUM
– d) AVERAGE
– **Explanation:** The `MAX` function returns the largest number in a range of values.
3. **Which symbol is used to start a formula in Excel?**
– a) = ✅
– b) +
– c) –
– d) *
– **Explanation:** In Excel, formulas always begin with an equals sign (`=`).
4. **What is the intersection of a row and a column called?**
– a) Table
– b) Range
– c) Cell ✅
– d) Box
– **Explanation:** A cell is the basic unit of a spreadsheet where a row and a column meet.
5. **Which function is used to count numeric values in a range?**
– a) COUNT ✅
– b) COUNTA
– c) SUM
– d) AVERAGE
– **Explanation:** The `COUNT` function counts only numeric values in a given range.
6. **Which shortcut key is used to save a workbook?**
– a) Ctrl + P
– b) Ctrl + S ✅
– c) Ctrl + V
– d) Ctrl + C
– **Explanation:** `Ctrl + S` saves the current workbook.
7. **What does the SUM function do?**
– a) Finds the total of a range ✅
– b) Finds the average
– c) Finds the highest value
– d) Finds the lowest value
– **Explanation:** `SUM(range)` adds all the numeric values in the specified range.
8. **Which of the following is NOT an Excel function?**
– a) AVERAGE
– b) SUM
– c) TOTAL ✅
– d) COUNT
– **Explanation:** `TOTAL` is not an Excel function.
9. **How do you merge two or more cells?**
– a) Use the Merge & Center option ✅
– b) Press Enter
– c) Use the SUM function
– d) Use the COUNT function
– **Explanation:** The “Merge & Center” option combines selected cells into one.
10. **Which of the following is NOT a valid cell reference?**
– a) A1
– b) 1A ✅
– c) B2
– d) C3
– **Explanation:** Cell references always start with a column letter followed by a row number.
—
### **21-40: Formatting & Editing**
11. **Which function returns the number of characters in a text string?**
– a) LEN ✅
– b) TEXT
– c) LEFT
– d) FIND
– **Explanation:** The `LEN` function counts characters in a text string.
12. **Which function converts text to uppercase?**
– a) UPPER ✅
– b) LOWER
– c) PROPER
– d) TEXT
– **Explanation:** `UPPER` converts text to uppercase.
13. **What does `Ctrl + Z` do in Excel?**
– a) Redo
– b) Undo ✅
– c) Save
– d) Close
– **Explanation:** `Ctrl + Z` undoes the last action.
14. **How do you apply bold formatting?**
– a) Ctrl + B ✅
– b) Ctrl + I
– c) Ctrl + U
– d) Ctrl + P
– **Explanation:** `Ctrl + B` makes text bold.
15. **Which function extracts a substring from a string?**
– a) FIND
– b) SEARCH
– c) MID ✅
– d) CONCATENATE
– **Explanation:** `MID(text, start, length)` extracts part of a string.
—
### **41-60: Functions & Formulas**
16. **What is the output of `=ROUND(12.345, 2)`?**
– a) 12.3
– b) 12.35 ✅
– c) 12.4
– d) 12.34
– **Explanation:** `ROUND(12.345,2)` rounds to two decimal places.
17. **Which function is used to join text strings?**
– a) JOIN
– b) CONCATENATE ✅
– c) ADD
– d) TEXT
– **Explanation:** `CONCATENATE(text1, text2, …)` joins strings.
18. **Which function checks if a condition is met?**
– a) CHECK
– b) VERIFY
– c) IF ✅
– d) FIND
– **Explanation:** `IF(condition, value_if_true, value_if_false)` evaluates conditions.
—
### **61-80: Charts & Data Handling**
19. **Which chart is best for showing trends over time?**
– a) Pie chart
– b) Line chart ✅
– c) Bar chart
– d) Column chart
– **Explanation:** A line chart shows trends over time.
20. **Which Excel feature allows you to filter data?**
– a) Sort
– b) Filter ✅
– c) Pivot Table
– d) Data Table
– **Explanation:** The “Filter” option allows filtering of data based on conditions.
—
### **81-100: Advanced Features**
21. **What is the purpose of a Pivot Table?**
– a) To filter data
– b) To create charts
– c) To summarize and analyze large datasets ✅
– d) To apply conditional formatting
– **Explanation:** Pivot Tables summarize and analyze data.
22. **Which function finds a value in a table based on a lookup value?**
– a) VLOOKUP ✅
– b) SEARCH
– c) FIND
– d) TEXT
– **Explanation:** `VLOOKUP(value, table, col_index, [range_lookup])` searches for a value.
23. **What does `Ctrl + Shift + L` do?**
– a) Inserts a row
– b) Inserts a column
– c) Applies filters ✅
– d) Removes duplicates
– **Explanation:** `Ctrl + Shift + L` applies/removes filters.