UNH ADMN 410 MIS & EXCEL EXAM
|Questions Solved 100% Correct|
Verified Solutions
One-variable data table - ANSWER - a data analysis tool that provides various
results based on changing one variable
- suited in situations when you want to see how the final result changes when you
change one of the input variables
Two-variable data table - ANSWER - suited in situations when you want to see how the
final result changes when TWO of the input variables change simultaneously (as
against One Variable Data Table where only one of the input variables changes)
two-variable data table shows how various combinations of 2 sets of variable values
affect the formula result. In other words, it shows how changing two input values of
the same formula changes the output
goal seek - ANSWER A what-if analysis tool that finds the input needed in one cell
to arrive at the desired result in another cell.
feature starts with a desired result, then calculates the input value that will give
that result
*Find the right input of the value you want
charts - ANSWER allow you to illustrate your workbook data graphically, which makes
it easy to visualize comparisons and trends.
, conditional formatting - ANSWER easily spot trends and patterns in your data using
bars, colors, and icons to visually highlight important values
What-if analysis - ANSWER process of changing values in cells to see how those changes
affect the outcome of formulas in the worksheet
Data Validation - ANSWER pick from a list of rules to limit the type of data that can be
entered in a cell
EX: you can provide a list of values, like 1,2, and 3, or only allow numbers greater
than 1,000 as valid entries
Bar / column chart - ANSWER these charts are used to visually compare values across
a few categories
line chart - ANSWER used to show trends over time (years, months, days) or categories
pie chart - ANSWER used to show proportions of a whole. Use it when the total of
your numbers is 100%
relative cell reference - ANSWER Relative references change when a formula is copied to
another cell
(By default, all cell references are relative references)
absolute cell reference - ANSWER Absolute references, on the other hand,
remain constant no matter where they are copied.
EX: $A$2
|Questions Solved 100% Correct|
Verified Solutions
One-variable data table - ANSWER - a data analysis tool that provides various
results based on changing one variable
- suited in situations when you want to see how the final result changes when you
change one of the input variables
Two-variable data table - ANSWER - suited in situations when you want to see how the
final result changes when TWO of the input variables change simultaneously (as
against One Variable Data Table where only one of the input variables changes)
two-variable data table shows how various combinations of 2 sets of variable values
affect the formula result. In other words, it shows how changing two input values of
the same formula changes the output
goal seek - ANSWER A what-if analysis tool that finds the input needed in one cell
to arrive at the desired result in another cell.
feature starts with a desired result, then calculates the input value that will give
that result
*Find the right input of the value you want
charts - ANSWER allow you to illustrate your workbook data graphically, which makes
it easy to visualize comparisons and trends.
, conditional formatting - ANSWER easily spot trends and patterns in your data using
bars, colors, and icons to visually highlight important values
What-if analysis - ANSWER process of changing values in cells to see how those changes
affect the outcome of formulas in the worksheet
Data Validation - ANSWER pick from a list of rules to limit the type of data that can be
entered in a cell
EX: you can provide a list of values, like 1,2, and 3, or only allow numbers greater
than 1,000 as valid entries
Bar / column chart - ANSWER these charts are used to visually compare values across
a few categories
line chart - ANSWER used to show trends over time (years, months, days) or categories
pie chart - ANSWER used to show proportions of a whole. Use it when the total of
your numbers is 100%
relative cell reference - ANSWER Relative references change when a formula is copied to
another cell
(By default, all cell references are relative references)
absolute cell reference - ANSWER Absolute references, on the other hand,
remain constant no matter where they are copied.
EX: $A$2
