Microsoft Office Specialist (MOS) Exam

Question 1

What steps would you follow if you were to copy the data from the first cell down a whole column, ending at the last row of data in the spreadsheet?

Double-click the Fill Handle after selecting the cell to copy. To copy a cell, double-click it, hold down the Shift key, then click the Fill Handle. To copy a cell, click it, then hold down the Control key and click the Fill Handle. After selecting a cell, double-click it to make a copy of it.

Correct Answer:

Double-click the Fill Handle after selecting the cell to copy.

Question 2

Which group of commands and ribbon menu will the Find & Select tool be located under?

Data > Editing Home > Editing Insert > Editing Home > Sorting

Correct Answer:

Home > Editing

Question 3

Which field or box would you enter "California" into if you wished to replace out "Boulder" with "Anaheim"?

Replace With: Replace All: Find What: Find Next:

Correct Answer:

Replace With:

Question 4

A dialogue box will open after you've finished a Find and Replace. What information is it providing?

Click OK to start the process. Click OK to complete the process. It will provide the number of instances found. It will provide the number of replacements made.

Correct Answer:

It will provide the number of replacements made.

Question 5

What would you click under Find and Replace if you wanted to search the whole workbook for all instances of the text "California" and replace it with "Anaheim"?

Options > Match case Options > Within > Workbook Options > Search > By rows Options > Look in > Formulas

Correct Answer:

Options > Within > Workbook

Question 1

Exam overview

About this Exam

Prepare with the Microsoft Office Specialist (MOS) Exam practice quiz. This question bank includes 34 questions covering access, data, text, page, and task. Use it to review important concepts, identify knowledge gaps, and build confidence for the related exam, course, or assessment.

More details

Additional Information

Microsoft Office Specialist (MOS) Exam

This practice set contains 34 questions from the matching question bank and focuses on access, data, text, page, and task. 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

Correct Answer:

Correct Answer:

Correct Answer:

Correct Answer:

Correct Answer:

About this Exam

Additional Information

Microsoft Office Specialist (MOS) Exam

Frequently Asked Questions

Related Questions

809 Field Training Officer Practice Exam

Certified Specialist Business Intelligence (CSBI) Practice Test

Certified Specialist In Renal Nutrition (CSR) Practice Exam

Certified Specialist Physician Practice Management (CSPPM) Practice Exam

Certified Specialist in Geriatric Nutrition Practice Exam

Certified Specialist in Gerontological Nutrition Practice Exam