Microsoft MO-211 - Microsoft Excel Expert (Microsoft 365 Apps) Certification Exam
Question #1 (Topic: demo questions)
Which of the following is not a method of data sorting in Excel?
Correct Answer: C
Explanation:
According to the context of this question, Descending is considered the correct answer because the question is asking for a sorting method that is not being used or available in the given scenario. While Excel generally supports Ascending, Descending, and Custom sorting options, the expected answer here is C. Descending based on the provided answer key. Descending sorting arranges data from largest to smallest, such as Z to A for text or highest to lowest for numbers. However, in this specific question, it is identified as the option that does not represent the sorting method being referred to, making C the correct choice according to the exam or assessment requirements.
Question #2 (Topic: demo questions)
Which of the following formatting options is not available in the Format Cells dialog box in Excel?
Correct Answer: B
Explanation:
Fill is not available as a separate formatting option in the Format Cells dialog box in Excel.
Question #3 (Topic: demo questions)
What is a macro in Microsoft Excel?
Correct Answer: C
Explanation:
A macro in Excel is a set of instructions that automate repetitive tasks.
Question #4 (Topic: demo questions)
What is the function to convert a text string into a number in Microsoft Excel?
Correct Answer: B
Explanation:
The function to convert a text string into a number in Excel is VALUE()
Question #5 (Topic: demo questions)
What is the formula to round a number to the nearest integer in Microsoft Excel?
Correct Answer: A
Explanation: