MO-211 무료 덤프문제 온라인 액세스

Which function would you use to perform a lookup for data that matches multiple criteria?

• A.XLOOKUP()
• B.SUMIFS()
• C.VLOOKUP()
• D.INDEX()

Which functions would you use to perform a what-if analysis?
(Choose Two)

• A.Solver
• B.Data Table
• C.Goal Seek
• D.Scenario Manager

Which Excel feature would you use to sort a range of data based on another range?

• A.SORTBY()
• B.RANK()
• C.ORDERBY()
• D.SORT()

Arrange the steps to create a custom number format that displays percentages with two decimal places.
1. Select the cells to format
2. Right-click and select "Format Cells"
3. Choose "Custom" under Number formats
4. Enter the format code: 0.00%

• A.4, 1, 2, 3
• B.3, 4, 1, 2
• C.2, 3, 4, 1
• D.1, 2, 3, 4

Which of the following is NOT a valid use for conditional formatting?

• A.Change cell color based on cell values
• B.Hide rows that do not meet certain criteria
• C.Highlight duplicates
• D.Format cells that are above average