Free Microsoft MO-211 Exam Dumps Questions & Answers

To create a PivotChart based on a PivotTable, go to ____ > PivotChart.

• A.PivotTable Tools > Analyze
• B.Data > Consolidate
• C.View > Charts
• D.Home > Charts

To find the sum of values based on multiple conditions, which function is most appropriate?

• A.SUMIF()
• B.COUNTIF()
• C.AVERAGEIF()
• D.SUMIFS()

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

• A.=A1>100
• B.None of the above
• C.>100
• D.=">100"

What is the best use of the LET() function in Excel formulas?

• A.To execute conditional logic
• B.To automate tasks through macros
• C.To handle errors in calculations
• D.To define variables for use within the formula

How can data from another workbook be referenced in Excel formulas?

• A.Use the LINK function
• B.Use the INDIRECT function
• C.Use the IMPORT function
• D.Use external reference syntax