Trivia Flashcards
7 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Trivia flashcards as text
Which function would you use to combine the text from two or more cells into one cell?
Answer: CONCATENATE
CONCATENATE (or the & operator, or CONCAT in newer versions) joins text strings from multiple cells into a single string.
What does 'PivotTable' allow you to do in Excel?
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.
Which Excel function returns the position of a value within a range?
Answer: MATCH
MATCH returns the relative position (row or column number) of a specified value within a range.
What is the file extension for a macro-enabled Excel workbook?
Answer: .xlsm
The .xlsm extension denotes a macro-enabled Excel workbook, while .xlsx files cannot contain VBA macros.
Which Excel tool is used to find the input value needed to achieve a specific formula result?
Answer: Goal Seek
Goal Seek finds the required input value by working backward from a desired formula result.
What does the IFERROR function do in Excel?
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.
In Excel, what is a 'named range'?
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.