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
