Register
Question 1
Which Excel function returns a dynamic array of unique values from a range, automatically spilling results into adjacent cells?
Correct Answer:
=UNIQUE
Question 2
A formula =FILTER(A2:C50,B2:B50>1000) returns the error #CALC!. What is the most likely cause?
Correct Answer:
No rows in B2:B50 satisfy the condition B>1000
Question 3
Which formula generates a sequential list of integers from 1 to 10 that spills automatically into cells below the formula cell?
Correct Answer:
=SEQUENCE(10)
Question 4
A user writes =LET(x,FILTER(A2:A100,B2:B100="East"),SUM(x)). What does this formula accomplish?
Correct Answer:
It filters column A for East rows, stores the result in a local variable x, then sums it
Question 5
Which formula correctly defines a LAMBDA function named DoubleIt that accepts one argument and returns twice its value, stored via the Name Manager?
Correct Answer:
=LAMBDA(x, x*2)
Question 1
Exam overview

About this Exam

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

More details

Additional Information

MO-211 Practice Questions - Microsoft Excel Expert (Microsoft 365 Apps) (MO-211) Exam

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

Check Point Certified Security Expert R80 (CCSE‑R80) Practice Exam

0 min

Cisco Certified Internetwork Expert (CCIE) Practice Test

0 min

Citrix Virtual Apps and Desktops 7 Administration 1Y0-204 Practice Exam

0 min

Automotive Service Excellence (ASE) Air Conditioner Certification Practice Exam

0 min

Automotive Service Excellence (ASE) Brakes Certification Practice Exam

0 min

Act as an expert educational copywriter and SEO specialist. I need a comprehensive, SEO-optimized study guide article for the following exam: [Insert Exact Exam Title Here] First, provide an optimized title: Create a short, punchy SEO title (under 60

0 min