Data Analysis - Quiz 3
Authored by G_Sabado, Camille
Information Technology (IT)
University
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What-if analysis in Excel allows users to explore different outcomes by changing which elements?
Formulas themselves
Input variables
Formatting styles
Data ranges
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
In scenario analysis, what are independent variables?
Variables affected by the model
Variables derived from dependent values
Inputs determined outside the model
Random factors
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which of the following best describes a dependent variable?
An input to the model
A variable calculated from inputs
A constant in the formula
A fixed number
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
A company wants to test what their taxes would be if income changes — this is an example of:
Regression analysis
Scenario analysis
Forecasting
Goal seek
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Sensitivity analysis differs from scenario analysis because it:
Focuses on one specific scenario
Uses a range of input values
Is used only for dependent variables
Does not use Excel
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
In a sensitivity table, which type of variables are typically labeled on the axes?
Dependent variables
Independent variables
Random values
Constant parameters
7.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
When supply and demand are equal, the price shown in a sensitivity table represents:
A shortage
An equilibrium
A maximum value
A dependent variable error
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
