Excel 2013 Lessons 10 And 11 Vocab Question Preview (ID: 37800)


Excel 2013 Lessons 10 And 11 Vocab. TEACHERS: click here for quick copy question ID numbers.

The parameters of a function.
a) arguments
b) conditional formula
c) criteria
d) lookup functions

A formula in which the result is determined by the presence or absence of a particular condition.
a) arguments
b) conditional formula
c) criteria
d) lookup function

A condition you specify to limit which records are returned when filtering data.
a) arguments
b) conditional formula
c) lookup function
d) criteria

An efficient way to search for and insert a value in a cell when the desired value is stored elsewhere in the worksheet or even in a different workbook.
a) criteria
b) lookup function
c) arguments
d) conditional formula

A range of cells in a worksheet that contains related data and can be used by a lookup function.
a) table array
b) criteria
c) table
d) lookup functions

Data in a table arranged in rows and columns.
a) table array
b) lookup functions
c) criteria
d) table

In a shared workbook, a feature that includes the name of the person who made each change, when the change was made, and what data was changed.
a) track changes
b) password
c) shared workbook
d) change history

Text that must be entered before a user can access a secured workbook, worksheet, or worksheet elements.
a) change history
b) password
c) shared workbook
d) strong password

A workbook set up to allow multiple networked users to view and make changes simultaneously.
a) track changes
b) shared workbook
c) track changes
d) change history

A password that combines uppercase and lowercase letters, numbers, and symbols making the password difficult to guess.
a) track changes
b) change history
c) password
d) strong password

A feature that marks and records changes made to a workbook.
a) strong password
b) password
c) shared workbook
d) track changes

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: 37800 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register