MO-211 実際試験問題と解答 - 模擬練習 - 受験自信を増やす

Question No : 1
Which of these is NOT a type of data validation in Excel?

正解:

Question No : 2
Which function is best suited for retrieving a value in a table based on a row and column position?

正解:

Question No : 3
Which of the following statements best describes the use of calculated fields in PivotTables?

正解:

Question No : 4
When might you need to enable macros in a workbook that you received via email?

正解:

Question No : 5
______ is used to dynamically filter rows in Excel based on a set of criteria.

正解:

Question No : 6
Managing multiple conditional formatting rules is done in the ______ dialog box.

正解:

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

正解:

Question No : 8
You need to protect certain worksheets and cell ranges in your workbook.
Which option would you use to achieve this?

正解:

Question No : 9
Which functions can be used to fill cells based on patterns or sequences in Excel? (Choose two)

正解:

Question No : 10
What is the main advantage of using a Box & Whisker chart in data analysis?

正解:

Question No : 11
Which actions can you perform using advanced Conditional Formatting rules? (Choose two)

正解:

Question No : 12
Which option allows you to restrict editing in certain parts of a workbook?

正解:

Question No : 13
Enter the format code: 0.00%

正解:

Question No : 14
Which of the following charts are useful for comparing multiple variables in a dataset? (Choose Two)

正解:

Question No : 15
Format the chart as needed

正解:

Microsoft MO-211 問題練習