Register
Question 1
Which file extension should you use to save an Excel 2019 workbook so it can serve as a starting point for new workbooks but cannot be overwritten by saving?
Correct Answer:
.xltx
Question 2
In Excel 2019, where do you set workbook calculation to manual so that formulas only recalculate when you press F9?
Correct Answer:
File > Options > Formulas > Calculation options
Question 3
You want to prevent users from inserting, deleting, or renaming sheets in a shared workbook while still allowing data entry. Which command should you use?
Correct Answer:
Review > Protect Workbook (Structure)
Question 4
A workbook references data in another workbook. The source workbook is closed. How will Excel display the linked values when the destination workbook is opened?
Correct Answer:
Excel shows the last cached value and prompts to update links
Question 5
Which feature scans a workbook for hidden properties such as comments, document properties, headers/footers, and hidden rows before sharing?
Correct Answer:
Inspect Document
Question 1
Exam overview

About this Exam

Prepare with the MOS Excel Expert (Office 2019) Practice Questions - Microsoft Office Specialist Excel Expert (Office 2019) - MO-201 Exam practice quiz. This question bank includes 100 questions covering excel, workbook, formula, value, and column. Use it to review important concepts, identify knowledge gaps, and build confidence for the related exam, course, or assessment.

More details

Additional Information

MOS Excel Expert (Office 2019) Practice Questions - Microsoft Office Specialist Excel Expert (Office 2019) - MO-201 Exam

This practice set contains 100 questions from the matching question bank and focuses on excel, workbook, formula, value, and column. Work through each question carefully, review the provided solutions, and revisit topics that need more study before your next attempt.

This is an independent study resource intended for practice and review; it is not an official examination or an endorsement by any organization named in the title.

Quiz information

Frequently Asked Questions

The complete question count is available after full access is unlocked.
No fixed duration is currently configured for this quiz.
Question explanations are included where they are available in the quiz content, helping you review the reasoning after answering.
Yes. You can retake the practice test again as you continue studying during your available access period.
After your access is confirmed, you can continue into the complete practice exam from this quiz flow.
Unless explicitly stated otherwise, this page provides independent practice material for study and exam preparation and is not the official examination itself.
Keep studying

Related Questions

809 Field Training Officer Practice Exam

0 min

Certified Specialist Business Intelligence (CSBI) Practice Test

0 min

Certified Specialist In Renal Nutrition (CSR) Practice Exam

0 min

Certified Specialist Physician Practice Management (CSPPM) Practice Exam

0 min

Certified Specialist in Geriatric Nutrition Practice Exam

0 min

Certified Specialist in Gerontological Nutrition Practice Exam

0 min