MOS Excel 5 — Questions and Answers
Question 1: Which Excel function returns the position of a value within a range?
- FIND
- SEARCH
- MATCH (Correct answer)
- LOOKUP
Correct answer: MATCH
MATCH returns the relative position of a lookup value within a range, not the value itself.
Question 2: When working with an Excel Table (Insert > Table), what happens to formulas and formatting when you add a new row at the bottom?
- Nothing changes automatically
- The table expands and applies existing formatting and formulas to the new row (Correct answer)
- The new row is added as a separate range
- Excel asks whether to extend the table
Correct answer: The table expands and applies existing formatting and formulas to the new row
Excel Tables automatically expand to include new adjacent rows and extend formulas and formatting to them.
Question 3: Which of these functions calculates the number of workdays between two dates, excluding weekends?
- DAYS
- NETWORKDAYS (Correct answer)
- WORKDAY
- DATEIF
Correct answer: NETWORKDAYS
NETWORKDAYS calculates the number of whole working days between two dates, excluding weekends and optionally holidays.
Question 4: In Excel, what is the correct syntax for an IF function?
- IF(value_if_true, value_if_false, logical_test)
- IF(logical_test, value_if_true, value_if_false) (Correct answer)
- IF(logical_test, value_if_false, value_if_true)
- IF(value_if_true, logical_test, value_if_false)
Correct answer: IF(logical_test, value_if_true, value_if_false)
The IF function syntax is IF(logical_test, value_if_true, value_if_false) — the condition comes first.
Question 5: Which Excel view shows exactly how a worksheet will look when printed, including page breaks and margins?
- Normal view
- Page Break Preview
- Page Layout view (Correct answer)
- Print Preview
Correct answer: Page Layout view
Page Layout view displays the worksheet with rulers, margins, headers, footers, and page edges as they will appear when printed.
Question 6: What is the purpose of the Excel ROUND function?
- Rounds a number to the nearest integer only
- Rounds a number to a specified number of digits (Correct answer)
- Removes decimal places without rounding
- Converts text numbers to rounded values
Correct answer: Rounds a number to a specified number of digits
ROUND(number, num_digits) rounds a number to the specified number of decimal places or significant digits.
Question 7: Which Excel feature lets you record a sequence of actions and replay them automatically with a single click?
- Quick Access Toolbar shortcut
- Macro (Correct answer)
- Template
- Watch Window
Correct answer: Macro
A Macro records a sequence of Excel commands and actions that can be replayed to automate repetitive tasks.
MOS Excel 5
Which Excel function returns the position of a value within a range?