Question

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

Explanation:

• AVERAGE calculates the average of a set of numbers and 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 and can use positional arguments (e.g., =COUNT(B2:B20)).
• SUM adds up a range of numbers and can be used with positional arguments (e.g., =SUM(C3:C15)).
• MAX finds the maximum value in a range and can take positional arguments (e.g., =MAX(D4:D12)).
• COUNTIF has a specific syntax =COUNTIF(range,criteria) where the criteria is not a positional argument in the same sense as the simple range - based positional arguments for the other functions. For example, =COUNTIF(E1:E10,">50") has a non - positional ">50" criteria.

Answer:

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