Excel ch 9 - Study guides, Class notes & Summaries

Looking for the best study guides, study notes and summaries about Excel ch 9? On this page you'll find 4 study documents about Excel ch 9.

4 results

Excel ch 9 End of Chapter Quiz Revised Questions and Answers Sure A+

Exam (elaborations)

Excel ch 9 End of Chapter Quiz Revised Questions and Answers Sure A+

Excel ch 9
Excel ch 9

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

-
3 pages
Written in 2023/2024
Grade A+
Lucindajohns
$8.49
- sold
Excel ch 9 End of Chapter Quiz Revised Questions and Answers Sure A+

Exam (elaborations)

Excel ch 9 End of Chapter Quiz Revised Questions and Answers Sure A+

Popular
Excel ch 9
Excel ch 9

3-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

-
2 pages
Written in 2023/2024
Grade A+
Lucindajohns
$8.49
- sold
Excel ch 9 End of Chapter Quiz Revised Questions and Answers Sure A+

Exam (elaborations)

Excel ch 9 End of Chapter Quiz Revised Questions and Answers Sure A+

Excel ch 9
Excel ch 9

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

-
5 pages
Written in 2023/2024
Grade A+
Lucindajohns
$8.49
- sold
Excel ch 9 End of Chapter Quiz Revised Questions and Answers Sure A+

Exam (elaborations)

Excel ch 9 End of Chapter Quiz Revised Questions and Answers Sure A+

Excel ch 9
Excel ch 9

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...

-
2 pages
Written in 2023/2024
Grade A+
Lucindajohns
$8.49
- sold
And that's how you make extra money
Did you know that on average a seller on Stuvia earns $82 per month selling study resources? Hmm, hint, hint.