12
QuizMultiple Choice

Analyzing Data — Unit test

Question 12 • TX-Business Information Management (BIM) I

Which phrase best describes a scenario in Excel 2016?

Answer
A
a type of what-if analysis that allows a user to define a single variable for a single function or formula
B
a type of what-if analysis that allows a user to define multiple variables for multiple functions or formulas
C
a type of chart analysis that allows a user to predict outcomes using data
D
a type of chart analysis that allows a user to set predetermined outcomes using data

Explanation

In Excel 2016, a scenario is a what-if analysis tool that stores different sets of values for multiple input cells. You can compare how those values affect one or more formulas, so the best description is “a type of what-if analysis that allows a user to define multiple variables for multiple functions or formulas.”

AI-written and checked against the verified answer.