Question

which option is an appropriate database function syntax?
○ dsum(a4:d8,\unit cost\,a1:b2)
○ =suma4:d8,\unit cost\,a1:b2)
○ =dsum(a4:d8\unit cost\a1:b2)
○ =dsum(a4:d8,\unit cost\,a1:b2)

Explanation:

To determine the correct database function syntax, we analyze each option:

1. The first option lacks the = sign, which is required for Excel functions.
2. The second option uses SUMA (incorrect; the correct function is DSUM), and the syntax is also wrong as it's missing commas between arguments.
3. The third option is missing commas between the arguments in the DSUM function, making the syntax invalid.
4. The fourth option has the correct structure: starts with =, uses the correct function DSUM, and has commas separating the database range (A4:D8), the field name ("Unit Cost"), and the criteria range (A1:B2).

Answer:

=DSUM(A4:D8,"Unit Cost",A1:B2)