MOS Excel 3

Question 1

In an Excel formula, what does the $ symbol do when placed before a column letter or row number?

Accepted Answer

Creates an absolute reference that does not change when copied

Answer

The $ symbol creates an absolute reference, preventing the row or column from changing when the formula is copied.

Question 2

Which chart type is best suited for showing the proportion of parts to a whole?

Accepted Answer

Pie chart

Answer

A pie chart displays data as slices of a circle, making it ideal for showing each category's proportion of a total.

Question 3

What does the Excel function TODAY() return?

Accepted Answer

The current date only

Answer

TODAY() returns the current date as a serial number formatted as a date, with no time component.

Question 4

Which option in Excel's Paste Special dialog lets you paste only the results of formulas, not the formulas themselves?

Accepted Answer

Paste Values

Answer

Paste Values pastes only the calculated results of formulas, stripping out the underlying formula.

Question 5

In Excel, which of the following is a valid way to reference the range A1 to D10?

Accepted Answer

A1:D10

Answer

The colon (:) operator defines a range from the first cell to the last cell, so A1:D10 references all cells from A1 through D10.

MOS - Microsoft Office Specialist Certification Practice Test