EXCEL TEST QUESTIONS (ADVANCED
COMPUTER APPLICATION) WITH CORRECT
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
A _____ is an organized collection of data - Correct Answers -database
COMPUTER APPLICATION) WITH CORRECT
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
A _____ is an organized collection of data - Correct Answers -database
