Microsoft MO-211 問題練習

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

• A.Date
• B.Formula
• C.List
• D.Color

答えを確認する

正解:

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

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

答えを確認する

正解:

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

• A.They are used to filter data.
• B.They allow for custom calculations within the PivotTable.
• C.They restrict data input to certain types.
• D.They automatically create new data connections.

答えを確認する

正解:

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

• A.If the workbook contains interactive content
• B.Only if the email is from a trusted source
• C.Always, to ensure full functionality
• D.Never, for security reasons

答えを確認する

正解:

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

• A.AutoFilter
• B.Advanced Filter
• C.Smart Filter
• D.Quick Filter

答えを確認する

正解:

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

• A.Formatting Rules Manager
• B.Manage Rules
• C.Rules Manager
• D.Conditional Formatting Rules Manager

答えを確認する

正解:

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

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

答えを確認する

正解:

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

• A.Protect Workbook
• B.Allow Edit Ranges
• C.Conditional Formatting
• D.Use Encryption

答えを確認する

正解:

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

• A.Flash Fill
• B.AutoFill
• C.Data Validation
• D.RANDARRAY()

答えを確認する

正解:

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

• A.It shows frequency distributions
• B.It displays hierarchical data
• C.It summarizes variation in large datasets
• D.It identifies changes over time

答えを確認する

正解:

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

• A.Apply rules based on formulas
• B.Highlight duplicates
• C.Restrict data entry
• D.Fill cells based on patterns

答えを確認する

正解:

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

• A.Protect Workbook
• B.Protect Sheet
• C.Data Validation
• D.Conditional Formatting

答えを確認する

正解:

Question No : 13
Enter the format code: 0.00%

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

答えを確認する

正解:

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

• A.Sunburst chart
• B.Dual-axis chart
• C.Funnel chart
• D.Pie chart

答えを確認する

正解:

Question No : 15
Format the chart as needed

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

答えを確認する

正解: