10
JLMultiple Choice

Modern Art in Context

Question 10 • *CR Art History I S2 [ELECTIVE, A1560OX]

Which option is an appropriate database function syntax?

Answer
A
DSUM(A4:D8,“Unit Cost”,A1:B2)
B
=SUMA4:D8,“Unit Cost”,A1:B2)
C
=DSUM(A4:D8“Unit Cost”A1:B2)
D
=DSUM(A4:D8,“Unit Cost”,A1:B2)

Explanation

The DSUM function uses the syntax =DSUM(database, field, criteria). Choice D includes the equals sign, the database range A4:D8, the field name “Unit Cost,” and the criteria range A1:B2, separated by commas. The other choices omit the equals sign or leave out required function syntax.

AI-written and checked against the verified answer.

Previous
Next