Question 1
You want to bring data from a comma-separated text file into a new Excel worksheet. Which ribbon path starts this import in Excel 2019?
Correct Answer:
Data > Get Data (or From Text/CSV)
Question 2
Which keyboard shortcut opens the Go To dialog so you can jump to a specific cell or named range?
Correct Answer:
Ctrl+G
Question 3
You want a hyperlink in cell A1 that, when clicked, moves the user to the cell named 'Summary' elsewhere in the same workbook. Which option in the Insert Hyperlink dialog should you choose?
Correct Answer:
Place in This Document
Question 4
You want the top row of headings to stay visible while you scroll down a long list. Which command achieves this?
Correct Answer:
View > Freeze Panes > Freeze Top Row
Question 5
On the Page Layout tab you want a label to appear at the top of every printed page, such as the company name. Where do you add it?
Correct Answer:
Header & Footer (Insert tab) or Page Setup > Header/Footer
Question 1
Exam overview

About this Exam

Prepare with the MO-200 Practice Questions - Microsoft Office Specialist Excel Associate (Office 2019) - Exam MO-200 Exam practice quiz. This question bank includes 100 questions covering want, cell, data, cells, 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

MO-200 Practice Questions - Microsoft Office Specialist Excel Associate (Office 2019) - Exam MO-200 Exam

This practice set contains 100 questions from the matching question bank and focuses on want, cell, data, cells, 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