4. Which
task can be completed in the Name Manager? (Select all correct answers.)

a. Create a new named Range

b. Edit an existing named Range

c. Delete a defined Range

Tip: Intermediate Excel, page 94

5. Which of the following is true?

(Select all
correct answers.)

a. SUMIF adds values based on only one criteria

b. SUMIFS adds values based on only one criteria

c. SUMIF adds values based on more than one criteria

d. SUMIFS adds values based on more than one criteria

Tip: Intermediate Excel, page 98

6. Which is true about auditing a formula?

(Select all
correct answers)

a. Double-clicking the cell is a shortcut to display the formula

b. The formula will be color coded with colored outlines around the
cells matching colored cell names or Ranges in the formula

c. The command is Formula-> Formula Auditing> Trace Precedents

Tip: Intermediate Excel, page 105, 106

###
Lesson 3:Name That Tune

Before You Begin: Download the sample file:
**
Employee Data.xlsx**.

**
Try This: Do the following steps**

Open the spreadsheet **
Employee Data.xlsx.**

1.
Format the labels Big, Bold, and Blue

2. Name the Range B1:B9: Education

3. Name Range D1:D9: Bonus

4. Name the Range C1:C9: Location

5 Name the Range A1:A9: Employee

6. In Cell E11, use the SUMIF function to
add the bonuses earned at the Detroit Location

7. In Cell E12, use the SUMIF function to
add the bonuses earned at the Ann Arbor Location

8. In Cell E13, use the SUMIF function to
add the bonuses earned at the Lansing Location

9. Save your spreadsheet as:

YOUR NAME Name that Tune
Practice

1. Which is
true about a Range?

(Select all
correct answers.)

a. It is one or more cells in a spreadsheet

b. It can be given a name

c. Named Ranges can be used in a formula

Tip: Intermediate Excel, page 87, 88, 92

2. How do you Name a Range?

(Select all
correct answers.)

a. Formulas-> Defined Name

b. Type name in the Name Box

Tip: Intermediate Excel, page 89, 90

3. Which is true about the rules for naming Ranges?

a. Can be text, numbers, periods, and underscores

b. Can include spaces

c. Can be up to 255 characters

d. Cannot include cell references such as B1

e. The first character must be a letter

Tip: Intermediate Excel, page 91