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) PDFThe 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:

The analyst selects the On-Time Rate cells of the Riders table and creates an icon set rule with green, amber and red icons, keeping the default greater-than-or-equal-to comparison for both thresholds.
Which threshold settings meet the requirement?
a) Set both threshold types to Number, with values of 0.95 for green and 0.9 for amber
b) Set both threshold types to Number, with values of 95 for green and 90 for amber
c) Set both threshold types to Percentile, with values of 95 for green and 90 for amber
d) Set both threshold types to Percent, with values of 95 for green and 90 for amber
 
02. 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) =VLOOKUP(H1,A2:D200,4,FALSE)
b) =XLOOKUP(H1,A2:A200,D2:D200,"Not found")
c) =LOOKUP(H1,A2:A200,D2:D200)
d) =IFERROR(INDEX(D2:D200,MATCH(H1,A2:A200,0),1),"Not found")
 
The coordinator selects every data row of the Bookings table, with A2 as the active cell, and creates a conditional formatting rule that uses a formula to determine which cells to format.
Which rule formula meets the requirement for repeated bookings?
a) =COUNTIFS($B:$B,$B2,$D:$D,$D2)>1
b) =COUNTIFS($B:$B,$B2,$D:$D,$D2,$E:$E,$E2)>=1
c) =COUNTIFS($B:$B,$B2,$D:$D,$D2,$E:$E,$E2)>1
d) =COUNTIFS($B:$B,B2,$D:$D,D2,$E:$E,E2)>1
 
For the Balance column, the director asks that outstanding balances keep the thousands separator and two decimal places, credit balances appear in parentheses, and settled leases show a single dash. Each cell must keep the number it stores today.
Which custom number format should be applied to the Balance cells?
a) #,##0.00;"-";(#,##0.00)
b) #,##0.00;(#,##0.00);"-"
c) #,##0.00;-#,##0.00;"-"
d) #,##0.00;(#,##0.00);0;"-"
 
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) Enter =SUM(East:West!B2) on the summary sheet and fill it across and down the grid.
b) 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.
c) Total each regional sheet separately and add the three sheet totals together on the summary sheet.
d) 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.
 
06. 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) Insert a slicer for the sales channel field
b) Add a calculated field for margin percentage
c) Group the order date field by quarter
d) Apply data bars to the revenue values
e) Repoint the PivotTable at an external data connection
 
The contracts team is preparing the next release of the workbook and wants to deal with both incidents from this quarter while leaving the coordinators able to quote.
Which two actions should the team perform? Each correct answer presents part of the solution.
a) Protect the Inputs sheet with a password, leaving every cell's Locked setting as it is
b) Apply data validation to B5 that allows only decimal values greater than zero
c) Mark the workbook as final before it is shared with the coordinators
d) Clear the Locked setting on B2:B4, then protect the Inputs sheet with a password
e) Protect the workbook structure with a password known only to the contracts team
 
08. A budget workbook is kept in the team's SharePoint library. On Thursday the manager asks for the workbook as it stood on Monday, and is uneasy about the request because two days of work have gone into the file since then.
What becomes of those two days of work if Monday's version is restored?
a) They stay in the version history, because the restore adds Monday's content as a new current version.
b) They are discarded, because restoring rewrites the file and clears everything recorded after that point.
c) They survive only if someone saves a separate copy of the workbook before the restore is carried out.
d) They are merged into Monday's version, because a restore reconciles the two states cell by cell.
 
09. 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) Data validation with the custom formula =COUNTIF($H$2:$H$5,B2)>0.
c) Worksheet protection applied with the Region column left unlocked.
d) Data validation that allows a List, with =$H$2:$H$5 as the source.
 
A team member selects A2:I240 on the Leases sheet, with A2 as the active cell, and creates a new conditional formatting rule that uses a formula to determine which cells to format. Maturity dates are in column F.
Which rule formula meets the highlighting requirement for maturing leases?
a) =AND(F2>=TODAY(),F2<=TODAY()+90)
b) =AND($F$2>=TODAY(),$F$2<=TODAY()+90)
c) =AND($F2>=TODAY(),$F2<=TODAY()+90)
d) =OR($F2>=TODAY(),$F2<=TODAY()+90)

Answers:

Question: 01
Answer: a
Question: 02
Answer: b, d
Question: 03
Answer: c
Question: 04
Answer: b
Question: 05
Answer: d
Question: 06
Answer: a, b, c
Question: 07
Answer: d, e
Question: 08
Answer: a
Question: 09
Answer: d
Question: 10
Answer: 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.

Rating: 4.8 / 5 (80 votes)