B D E G . 1 Sales Rep Analysis Invoices Total Amount 3 1 2 Reps 3 Boehmer 4. Johnson 5. Lesure 6 Riley 7 Total 8 9 10 Commission 0 2 0 0 0 0 Accounts Receivable Aging Number of Age Invoices Total Amount Current 1-30 days 31-60 days 61-90 days Over 90 days Totals Sales Rep Analysis Commission Total Amount 38 S 4,590.26 $ 61,203.40 23 5 1.416.765 23.612.65 31 5 1403.655 35,09135 10 S 1.076.07 19,564.90 1025 8.486.74 $ 139,472.30 Accounts Receivable Aging Number of Age Invoices Total Amount Current 54 S 80,317.60 1-30 days 36 $ 41,099.80 31-60 days 3 $ 5.546.70 61.90 days 35 2.076.00 Over 90 days 6 S 10.432.20 Totals 102 5 13947230 11 Reps invoices 12 Boehmer 13 Johnson 14 Lesure 15 Riley 16 Total 17 18 Structured Data 19 20 Sales Repl 21 22 23 24 25 Agint Structured Data Aging 11-30 days) Current Using the spreadsheet above, anwwer the questions below. The blue table shows the values you would have it your formulare corrett Structured arences are praedah 21 22 11-30 days) (Current) 23 24 25 Using the spreadsheet above, answer the questions below. The blue table shows the values you would have if your formula is correct structured data referencat are provided. Each question is worth 3 pts 1. Which is the correct formula for cell 03? A)-COUNTIFAging Sales Rep.5433) B) -COUNTIFAging Sales Rep).03) CCOUNTIFAging Sales Repl. Repin D) -COUNTIA Sales Rep).A3) 2. What is missing from the following formula for cells? SUMIRA Sales Repla Sales Como 3. What is the correct formula forcella A) SUMAging Sales Replacintovice Art G) SUMA Sales Replace Around) OSUMIRA Sales Replace Amount D) SUMIRACinel Sales Repi.sAXARinge Amount 4. Using the structured data, what is the formula force 4 5. Using the structured data, what is the formula forcell ABIE 1 21 22 23 24 25 Using the spreadsheet above, answer the questions below. The blue tabl question is worth 3 pts. 1. Which is the correct formula for cell B3? A) =COUNTIF(Aging[Sales Rep],$A$3) B) =COUNTIF(Aging[Sales Rep],B3) C) -COUNTIF(Aging[Sales Rep],[@[Sales Rep]]) D)=COUNTIF(Aging[Sales Rep).A3) 2. What is missing from the following formula for cell C3? =SUMIF(Aging[Sales Rep],A3, [Sales Commission]) 3. What is the correct formula for cell D3? A) =SUM(Aging[Sales Rep],$A$3.Aging[invoice Amount]) B) =SUM(Aging[Sales Rep],A3,Aging[Invoice Amount]) C) =SUMIF(Aging Sales Rep].A3,Aging[Invoice Amount]) D] =SUMIF(Aging Sales Rep],$A$3,Aging[invoice Amount]} 4. Using the structured data, what is the formula for cell G4? 5. Using the structured data, what is the formula for cell H4? AB
