MCAS Managing Files & Data 2 — Questions and Answers
Question 1: In Microsoft Excel, which function would you use to count only the cells in a range that meet a specific condition?
- COUNT
- COUNTIF (Correct answer)
- SUMIF
- COUNTA
Correct answer: COUNTIF
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?
- It is deleted automatically
- It remains unchanged; a new PDF file is created (Correct answer)
- It is converted and replaced by the PDF
- It is moved to a backup folder
Correct answer: It remains unchanged; a new PDF file is created
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?
- Quick Launch toolbar
- Recent Documents list (Correct answer)
- Favorites folder
- Pin to Taskbar
Correct answer: Recent Documents list
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?
- XLSX
- CSV (Correct answer)
- XLS
- XLSM
Correct answer: CSV
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?
- Permanently locks the file so it cannot be opened without a password
- Marks the document as read-only to discourage further editing (Correct answer)
- Encrypts the document with a digital certificate
- Deletes all tracked changes and comments
Correct answer: Marks the document as read-only to discourage further editing
'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.
Question 6: When recovering an unsaved Word document, where would you typically look first?
- The Windows Recycle Bin
- The AutoRecover file location set in Word Options (Correct answer)
- The Documents library default folder
- The OneDrive version history
Correct answer: The AutoRecover file location set in Word Options
Word stores AutoRecover files in a location specified in Word Options > Save, which is where unsaved documents can be recovered.
MCAS Managing Files & Data 2
In Microsoft Excel, which function would you use to count only the cells in a range that meet a specific condition?