Microsoft Excel Expert 365 Apps (MO-211) Certification Sample Questions

Excel Expert 365 Apps Dumps, MO-211 Dumps, MO-211 PDF, Excel Expert 365 Apps VCE, Microsoft MO-211 VCE, Microsoft MOS Excel Expert (Microsoft 365 Apps) PDF The purpose of this Sample Question Set is to provide you with information about the Microsoft Excel Expert - Microsoft 365 Apps exam. These sample questions will make you very familiar with both the type and the difficulty level of the questions on the MO-211 certification test. To get familiar with real exam environment, we suggest you try our Sample Microsoft Excel Expert 365 Apps Certification Practice Exam. This sample practice exam gives you the feeling of reality and is a clue to the questions asked in the actual Microsoft Office Specialist - Excel Expert (Microsoft 365 Apps) certification exam.

These sample questions are simple and basic questions that represent likeness to the real Microsoft MO-211 exam questions. To assess your readiness and performance with real time scenario based questions, we suggest you prepare with our Premium Microsoft Excel Expert 365 Apps Certification Practice Exam. When you solve real time scenario based questions practically, you come across many difficulties that give you an opportunity to improve.

Microsoft MO-211 Sample Questions:

01. A loan sheet holds the annual interest rate in B2, the term in years in B3 and the amount borrowed in B4, and the monthly payment in B5 is =PMT(B2/12,B3*12,-B4). A client has said that 1,500 a month is the most they can pay, and wants to know the largest amount they could borrow at the rate and term already in the sheet.

What should the adviser do?

a) Create three scenarios in Scenario Manager, one for each candidate loan amount, and compare their payments.

b) Build a one-variable data table down a column of candidate loan amounts, with B5 as the result formula.

c) Run Goal Seek on B5, setting it to 1500 by changing B4, and read the amount it writes back.

d) Run Trace Precedents on B5 to see which input cells the payment depends on.

02. Column C of a compliance tracker holds due dates entered as dates with no time of day. A rule using =$C2<NOW() is meant to flag items whose due date has passed, but every item due today is being flagged as well.

Which formula flags only the items whose due date is earlier than today?

a) =DATE(YEAR($C2),MONTH($C2),DAY($C2))<NOW()

b) =$C2<TODAY()

c) =$C2<=TODAY()

d) =$C2<TODAY()-1

03. A PivotChart of monthly revenue by product line sits on a review sheet, and its colors and fonts have to match the rest of the pack. The workbook owner adds a product line to the source table every quarter or so, and each new line arrives in the chart as a further series.

What should the owner do so the chart keeps its agreed appearance as new lines appear?

a) Apply a chart style to the PivotChart.

b) Select each column series in turn and set its fill color and font by hand.

c) Format the chart, then save the workbook as a template.

d) Format the fill and font of the PivotTable cells the chart is built from.

04. A support workbook holds 1,200 call durations in one column, ranging from under a minute to just over an hour. The team lead wants to see how many calls fall into each duration band, and whether the calls bunch towards the short end with a long tail of slow ones.

Which chart answers that question?

a) A box & whisker chart of the durations

b) A histogram of the durations

c) A waterfall chart, with each call drawn as a movement in a running total of call time

d) A pie chart, with each call as a slice of total call time

05. Three regional worksheets — East, Central and West — each list product names down the first column and the same four cost headings across the top. The product lists overlap but are not identical and are in different orders. The owner needs one summary sheet showing each product's combined figures across the three regions, and the summary must pick up later corrections to the regional figures without being retyped.

What should the owner do?

a) Use Consolidate on the summary sheet, adding the three regional ranges, matching on the top row and left column labels, and linking to the source data.

b) Total each regional sheet separately and add the three sheet totals together on the summary sheet.

c) Copy the three regional ranges one beneath the other on the summary sheet, sort the block by product name, and insert subtotals at each change in product.

d) Enter =SUM(East:West!B2) on the summary sheet and fill it across and down the grid.

06. A grid holds month names across B1:M1, product codes down A2:A40, and unit sales in B2:M40. A lookup cell must return the units for the product code typed in P2, in the month named in Q2.

Which formula returns that value?

a) =INDEX(B2:M40,MATCH(P2,A2:A40,0))

b) =INDEX(B2:M40,MATCH(P2,A2:A40,0),MATCH(Q2,B1:M1,0))

c) =VLOOKUP(P2,A2:M40,MATCH(Q2,B1:M1,0),FALSE)

d) =INDEX(B2:M40,MATCH(Q2,B1:M1,0),MATCH(P2,A2:A40,0))

07. Several colleagues type into the Region column of a shared intake sheet. Only the four approved region names may be recorded, anything else must be refused as it is typed, and the people entering data have asked to pick from a list rather than type.

Which configuration meets all three requirements?

a) A conditional formatting rule that fills the cell red when the entry is not one of the four names.

b) Worksheet protection applied with the Region column left unlocked.

c) Data validation that allows a List, with =$H$2:$H$5 as the source.

d) Data validation with the custom formula =COUNTIF($H$2:$H$5,B2)>0.

08. A histogram of order values is grouping the data into bands that Excel chose for itself. The finance team needs bands of exactly 250 currency units.

Where do you make that change?

a) In the Select Data dialog, by editing the series values

b) In the Chart Styles gallery, by choosing a denser layout

c) In the source data, by sorting the order values

d) In the axis options, by setting the bin width to 250

09. A PivotTable summarizes order revenue by product and order date. Finance needs the report to show a margin percentage that does not exist in the source data, to be re-filtered by sales channel without opening the field list, and to subtotal the orders by quarter. The source table must not gain columns.

Which three actions should you perform?
Each correct answer presents part of the solution.

a) Repoint the PivotTable at an external data connection

b) Add a calculated field for margin percentage

c) Insert a slicer for the sales channel field

d) Apply data bars to the revenue values

e) Group the order date field by quarter

10. An accounts sheet holds account codes in A2:A200 and credit limits in D2:D200. The codes are unique but are in no particular order. Cell H2 must return the credit limit for the code typed in H1, and show Not found when that code is absent.

Which two formulas meet the requirement?
Each correct answer presents a complete solution.

a) =XLOOKUP(H1,A2:A200,D2:D200,"Not found")

b) =LOOKUP(H1,A2:A200,D2:D200)

c) =IFERROR(INDEX(D2:D200,MATCH(H1,A2:A200,0),1),"Not found")

d) =VLOOKUP(H1,A2:D200,4,FALSE)

Answers:

Question: 01 Answer: c	Question: 02 Answer: b	Question: 03 Answer: a	Question: 04 Answer: b	Question: 05 Answer: a
Question: 06 Answer: b	Question: 07 Answer: c	Question: 08 Answer: d	Question: 09 Answer: b, c, e	Question: 10 Answer: a, c

Note: For any error in Microsoft Office Specialist - Excel Expert (Microsoft 365 Apps) (MO-211) certification exam sample questions, please update us by writing an email on feedback@edusum.com.