
Microsoft Excel 2021365 - Beginner to Advanced - Creating Named Ranges
Interactive Video
•
Information Technology (IT), Architecture
•
University
•
Practice Problem
•
Hard
Wayground Content
FREE Resource
Read more
5 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the simplest way to create a named range in Excel?
Using the Name Manager
Using the Define Name option
Using the Name box
Using the Create from Selection button
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
When naming a range, what should you avoid including in the name?
Spaces
Underscores
Numbers
Special characters
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which method allows you to create a named range based on the values in a specific row or column?
Name box
Name Manager
Create from Selection
Define Name
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the keyboard shortcut to open the Name Manager in Excel?
Ctrl + M
Ctrl + F3
Ctrl + N
Ctrl + Shift + N
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Why are cell references in named ranges absolute by default?
To allow for easier editing
To ensure consistency in formulas
To prevent accidental changes
To make them compatible with all Excel versions
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Popular Resources on Wayground
8 questions
Spartan Way - Classroom Responsible
Quiz
•
9th - 12th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
14 questions
Boundaries & Healthy Relationships
Lesson
•
6th - 8th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
3 questions
Integrity and Your Health
Lesson
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
9 questions
FOREST Perception
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
Discover more resources for Information Technology (IT)
20 questions
Disney Trivia
Quiz
•
University
7 questions
Fragments, Run-ons, and Complete Sentences
Interactive video
•
4th Grade - University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
10 questions
DNA Structure and Replication: Crash Course Biology
Interactive video
•
11th Grade - University
7 questions
Force and Motion
Interactive video
•
4th Grade - University
20 questions
Implicit vs. Explicit
Quiz
•
6th Grade - University
14 questions
Ch.3_TEACHER-led
Quiz
•
University
7 questions
Comparing Fractions
Interactive video
•
1st Grade - University