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

Question

Quizplus · Accepted Answer

A named range in Excel is a subset of the cells in a worksheet that has a unique name. This named range can then be used to transfer data from Excel to Access by linking the Excel worksheet to an Access database. Once the named range is created, it can be selected as a data source when setting up a linked table in Access. Therefore, option C is the best choice for this question.

Data Can Be Transferred from Excel to Access by Creating