select the correct answer. shari works as a sales manager with a retailer that has stores across the united…

select the correct answer. shari works as a sales manager with a retailer that has stores across the united states. she has the regional sales figures for each product as shown in the spreadsheet. which function can she use to calculate the total sales of product xyz? a b c d e f 1 sales (units) 2 item north east south west total 3 abc 989 665 323 133 4 pqr 4,333 2,200 1,345 2,982 5 xyz 3,213 2,489 1,998 3,449 o a. count(b5:e5) o b. max(b5:e5) o c. round(b5:e5) o d. sum(b5:e5)

select the correct answer. shari works as a sales manager with a retailer that has stores across the united states. she has the regional sales figures for each product as shown in the spreadsheet. which function can she use to calculate the total sales of product xyz? a b c d e f 1 sales (units) 2 item north east south west total 3 abc 989 665 323 133 4 pqr 4,333 2,200 1,345 2,982 5 xyz 3,213 2,489 1,998 3,449 o a. count(b5:e5) o b. max(b5:e5) o c. round(b5:e5) o d. sum(b5:e5)

Answer

Answer:

D. SUM(B5:E5)

Explanation:

Step1: Identify the task

Find total sales of product XYZ.

Step2: Analyze each option

COUNT counts cells, not sums. MAX finds maximum value, not total. ROUND rounds numbers, not sums. SUM adds values in range B5:E5 which is correct for total sales.