MOS Excel 5

Question 1

Which Excel function returns the position of a value within a range?

Accepted Answer

MATCH

Answer

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?

Accepted Answer

The table expands and applies existing formatting and formulas to the new row

Answer

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?

Accepted Answer

NETWORKDAYS

Answer

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?

Accepted Answer

IF(logical_test, value_if_true, value_if_false)

Answer

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?

Accepted Answer

Page Layout view

Answer

Page Layout view displays the worksheet with rulers, margins, headers, footers, and page edges as they will appear when printed.

MOS - Microsoft Office Specialist Certification Practice Test