Microsoft Excel Trivia 4 — Questions and Answers
Question 1: Which function would you use to combine the text from two or more cells into one cell?
- MERGE
- JOIN
- CONCATENATE (Correct answer)
- APPEND
Correct answer: CONCATENATE
CONCATENATE (or the & operator, or CONCAT in newer versions) joins text strings from multiple cells into a single string.
Question 2: What does 'PivotTable' allow you to do in Excel?
- Rotate charts to new orientations
- Summarize and analyze large data sets interactively (Correct answer)
- Merge multiple worksheets
- Create drop-down menus
Correct answer: Summarize and analyze large data sets interactively
A PivotTable is an interactive tool that quickly summarizes, groups, and analyzes large datasets without changing the original data.
Question 3: Which Excel function returns the position of a value within a range?
- FIND
- SEARCH
- MATCH (Correct answer)
- INDEX
Correct answer: MATCH
MATCH returns the relative position (row or column number) of a specified value within a range.
Question 4: What is the file extension for a macro-enabled Excel workbook?
- .xlsx
- .xlsm (Correct answer)
- .xltm
- .xlam
Correct answer: .xlsm
The .xlsm extension denotes a macro-enabled Excel workbook, while .xlsx files cannot contain VBA macros.
Question 5: Which Excel tool is used to find the input value needed to achieve a specific formula result?
- Solver
- Goal Seek (Correct answer)
- Scenario Manager
- Data Table
Correct answer: Goal Seek
Goal Seek finds the required input value by working backward from a desired formula result.
Question 6: What does the IFERROR function do in Excel?
- Counts errors in a range
- Returns a custom value if a formula produces an error, otherwise returns the formula result (Correct answer)
- Highlights error cells in red
- Prevents errors from being entered
Correct answer: Returns a custom value if a formula produces an error, otherwise returns the formula result
IFERROR evaluates a formula and returns a specified value (like blank or text) if it results in an error, instead of displaying the error code.
Question 7: In Excel, what is a 'named range'?
- A range with color-coded cells
- A cell or range of cells given a descriptive name for use in formulas (Correct answer)
- A range that has been sorted alphabetically
- A range linked to an external data source
Correct answer: A cell or range of cells given a descriptive name for use in formulas
A named range assigns a meaningful label to a cell or range, allowing you to use that name instead of cell addresses in formulas.
Microsoft Excel Trivia 4
Which function would you use to combine the text from two or more cells into one cell?