The _____ function extracts a single record from a table that matches criteria.
A)DGET
B)DMATCH
C)DEXTRACT
D)DSINGLE

Question

The _____ function extracts a single record from a table that matches criteria.​
A)DGET
B)DMATCH
C)DEXTRACT
D)DSINGLE

Quizplus · Accepted Answer

The DGET function is used to extract a single record from a table that matches criteria by returning a single value from the intersection of a particular row and column in a specified range. The other options listed (DMATCH, DEXTRACT, DSINGLE) are not valid Excel functions.

The _____ Function Extracts a Single Record from a Table