Excel Basics Wall
Street Prep Exam With
Latest Update
PV - ✔✔✔ANSWER-PV(rate, nper, pmt, fv, type) - Returns the present value of a
series of future payments
rate - interest rate per period
nper - total number of payment periods
pmt - payment made during each period (cannot be changed)
fv - future value
, type - indicates when a payments are due (0 or omitted = end of period; 1 =
beginning of period)
Real v nominal - ✔✔✔ANSWER-Real = adjusted for inflation
Nominal isnt
redo - ✔✔✔ANSWER-ctrl y
Remove All Borders - ✔✔✔ANSWER-Ctrl + Underscore
Round - ✔✔✔ANSWER-(number, number digits) round to the specified decimal
points
Absolute Value - ✔✔✔ANSWER-ABS(cell)
access anything on the ribbon - ✔✔✔ANSWER-atl
auto size cell - ✔✔✔ANSWER-alt h o i
Auto sum - ✔✔✔ANSWER-Alt =
bold - ✔✔✔ANSWER-ctrl b
Borders (Outside Area) - ✔✔✔ANSWER-Ctrl Shift 7
Street Prep Exam With
Latest Update
PV - ✔✔✔ANSWER-PV(rate, nper, pmt, fv, type) - Returns the present value of a
series of future payments
rate - interest rate per period
nper - total number of payment periods
pmt - payment made during each period (cannot be changed)
fv - future value
, type - indicates when a payments are due (0 or omitted = end of period; 1 =
beginning of period)
Real v nominal - ✔✔✔ANSWER-Real = adjusted for inflation
Nominal isnt
redo - ✔✔✔ANSWER-ctrl y
Remove All Borders - ✔✔✔ANSWER-Ctrl + Underscore
Round - ✔✔✔ANSWER-(number, number digits) round to the specified decimal
points
Absolute Value - ✔✔✔ANSWER-ABS(cell)
access anything on the ribbon - ✔✔✔ANSWER-atl
auto size cell - ✔✔✔ANSWER-alt h o i
Auto sum - ✔✔✔ANSWER-Alt =
bold - ✔✔✔ANSWER-ctrl b
Borders (Outside Area) - ✔✔✔ANSWER-Ctrl Shift 7
