Question 1
Which keyboard shortcut inserts the current date as a static value in a cell?
Correct Answer:
Ctrl+;
Question 2
Which Excel function returns the number of cells in a range that meet a single condition?
Correct Answer:
=COUNTIF
Question 3
A user wants to prevent rows 1 and 2 from scrolling out of view while working in a large worksheet. What is the correct action?
Correct Answer:
Select row 3, then use View > Freeze Panes > Freeze Panes
Question 4
Which formula correctly sums all values in column B where the corresponding cell in column A equals "East"?
Correct Answer:
=SUMIF(A:A,"East",B:B)
Question 5
When a formula returns the error #VALUE!, what is the most likely cause?
Correct Answer:
The formula references a cell containing text where a number is expected
Question 1
Exam overview

About this Exam

Prepare with the MO-210 Practice Questions - Microsoft Excel (Microsoft 365 Apps) (MO-210) Exam practice quiz. This question bank includes 100 questions covering excel, column, function, formula, and cells. Use it to review important concepts, identify knowledge gaps, and build confidence for the related exam, course, or assessment.

More details

Additional Information

MO-210 Practice Questions - Microsoft Excel (Microsoft 365 Apps) (MO-210) Exam

This practice set contains 100 questions from the matching question bank and focuses on excel, column, function, formula, and cells. 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