Free Microsoft MO-211 Exam Dumps Questions & Answers

Which lookup functions can be used to find data horizontally and vertically in a table?
(Choose two)

• A.  VLOOKUP()
• B.  XLOOKUP()
• C.  SUMIF()
• D.  HLOOKUP()

What feature should be used to summarize data from multiple ranges that do not necessarily have to be adjacent to each other?

• A.  Consolidate
• B.  Data Table
• C.  PivotTable
• D.  Group

What option enables you to reference data in another workbook?

• A.  INDIRECT
• B.  External Reference Syntax
• C.  IMPORT
• D.  CONCATENATE

Which formulas can be used to look up data in Excel?
(Choose two)

• A.  MATCH()
• B.  LET()
• C.  INDEX()
• D.  SUMIFS()

What function does Flash Fill perform in Excel?

• A.  Automatically fills in values based on patterns it detects in the data
• B.  Fills cells with random numbers
• C.  Creates a sequence of dates
• D.  Sorts data automatically