select the correct answer. which function doe...
select the correct answer. which function does the subtotal function use? a. sumif b. and c. countif d. if e. max
Answer
# Brief Explanations:
The SUBTOTAL function in spreadsheet software can use various functions like SUM, COUNT, AVERAGE etc. among others. The IF function is a fundamental building - block that can be used within the logic of the SUBTOTAL function for conditional calculations. SUMIF, COUNTIF are more specialized for conditional sum and count respectively and not the base function used by SUBTOTAL. AND is a logical function mainly for combining logical conditions and MAX is for finding the maximum value. The SUBTOTAL can incorporate conditional logic which is based on the IF function.
# Answer:
D. IF