Question

which of these functions may be used with positional arguments? select four options. average countif count sum max

Explanation:

• AVERAGE: Calculates the arithmetic mean of a set of numbers. It can take positional arguments (e.g., =AVERAGE(A1:A10) where A1:A10 is a positional range).
• COUNT: Counts the number of cells that contain numbers. Positional arguments like cell ranges (e.g., =COUNT(B2:B20)) are valid.
• SUM: Adds up a range of numbers. It uses positional arguments such as cell ranges (e.g., =SUM(C3:C15)).
• MAX: Finds the largest value in a set of data. Positional arguments (e.g., =MAX(D4:D12)) are acceptable.

COUNTIF, on the other hand, has a specific syntax =COUNTIF(range, criteria) where the "criteria" is not just a positional value in the same sense as the other functions (it's a condition, not just a range of values to count in a simple positional - argument - only way for the main counting purpose).

Answer:

A. AVERAGE, C. COUNT, D. SUM, E. MAX