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
Lookup
B
Days360
C
Days365
D
NOW
2) Used for two column vectors
A
Lookup
B
XLookup
C
Vlist
D
VLookup
3) Used to compute interest rates, due dates/payment terms, and financial projections
A
Functions
B
Formulas
C
Advanced Functions
D
Spreadsheets
4) An IF statement is considered a_____________.
A
Number statement
B
Operation
C
Conditional Formula
D
Conditional Operator
5) An IF statement will render a result if_________.
A
the data specified meets conditions set by the formula.
B
the data set includes more than two columns.
C
calculations include an array of cells.
D
equations include infinite numbers.
6) An IF statement is__________.
A
used to calculate the difference between two cells.
B
an equation that includes infinite numbers.
C
written to carry out an action.
D
calculated to include an array of cells.
7) Used to calculate a period of time:
A
VLookup
B
IF Statement
C
NOW
D
Days360
8) Used to assist in organizing spreadsheet information
A
List
B
NOW
C
Advanced Function Data
D
IF
9) Used in higher-level operations
A
IF Statements
B
Advanced Functions
C
Formulas
D
Functions
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
IF
B
NOW
C
Lookup
D
Days360
11) Used in conditional and comparison equations
A
Advanced Functions
B
List Functions
C
LookUp Functions
D
Date Functions
12) Used when there are more than 2 columns in the array
A
NOW
B
VLookup
C
Lookup
D
Days360
13) Returns the current date:
A
List
B
LookUp
C
NOW
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
Non-Validated
B
Count
C
Validated
D
CountIF
*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?