When you use a named range in a formula, it becomes a(n) _____ reference by default.
A) external
B) 3-D
C) absolute
D) relative

Name: When you use a named range in a formula, it becomes a(n) _____ reference by default. A) external B) 3-D C) absolute D) relative
Brand: Quizplus
Rating: 4.8 (38 reviews)

Question

Quizplus · Accepted Answer

When you use a named range in a formula, it becomes an absolute reference by default, meaning the cell reference stays fixed regardless of where the formula is copied or moved within the worksheet.

When You Use a Named Range in a Formula, It