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
Days365
B
Lookup
C
NOW
D
Days360
2) Used for two column vectors
A
Lookup
B
XLookup
C
VLookup
D
Vlist
3) Used to compute interest rates, due dates/payment terms, and financial projections
A
Spreadsheets
B
Formulas
C
Advanced Functions
D
Functions
4) An IF statement is considered a_____________.
A
Conditional Formula
B
Operation
C
Number statement
D
Conditional Operator
5) An IF statement will render a result if_________.
A
the data set includes more than two columns.
B
equations include infinite numbers.
C
calculations include an array of cells.
D
the data specified meets conditions set by the formula.
6) An IF statement is__________.
A
calculated to include an array of cells.
B
used to calculate the difference between two cells.
C
an equation that includes infinite numbers.
D
written to carry out an action.
7) Used to calculate a period of time:
A
IF Statement
B
VLookup
C
NOW
D
Days360
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
IF Statements
B
Formulas
C
Functions
D
Advanced 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
Days360
B
IF
C
NOW
D
Lookup
11) Used in conditional and comparison equations
A
LookUp Functions
B
Advanced Functions
C
List Functions
D
Date 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
List
B
LookUp
C
NOW
D
VLookUp
14) There are two types of ______________ functions: Validated and Non-Validated.
A
count
B
date
C
list
D
advanced
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?