MOS Excel 4

Question 1

When sorting a table in Excel, what happens if you select 'My data has headers' in the Sort dialog?

Accepted Answer

The header row is excluded from sorting and remains at the top

Answer

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?

Accepted Answer

INDEX

Answer

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?

Accepted Answer

Sequential serial numbers starting from January 1, 1900

Answer

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?

Accepted Answer

Conditional Formatting

Answer

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?

Accepted Answer

Summarizing, analyzing, and exploring large data sets interactively

Answer

A PivotTable lets you summarize and analyze large data sets by dragging fields into rows, columns, and value areas.

MOS - Microsoft Office Specialist Certification Practice Test