Advanced Functions Of Spreadsheets Question Preview (ID: 40917)


OBJ 1.01. TEACHERS: click here for quick copy question ID numbers.

Calculates the difference in days between two dates
a) Days360
b) NOW
c) Lookup
d) Days365

Used for two column vectors
a) VLookup
b) Lookup
c) Vlist
d) XLookup

Used to compute interest rates, due dates/payment terms, and financial projections
a) Functions
b) Advanced Functions
c) Formulas
d) Spreadsheets

An IF statement is considered a_____________.
a) Conditional Operator
b) Conditional Formula
c) Number statement
d) Operation

An IF statement will render a result if_________.
a) calculations include an array of cells.
b) equations include infinite numbers.
c) the data specified meets conditions set by the formula.
d) the data set includes more than two columns.

An IF statement is__________.
a) calculated to include an array of cells.
b) an equation that includes infinite numbers.
c) written to carry out an action.
d) used to calculate the difference between two cells.

Used to calculate a period of time:
a) NOW
b) Days360
c) IF Statement
d) VLookup

Used to assist in organizing spreadsheet information
a) NOW
b) Advanced Function Data
c) IF
d) List

Used in higher-level operations
a) Functions
b) IF Statements
c) Advanced Functions
d) Formulas

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) NOW
b) Days360
c) Lookup
d) IF

Used in conditional and comparison equations
a) Date Functions
b) LookUp Functions
c) Advanced Functions
d) List Functions

Used when there are more than 2 columns in the array
a) NOW
b) Days360
c) Lookup
d) VLookup

Returns the current date:
a) NOW
b) List
c) LookUp
d) VLookUp

There are two types of ______________ functions: Validated and Non-Validated.
a) advanced
b) date
c) list
d) count

Limits data entry to specific choices programmed into the functions:
a) Validated
b) Non-Validated
c) Count
d) CountIF

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 40917 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links