Microsoft Excel Expert - Microsoft 365 Apps - MO-211 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Which function generates an array of random numbers?

A. SUMIF() B. RANDARRAY() C. CONCATENATE() D. IF()

Discussion 0

Correct Answer: B Vote an answer

Question 2

To manage workbook versions efficiently, enable ____.

A. Autosave B. Track Changes C. Version History D. Data Validation

Discussion 0

Correct Answer: C Vote an answer

Question 3

What function would you use to calculate a payment for a loan with constant payments and interest rates?

A. PV() B. PMT() C. NPER() D. RATE()

Discussion 0

Correct Answer: B Vote an answer

Question 4

How would you ensure that formulas referring to data in other workbooks update automatically as changes are made?

A. Save both workbooks as shared workbooks B. None of the above C. Set calculation to automatic in both workbooks D. Embed one workbook into another

Discussion 0

Correct Answer: C Vote an answer

Question 5

How do you use the SORTBY() function to sort data based on a secondary criterion?

A. SORTBY(array, by_array1, sort_order1, by_array2, sort_order2) B. SORT(array, sort_index, sort_order) C. SORTBY(array, sort_index, sort_order) D. SORT(array, by_array, sort_order)

Discussion 0

Correct Answer: A Vote an answer

Question 6

When would using the MATCH() function be more appropriate than using XLOOKUP()?

A. When you need to perform a horizontal lookup B. When you need to use a dynamic array formula C. When you need to find the relative position of an item in a range D. When you need to retrieve a value from a column or row

Discussion 0

Correct Answer: C Vote an answer

Question 7

What is the best use of the LET() function in Excel formulas?

A. To handle errors in calculations B. To define variables for use within the formula C. To automate tasks through macros D. To execute conditional logic

Discussion 0

Correct Answer: B Vote an answer

Question 8

Which chart type allows simultaneous display of different data types, like revenue vs. units sold?

A. Combo B. Pie C. Waterfall D. Scatter

Discussion 0

Correct Answer: A Vote an answer