MOS Excel 2

Question 1

Which Excel function returns the number of cells in a range that meet a single condition?

Accepted Answer

COUNTIF

Answer

COUNTIF counts cells within a range that meet a specified single condition.

Question 2

When you freeze panes in Excel, what is frozen by default when you select cell B2 and apply Freeze Panes?

Accepted Answer

Row 1 and column A

Answer

Freeze Panes with B2 selected freezes everything above and to the left — row 1 and column A.

Question 3

Which keyboard shortcut applies the Currency format to selected cells in Excel?

Accepted Answer

Ctrl+Shift+$

Answer

Ctrl+Shift+$ applies the Currency number format to selected cells.

Question 4

In Excel, what does the TRIM function do?

Accepted Answer

Removes leading, trailing, and extra spaces between words

Answer

TRIM removes leading and trailing spaces and reduces multiple spaces between words to a single space.

Question 5

What is the purpose of the Name Box in Excel?

Accepted Answer

Shows and navigates to cell references or named ranges

Answer

The Name Box (left of the formula bar) displays the current cell address and can be used to navigate to or name ranges.

MOS - Microsoft Office Specialist Certification Practice Test