1. Which of
the following is a way to copy a sheet in a workbook?
(Select all
correct answers)
a. Home-> Cells-> Format-> Move or Copy
b. Right click the sheet and select Move or Copy
c. Save As-> Copy
Tip: Advanced Excel, page 15
2. When using the sort command on a column of Months, by default, the
column is sorted alphabetically, with April first.
a. True
b. False
Tip: Advanced Excel, page 16
3. Where is the Sort command that allows for custom sorting of months?
a. Home-> Sort & Filter-> Custom Sort
b. Data-> Sort & Filter-> Sort-> Custom List
c. Data-> Sort & Filter-> Months
Tip: Advanced Excel, page 18
4. Excel can make tables of data.
a. True
b. False
Tip: Advanced Excel, page 21
5. Which is
true about a Total Row in an Excel Table?
(Select all
correct answers.)
a. Created by checking Total Row on the Table Tools Ribbon
b. Includes a Summary box with a drop down list of options
c. Can only be used to calculate Sum
d. Can only be used on small tables
Tip: Advanced Excel, page 27, 28
6. Which are true about Conditional Formatting? (Select all correct
answers.)
a. Colors or icons are based on rules
b. Command is Home->Styles->Conditional Formatting
c. Includes option for creating custom rules
d. Can only have one rule applied
Tip: Advanced Excel, page 31-33
7. Which commands are on the Table Tools ribbon? (Select all correct
answers.)
a. Remove duplicates
b. Convert to Range
c. Insert Rows
Tip: Advanced Excel, page 44
8. The Filters can be used to select any cell(s) with Conditional Formatting
applied.
a. True
b. False
Tip: Advanced Excel, page 40
9. Which is a type of Conditional Formatting? (Select all correct
answers.)
a. Icon Sets
b. Color Scales
c. Data Bars
d. Fill & Text Colors
Tip: Advanced Excel, page 31
10. An Excel Table has a library of Table Styles.
a. True
b. False
Tip: Advanced Excel, page 24
