Advanced Functions Of Spreadsheets Question Preview (ID: 40917)


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

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

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

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 to assist in organizing spreadsheet information
a) NOW
b) Advanced Function Data
c) IF
d) List

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

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.

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 considered a_____________.
a) Conditional Operator
b) Conditional Formula
c) Number statement
d) Operation

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

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

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