Simnet Chapter 8 Exam Guide With Complete Solutions

SIMNET CHAPTER 8 EXAM GUIDE WITH
COMPLETE SOLUTIONS



Creating New Conditional Formatting Rules - Correct Answers -1) Click the Conditional
Formatting button.
2) Select "New Rule"
3) Click the "Format Style" drop-down arrow.
4) Select "Icon Sets" OR Different Format

Managing Conditional Formatting Rules - Correct Answers -1) Click the Conditional
Formatting button.
2) Manage Rules
3) Click "Show Formatting Rules"
4) Select "This Worksheet"

Filtering and Sorting Using Cell Attributes - Correct Answers -1) On the Data tab, click
the Filter button.
2) Click the AutoFilter arrow at the top of the column. (dropdown arrow in the table)
3) Sort by color or filter by color (look at the rules asked)

Sorting Data on Multiple Criteria - Correct Answers -1) On the Data tab, click the Sort
button.
2) Click the Sort by Button
3) Sort by what is needed

Creating a Custom Filter - Correct Answers -1) On the Data tab, click the Filter button.
2) Click the AutoFilter arrow at the top of the Date column. (little dropdown)
3) Select option wanted and change settings

Using Advanced Filter - Correct Answers -1) Type necessities in the separate table -
Click the Data tab.
2) In the Sort Filter group, click the Advanced button.
3) Type the cell range . . . in the Criteria range box and press Enter to submit your
answer.

Adding Subtotals - Correct Answers -1) On the Data tab, in the Outline group, click the
Subtotal button.
2) In the Subtotal dialog, click the At each change in drop-down arrow.
3) Use the function drop down arrow
4) Select boxes needed