Answer:
=DSUM(A4:D8, "Unit Cost", A1:B2)
Explanation:
From the list of given options, it's obvious that the question relates to Excel database sum function.
The correct answer among the list of options is:
=DSUM(A4:D8, "Unit Cost", A1:B2)
Where
DSUM represents the function itself
A4:D8 represents the range
"Unit cost" represents the field
and
A1:B2 represents the criteria of the function
Analysing other options:
Option 1: The equality sign (=) before excel formulas is missing
Option 2: Sum is used instead of DSUM and there's a missing bracket before the range
Option 3: There's a missing comma between the range, the field and the criteria
Hence, the last option (4) answers the question.
