[2026年09月]更新のMicrosoft MO-211試験基本問題には解答が付きます [Q21-Q41]

21、Which functions would you combine to create a complex logical test?
(Choose Three)

22、What function does Flash Fill perform in Excel?

23、How do you adjust a PivotChart to show data comparisons and trends over time?

24、Which option would you use to fill in weekdays skipping weekends in a date series?

25、You need to create a chart that shows how sales figures change over time and how each product category contributes to the overall total. Which chart type should you choose?

26、______ allows you to filter data in a range that meets certain criteria.

27、What does configuring formula calculation options allow you to manage?

28、What is the primary benefit of using the IFS() function over multiple IF() statements?

29、To manage workbook versions efficiently, enable ____.

30、What is the first step to copy a macro from one workbook to another?

31、When would it be appropriate to use a Combo chart?

32、How can you quickly calculate the total for a column of numbers?

33、Which tool in Excel is used to quickly remove all duplicate records from a dataset?

34、Which of these is NOT a type of data validation in Excel?

35、Which of the following charts are useful for comparing multiple variables in a dataset?
(Choose Two)

36、What does protecting worksheet and cell ranges NOT prevent?

37、To create a rule that formats cells red if they contain numbers greater than 100, which formula would you use in conditional formatting?

38、Which chart type would be most appropriate for showing how data values contribute to the overall total?

39、Which of these would you use to apply a gradient color scale based on values in a range?

40、Which steps are required to copy macros between workbooks?
(Choose two)

41、Which function should you use to ensure that a date falls on a weekday, not a weekend, when performing date arithmetic?