A ________, which is a subset of the cells in a worksheet that has a unique name, enables data to be transferred from Microsoft Excel to Microsoft Access.
A) specified label
B) consolidation table
C) named range
D) calculated column

Question

Quizplus · Accepted Answer

A named range is a subset of cells that has a unique name, which can be used to refer to the range in formulas and VBA code. It is commonly used to transfer data from Excel to Access by defining a named range for the data and then importing it into a table in Access. This allows for easy data analysis and manipulation in Access.

A ________, Which Is a Subset of the Cells in a Worksheet