Q. Which Excel feature allows creating a dynamic range?

A
Named Ranges
B
Pivot Table
C
Conditional Formatting
D
Data Validation
Solution:

Named Ranges can be defined with dynamic formulas (e.g., OFFSET) to create adjustable ranges.

Entri PDF Icon

Get Question Bank

Strengthen Your Practice with our comprehensive question bank.

Entri Contact Image

Get Expert Advice for Free: Register for Your Free Consultation Now!