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

COUNT

Answer

SUMIF

Answer

COUNTA

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

It is deleted automatically

Answer

It is converted and replaced by the PDF

Answer

It is moved to a backup folder

Question 3

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

Accepted Answer

Recent Documents list

Answer

Quick Launch toolbar

Answer

Favorites folder

Answer

Pin to Taskbar

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

XLSX

Answer

XLS

Answer

XLSM

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

Permanently locks the file so it cannot be opened without a password

Answer

Encrypts the document with a digital certificate

Answer

Deletes all tracked changes and comments

Question 6

When recovering an unsaved Word document, where would you typically look first?

Accepted Answer

The AutoRecover file location set in Word Options

Answer

The Windows Recycle Bin

Answer

The Documents library default folder

Answer

The OneDrive version history