Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Project 5 B
Test Description: Working With Functions
Instructions: Answer all questions to get your test result.
1) Nested IF functions test for more than one condition by including additional IF formulas.
A
True
B
Sometimes
C
False
2) The function calculates the future value of an investment based on fixed payments earning a fixed rate of interest across equal time periods.
A
IF
B
PMT
C
PV
D
FV
3) To calculate the average of specified values use the _______________ function.
A
AVE
B
PMT
C
AVERAGE
D
SUM
4) ______________ functions test for more than one condition by including additional IF formulas.
A
NESTED IF
B
IF/THEN
C
NOW
D
MEDIAN
5) If the IF function calculates a bonus if true and zero if false, the zero would be the second argument.
A
False
B
Sometimes
C
True
6) If you do not want the date to update each time you open a workbook, just type the date ______________ using a function.
A
sometimes
B
by
C
by always
D
without
7) The function to count all cells in the specified range that are blank is
A
MEDIAN
B
COUNTBLANK
C
MODE
D
COUNTA
8) Variable data are not amounts that are subject to change.
A
False
B
True
9) The IF function requires that you specify three arguments in order: the value if true, the logical test, and the value if false.
A
True
B
False
10) When entering the NOW function, =NOW( ) will produce
A
just the current date
B
#NAME?
C
just the current time
D
the current date and time
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2023
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?