Test Yourself

 

 

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 makes 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 Find command can be used to find 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 gallery of Table Styles.
a. True
b. False
Tip: Advanced Excel, page 24