GMetrix Exam Microsoft Office Skills 2

Question 1

In Excel, which function returns the number of cells in a range that meet a specific condition?

Accepted Answer

COUNTIF

Answer

COUNTIF counts the number of cells within a range that meet a given criterion.

Question 2

In Word, what does the 'Track Changes' feature do?

Accepted Answer

Records all edits made to the document so they can be reviewed

Answer

Track Changes marks insertions, deletions, and formatting changes so reviewers can accept or reject them.

Question 3

In PowerPoint, which view shows all slides as small thumbnails in a grid for easy reordering?

Accepted Answer

Slide Sorter View

Answer

Slide Sorter View displays all slides as thumbnails, making it easy to rearrange the presentation order.

Question 4

In Excel, what is the keyboard shortcut to apply the SUM function to a selected range?

Accepted Answer

Alt+=

Answer

Alt+= (AutoSum) automatically inserts a SUM formula for the adjacent range.

Question 5

In Outlook, what does the 'BCC' field do when sending an email?

Accepted Answer

Sends a copy to recipients whose addresses are hidden from other recipients

Answer

BCC (Blind Carbon Copy) sends the email to recipients without revealing their addresses to other recipients.

GMetrix Exam Practice Test