Upgrade
excel final exam
Terms in this set (121)
enables you to what if analysis
experiment with different
variables or
assumptions so you can
compare the related
outcomes
what is a benefit of using a range names are easier for people to
range name in excel? remember than cell references
the what if analysis tool is data
on the____tab
what tool would you name manager
use to rename a
named range?
which of these !
characters is not an
acceptable character to
use in a range name?
,if cell B5 contains the 18
value 6 and is named
Quantity and cell C6
contains the value 3 and is
named Unit_Price, what
would the formula
=Quantity*Unit_Price
display in D6?
where would you setup in the first row and first column in the table
the two substitution values
in a two variable data
table?
which of these would be checking scenarios with variable down
a good candidate for a payments
one variable data table
and payment function?
=$E$5
to set up this two variable
data table, what is in B9?
what are the row and B5 and B4
column input cells in this
table?
, given this worksheet, B2
which cell would you use
in the set cell: box in goal
seek to see how
expensive of a house you
can afford and keep your
mortgage payment at
$650?
if you set up a two 3.0%, 3.25%, 3.5%, 3.75%
variable data table to
calculate monthly
payments on different
interest rates and loan
terms, what values would
be a likely set of entries in
the left column of your
data table?
what tool would be two variable data table
most effective when
comparing the impact of
changes in interest rate
and purchase price on a
new car loan?
how many variables 1
does goal seek change
with each time it is
run?
what is a scenario in excel detailed set of values that represent different
what if analysis? possible situations
excel final exam
Terms in this set (121)
enables you to what if analysis
experiment with different
variables or
assumptions so you can
compare the related
outcomes
what is a benefit of using a range names are easier for people to
range name in excel? remember than cell references
the what if analysis tool is data
on the____tab
what tool would you name manager
use to rename a
named range?
which of these !
characters is not an
acceptable character to
use in a range name?
,if cell B5 contains the 18
value 6 and is named
Quantity and cell C6
contains the value 3 and is
named Unit_Price, what
would the formula
=Quantity*Unit_Price
display in D6?
where would you setup in the first row and first column in the table
the two substitution values
in a two variable data
table?
which of these would be checking scenarios with variable down
a good candidate for a payments
one variable data table
and payment function?
=$E$5
to set up this two variable
data table, what is in B9?
what are the row and B5 and B4
column input cells in this
table?
, given this worksheet, B2
which cell would you use
in the set cell: box in goal
seek to see how
expensive of a house you
can afford and keep your
mortgage payment at
$650?
if you set up a two 3.0%, 3.25%, 3.5%, 3.75%
variable data table to
calculate monthly
payments on different
interest rates and loan
terms, what values would
be a likely set of entries in
the left column of your
data table?
what tool would be two variable data table
most effective when
comparing the impact of
changes in interest rate
and purchase price on a
new car loan?
how many variables 1
does goal seek change
with each time it is
run?
what is a scenario in excel detailed set of values that represent different
what if analysis? possible situations
