Vocab 10
Vocab 11
Fill in the blank
100
A formula that results in a logical value, that is, true or false.
What is conditional formula
100
Text that must be entered before a user can access a workbook, or worksheet elements
What is password
100
hidden data personal information
You should always review the document for or information that might be stored in the workbook.
200
A number,text, or expression that tests which cells to sum, count, or average
What is criteria
200
Is set up to allow multiple users on a network to view and make changes at the same time
What is a shared workbook
200
To protect an , you can require password to open and view the workbook.
entire workbook
300
The values that a function uses to perform operations or calculations in a formula
What are arguments
300
Includes the name of the person who made each change, when it was made
What is change history
300
strong password
Select a password that you can remember so that you don't have to write it down
400
Efficient way to search for and insert a value in a cell when the desired value is stored
What are Lookup Functions
400
Ability to mark who makes what changes that have been made to a workbook
What are tracking changes
500
Refers to a range of cells in a worksheet that can be used by a lookup fuction
What is a table
500
Displays several different options that enable you to find hidden data and personal information.
What is document inspector
M
e
n
u