1. Which of
the following is true?
(Select all
correct answers.)
a. Sort helps find patterns
b. Filter focuses on just part of the information
Tip: Advanced Excel page 51, 52
2. When the filter command is applied, the header row contains drop down
filter options.
a. True
b. False
Tip: Advanced Excel, page 53
3. The status bar displays how many filtered records there are.
a. True
b. False
Tip: Advanced Excel, page 54
4. The Group
command creates an outline in the side of the spreadsheet, but does NOT
calculate totals.
a. True
b. False
Tip: Advanced Excel, page 66
5. Which of
the following are true about Subtotals? (Select all correct answers.)
a. To use the subtotal, data must be sorted first
b. The command is Data-> Outline-> Subtotal
c. The subtotal function creates totals for each group in the column
Tip: Advanced Excel, page 58
6. In the Outline a + indicates what?
(Select all
correct answers.)
a. There is more data to see
b. All data is displayed
c. The outline can be expanded
d. The outline can be condensed
Tip: Advanced Excel, page 64
7. Which of the following are Outline functions? (Select all correct
answers.)
a. Subtotal
b. Group
c. Sort
Tip: Advanced Excel, page 66
8. Which of
the following is true about the Goal-Seek command?
(Select all
correct answers.)
a. OK keeps the changes
b. Cancel rejects (or undoes) the changes
c. Apply keeps the changes
Tip: Advanced Excel, page 70
9. To enter multiple values for a What-if scenario, which is the best
tool?
a. Goal-Seek
b. Scenario Manager
Tip: Advanced Excel, page 71
10. A What if Scenario can only change one (1) reference cell.
a. True
b. False
Tip: Advanced Excel, page 77
