A range of cells designated as a(n)____ can be analyzed and treated as separate from the rest of the Excel worksheet.
A) filtered group
B) defined name
C) function
D) Excel table

Question

Quizplus · Accepted Answer

An Excel table allows a range of cells to be analyzed and treated as separate from the rest of the Excel worksheet, providing structured references, the ability to quickly apply formulas, sort, filter, and format.

A Range of Cells Designated as A(n)____ Can Be Analyzed