4
AssignmentMultiple Choice

Introduction to Functions

Question 4 • TX-Business Information Management (BIM) I

What is a benefit of naming cells and ranges?

Answer
A
Using names in ranges is the only way to use formulas.
B
Using names in formulas changes the color and font quickly with named cells.
C
Using names in formulas makes it clearer to see what the function is.
D
Using names in ranges hides the function from the worksheet.

Explanation

A descriptive name such as “Sales” can make a formula easier to understand than a cell reference such as B2:B20. Naming cells and ranges is optional, and it does not change formatting or hide a formula. Therefore, the benefit is that names make it clearer to see what a function does.

AI-written and checked against the verified answer.

Previous
Next