Excel in 30 Minutes Using Named Ranges

Excel in 30 Minutes Using Named Ranges

Time limit: 0

Quiz Summary

0 of 3 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 3 Questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

1
2
3

Current
Review
Answered
Correct
Incorrect

Question 1 of 3

1. Question
If you want to use a named range on multiple worksheets, you need to set the scope to “Workbook
- True
- False
Correct

Incorrect
Question 2 of 3

2. Question
Which of the following is a benefit to using named ranges?
- Easier to remember than cell addresses
- Simplifies formulas and makes them user friendly
- Enter formulas faster
- All of the above
Correct

Incorrect
Question 3 of 3

3. Question
Named ranges must start with a letter, underscore, or a backslash.
- True
- False
Correct

Incorrect

ATS eLearning

Scroll to Top

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?

Register

Don't have an account? Register one!

Register an Account