Microsoft Excel (MO-210) Exam

Question 1

What key combination on the keyboard locks cell references in a formula?

CTRL ALT F2 F4

Correct Answer:

Question 2

What are the AutoSum shortcut keys?

ALT and S CTRL and S CTRL and = ALT and =

Correct Answer:

ALT and =

Question 3

Which of the following represents the weighted average score calculation algorithm for cell C8 as shown below?

=SUMPRODUCT(C2:C4,B2:B4) =SUMPRODUCT(C2:C5,B2:B5) =AVERAGE(C2:C4) =AVERAGE(B2:B4)

Correct Answer:

=SUMPRODUCT(C2:C4,B2:B4)

Question 4

As indicated in column E2, Company A is considering four possible projects and will approve them if the IRR is 10% or above. What is the formula in cell C2 that produces the outcomes displayed below and can be duplicated down to cells C3 through C5?

=IF(B2>=E$2,"Accept","Reject") =IF(B2>=$E$2,"Accept","Reject") =IF(B2>=$E2,"Accept","Reject") =IF(B2>=E2,"Accept","Reject")

Correct Answer:

=IF(B2>=$E$2,"Accept","Reject")

Question 5

What are the short cuts in an Excel spreadsheet to add a new row?

ALT + H + I + C ALT + H + I + S ALT + H + I + R ALT + H + I + I

Correct Answer:

ALT + H + I + R

Question 1

Exam overview

About this Exam

Prepare with the Microsoft Excel (MO-210) Exam practice quiz. This question bank includes 23 questions covering cell, formula, excel, keyboard, and shortcut. Use it to review important concepts, identify knowledge gaps, and build confidence for the related exam, course, or assessment.

More details

Additional Information

Microsoft Excel (MO-210) Exam

This practice set contains 23 questions from the matching question bank and focuses on cell, formula, excel, keyboard, and shortcut. 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 Excel (MO-210) Exam

Frequently Asked Questions

Related Questions

Automotive Service Excellence (ASE) Air Conditioner Certification Practice Exam

Automotive Service Excellence (ASE) Brakes Certification Practice Exam

Career Essentials in Generative AI by Microsoft and LinkedIn Practice Test

Certified Manager of Quality/Organizational Excellence (CMQ/OE) Practice Exam

HVAC Excellence Electric Heat ESCO Practice Exam

HVAC Excellence Electrical Certification Practice Exam