Clipboard Font B20 Q1 B C Merge & Center $%, Conditional Format as Cell 100 Alignment Number Fy Formatting Table Styles Styles D E F The commission rate for the salespeople is given in Table 1 (A3:B8), and the salespersons' sales are shown in Table 2 (A10:E16). Commission amount = Commission rate * sales amount Write a formula in B21 to calculate "Commission amount" based on the Commission Rate in Table 1 and sales amounts in Table 2. Apply the "Commission Rate" (B5) and the "Sales Amount" (B13) to determine the Commission amount in cell 821 and copy across and down through to cell E24. You should write a formula such that when the formula is copied, it computes the commission amount correctly. 2 3 Table 1 6 Owen Smith 4 Salesperson 5 Brenden Calderon 7 Bailey Cunningham B Meredith Palmer 9 0 1 Commission Rate 6.00% 7.50% 7.00% 5.00% Table 2 Sales Amount (in $ '000) 2 Salesperson 01 Q2 03 Q4 3 Brenden Calderon $ 288,000 $ 300,000 $ 307,000 $ 323,000 4 Owen Smith $ 372,000 $ 386,000 $ 359,000 $ 383,000 5 Bailey Cunningham $ 408,000 $ 412,000 $ 416,000 $ 364,000 S Meredith Palmer $ 333,000 $ 326,000 $ 325,000 $ 366,000 Table 3 G