please show formulas

Q2 (3 point): Use the following table to answer the questions below the table

Q2 (3 point): Use the following table to answer the questions below the table first emily jennifer james steve tom michael robert Sheryl last plaza jones dean smith vega placido walters ellis location purchase WA OR WA WA OR $900 $600 $300 $700 $800 $300 $900 $300 State 1 State 2 Threshold # of Customers WA OR 3 Notice, we can enter any values in Cells H3:H5. Are total sales in State 1 strictly greater than total sales in State 2? Return "TRUE" or "FALSE". Do both States 1 and 2 have at least the Threshold # of Customers (in cell H5)? Return "TRUE" or "FALSE".. Q2a (1 point): A customer's ID is defined as the last 3 capitalized letters of the customer's last name, concatenated with the first 3 lower-case letters of the customer's first name. Calculate customer IDs (Cells C4:C11) for all customers. You are required to ONLY create a formula in C4 and then fill down the same formula to C5:C11. Q2b (1 point): Use logical functions to answer the question in cell G9. Calculate your answer in the boxed cell (purple one) H9. Feel free to use other blank cells for intermediate calculations. Q2c (1 points): Use logical functions to answer the question in cell G13. Calculate your answer in the boxed cell (purple one) H13. Feel free to use other blank cells for intermediate calculations.