Excel Test Questions (Advanced Computer
|\ |\ |\ |\ |\
Application) Multiple Choice Questions with |\ |\ |\ |\ |\
answers
You use a(n)_____ to automate datea analyses and organize the
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
answers returned by Excel |\ |\ |\
A. Cell|\
B. data table
|\ |\
C. Formula
|\
d. Annuity - CORRECT ANSWERS ✔✔B. Data table
|\ |\ |\ |\ |\ |\ |\
_____ Formatting is when you assign a format to all the cells in all
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
the worksheets in a workbook.
|\ |\ |\ |\
A Class inheritance
|\ |\
b. Absolute
|\
c. Global
|\
D. Frontline - CORRECT ANSWERS ✔✔C. Global
|\ |\ |\ |\ |\ |\
The can help add clarity to your formulas by allowing you to assign
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
names to cells. - CORRECT ANSWERS ✔✔Name Manager
|\ |\ |\ |\ |\ |\ |\
, Which of the following will display when you enter .5 in a cell that
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
is formatted a percent? - CORRECT ANSWERS ✔✔50%
|\ |\ |\ |\ |\ |\ |\
The ____ function returns the present value of an investment -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔PV |\ |\
A(n) ____ data table allows you to vary the values in two cells. -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔two-input |\ |\
_____ cell references are cells with a dollar sign - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔Absolute |\
The _____ Print option indicates how errors in cells should be
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
displayed on a printout. - CORRECT ANSWERS ✔✔'Cell errors as'
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
box
____ cells are cells whose values you can change at any time -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔Unprotected |\ |\
You can create a _____ when you want to keep other from changing
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
your worksheet - CORRECT ANSWERS ✔✔password
|\ |\ |\ |\ |\ |\
|\ |\ |\ |\ |\
Application) Multiple Choice Questions with |\ |\ |\ |\ |\
answers
You use a(n)_____ to automate datea analyses and organize the
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
answers returned by Excel |\ |\ |\
A. Cell|\
B. data table
|\ |\
C. Formula
|\
d. Annuity - CORRECT ANSWERS ✔✔B. Data table
|\ |\ |\ |\ |\ |\ |\
_____ Formatting is when you assign a format to all the cells in all
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
the worksheets in a workbook.
|\ |\ |\ |\
A Class inheritance
|\ |\
b. Absolute
|\
c. Global
|\
D. Frontline - CORRECT ANSWERS ✔✔C. Global
|\ |\ |\ |\ |\ |\
The can help add clarity to your formulas by allowing you to assign
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
names to cells. - CORRECT ANSWERS ✔✔Name Manager
|\ |\ |\ |\ |\ |\ |\
, Which of the following will display when you enter .5 in a cell that
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
is formatted a percent? - CORRECT ANSWERS ✔✔50%
|\ |\ |\ |\ |\ |\ |\
The ____ function returns the present value of an investment -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔PV |\ |\
A(n) ____ data table allows you to vary the values in two cells. -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔two-input |\ |\
_____ cell references are cells with a dollar sign - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔Absolute |\
The _____ Print option indicates how errors in cells should be
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
displayed on a printout. - CORRECT ANSWERS ✔✔'Cell errors as'
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
box
____ cells are cells whose values you can change at any time -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔Unprotected |\ |\
You can create a _____ when you want to keep other from changing
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
your worksheet - CORRECT ANSWERS ✔✔password
|\ |\ |\ |\ |\ |\
