- Study guides, Class notes & Summaries
Looking for the best study guides, study notes and summaries about ? On this page you'll find 4 study documents about .
4 results
Exam (elaborations)
Excel ch 9 End of Chapter Quiz Revised Questions and Answers Sure A+
An error that occurs when formula construction rules are violated - Syntax Error 
An electronic marker to another location in a worksheet, workbook, file, Web page, or email. - 
Hyperlink 
Rules that dictate the data to enter in a cell. - Validation criteria 
A logical function that checks a value and returns the result if possible or an error message. - 
IFERROR function
Exam (elaborations)
Excel ch 9 End of Chapter Quiz Revised Questions and Answers Sure A+
Popular3-D formula - A formula or function that refers to the same range in multiple worksheets 
Data validation - Requires that rules be followed in order to allow data to be entered in a cell 
Dependent cell - A cell containing a formula that is dependent on other cells to obtain its value 
Destination file - A file that contains a pointer to the source fi
Exam (elaborations)
Excel ch 9 End of Chapter Quiz Revised Questions and Answers Sure A+
Grouping - selecting two or more worksheets so you can perform the same action at the same 
time 
White - When worksheets are grouped: 
Worksheet tabs display a _______ background color 
Title - When worksheets are grouped: 
[Group] appears in the ______ bar
Exam (elaborations)
Excel ch 9 End of Chapter Quiz Revised Questions and Answers Sure A+
You have a workbook that contains sales data for different regional sales reps of a company. Which 
task is the least likely to be done while the worksheets are grouped? - Enter specific values for 
the first sales rep. 
Your manager sent you a workbook that contains data validation rules. One rule specifies a maximum 
value of 15% with a warning alert. You try to enter 22% in that cell. What happens? - Excel 
displays a message box informing you the value is above the maximum value and lets you...