Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Advanced Functions Of Spreadsheets
Test Description: OBJ 1.01
Instructions: Answer all questions to get your test result.
1) Calculates the difference in days between two dates
A
Days360
B
Days365
C
NOW
D
Lookup
2) Used for two column vectors
A
Lookup
B
Vlist
C
XLookup
D
VLookup
3) Used to compute interest rates, due dates/payment terms, and financial projections
A
Formulas
B
Advanced Functions
C
Functions
D
Spreadsheets
4) An IF statement is considered a_____________.
A
Operation
B
Conditional Formula
C
Conditional Operator
D
Number statement
5) An IF statement will render a result if_________.
A
equations include infinite numbers.
B
the data set includes more than two columns.
C
the data specified meets conditions set by the formula.
D
calculations include an array of cells.
6) An IF statement is__________.
A
used to calculate the difference between two cells.
B
calculated to include an array of cells.
C
an equation that includes infinite numbers.
D
written to carry out an action.
7) Used to calculate a period of time:
A
Days360
B
NOW
C
VLookup
D
IF Statement
8) Used to assist in organizing spreadsheet information
A
IF
B
List
C
NOW
D
Advanced Function Data
9) Used in higher-level operations
A
Advanced Functions
B
Functions
C
Formulas
D
IF Statements
10) Used to compare a cell value to an array of cells and return a value that matches the location of the value in the array
A
Lookup
B
Days360
C
IF
D
NOW
11) Used in conditional and comparison equations
A
List Functions
B
Advanced Functions
C
Date Functions
D
LookUp Functions
12) Used when there are more than 2 columns in the array
A
Days360
B
NOW
C
Lookup
D
VLookup
13) Returns the current date:
A
NOW
B
LookUp
C
List
D
VLookUp
14) There are two types of ______________ functions: Validated and Non-Validated.
A
list
B
date
C
advanced
D
count
15) Limits data entry to specific choices programmed into the functions:
A
CountIF
B
Non-Validated
C
Count
D
Validated
*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-2024
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?