MCAS Managing Files & Data 2

Question 1

In Microsoft Excel, which function would you use to count only the cells in a range that meet a specific condition?

Accepted Answer

COUNTIF

Answer

COUNTIF counts cells within a range that meet a single criterion you specify.

Question 2

When you use 'Save As' to save a Word document as a PDF, what happens to the original DOCX file?

Accepted Answer

It remains unchanged; a new PDF file is created

Answer

Save As creates a new file in the chosen format while leaving the original file intact and unchanged.

Question 3

Which Microsoft Office feature lets you open recently accessed files quickly without browsing to their folder?

Accepted Answer

Recent Documents list

Answer

The Recent Documents list in the File menu displays files you have recently opened for quick access.

Question 4

In Excel, what file format preserves ONLY the data values (no formatting or formulas) and is widely used for data exchange?

Accepted Answer

CSV

Answer

CSV (Comma-Separated Values) stores only plain data, making it universally compatible for data exchange between different programs.

Question 5

What is the purpose of 'Mark as Final' in Microsoft Office documents?

Accepted Answer

Marks the document as read-only to discourage further editing

Answer

'Mark as Final' sets the document to read-only status and communicates to readers that the document is complete, though it can still be edited.

MCAS - Microsoft Certified Application Specialist Practice Test