MOS Excel 4 — Questions and Answers
Question 1: When sorting a table in Excel, what happens if you select 'My data has headers' in the Sort dialog?
- Headers are sorted alphabetically first
- The header row is excluded from sorting and remains at the top (Correct answer)
- Only header rows are sorted
- Headers are bolded automatically
Correct answer: The header row is excluded from sorting and remains at the top
Selecting 'My data has headers' tells Excel to exclude the first row from sorting so it stays as the column label.
Question 2: Which Excel function returns a value from a table based on a row number and column number you specify?
- VLOOKUP
- HLOOKUP
- INDEX (Correct answer)
- OFFSET
Correct answer: INDEX
INDEX returns the value at the intersection of a specified row and column within a given range.
Question 3: What format does Excel use to store dates internally?
- Text strings like '01/01/2024'
- Sequential serial numbers starting from January 1, 1900 (Correct answer)
- Unix timestamps
- ISO 8601 format strings
Correct answer: Sequential serial numbers starting from January 1, 1900
Excel stores dates as sequential serial numbers — January 1, 1900 is 1 — which allows date arithmetic.
Question 4: Which Excel feature highlights cells that meet conditions you define, using color scales, data bars, or icon sets?
- Cell Styles
- Table Formatting
- Conditional Formatting (Correct answer)
- Format as Table
Correct answer: Conditional Formatting
Conditional Formatting automatically applies formatting such as colors or icons to cells based on rules you define.
Question 5: In Excel, what is a PivotTable primarily used for?
- Creating macros to automate tasks
- Summarizing, analyzing, and exploring large data sets interactively (Correct answer)
- Formatting cells with conditional rules
- Linking data from external databases
Correct answer: Summarizing, analyzing, and exploring large data sets interactively
A PivotTable lets you summarize and analyze large data sets by dragging fields into rows, columns, and value areas.
Question 6: Which keyboard shortcut inserts the current time into a cell in Excel?
- Ctrl+;
- Ctrl+Shift+; (Correct answer)
- Ctrl+T
- Ctrl+Shift+T
Correct answer: Ctrl+Shift+;
Ctrl+Shift+; inserts the current time as a static value into the active cell.
Question 7: What does the IFERROR function do in Excel?
- Prevents formulas from being entered incorrectly
- Returns a specified value if a formula results in an error, otherwise returns the formula's result (Correct answer)
- Highlights cells containing errors in red
- Logs errors to a separate worksheet
Correct answer: Returns a specified value if a formula results in an error, otherwise returns the formula's result
IFERROR evaluates a formula and returns a custom value if it produces an error, or the formula result if no error occurs.
MOS Excel 4
When sorting a table in Excel, what happens if you select 'My data has headers' in the Sort dialog?