UNH ADMN 410 MIS & EXCEL EXAM
|Questions Solved 100% Correct|
Verified Solutions
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
PEMDAS - ANSWER Parentheses, Exponents, Multiplication, Division,
Addition, Subtraction
|Questions Solved 100% Correct|
Verified Solutions
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
PEMDAS - ANSWER Parentheses, Exponents, Multiplication, Division,
Addition, Subtraction
