1. Go to Queries worksheet. Record a macro, QUESTION1, which will ask the user for the STATES and GENDER of customers (using InputBox functions) and then calculate percentage of people that meets that criteria? Set up criteria on Queries worksheet, and answer should be on Queries sheet in the cell indicated. Create macro button called Question1 on Queries sheet.

Please provide step by step with formula. Thank you.

A B E F G . 1 J K 1 2 3 4 Gender New Sales Value Birth Month $ $ $ $ Customer Name Amanda Amy Bill Lebron Sharma Virat Phil Jolly John Dillon Salinas Pizza Old Sales Value Customers Since 100.00 2 200.00 5 250.00 9 50.00 5 $59 14 125.00 2 115.00 5 105.00 1 95.00 10 $60 19 Date of Birth State 1/2/50California 2/10/60California 1/17/80 Nevada 3/14/00 Nevada 1/28/55 Alabama 5/2/40 Maine 1/10/80 Washington 5/20/90 Oregon 10/10/94 California 11/1/55 Alabama Female Female Male Male Male Male Male Female Male I Male $ $ $ $ 5 Customer ID 6 CID100A 7 CID100B 8 CID100C 9 CID100D 10 CID100F 11 CID100G 12 CID 100H 13 CID1001 14 CID100) 15 CID100K 16 17 18 19 20 21 22 23 24 25 26 27 Customers Products Queries + B E F G I 1 2 3 4 Sales Price Materials 5 Product ID 6 PID100A 7 PID100B 8 PID100C 9 PID100D 10 PID100E 11 PID100F 12 PID100G 13 14 15 Salinas Pizza Unit Price Manufactured Date 19 1/1/20 18 4/12/18 21 5/10/19 24 6/24/20 26 10/2/20 18 8/10/19 21 2/14/20 16 17 18 19 20 21 22 23 24 25 26 27 Customers Products Queries + A B E F G H 1 J K 1 2 3 4 Salinas Pizza 5 6 7 Answer Question 1 Below 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Customers Products Queries + A B E F G . 1 J K 1 2 3 4 Gender New Sales Value Birth Month $ $ $ $ Customer Name Amanda Amy Bill Lebron Sharma Virat Phil Jolly John Dillon Salinas Pizza Old Sales Value Customers Since 100.00 2 200.00 5 250.00 9 50.00 5 $59 14 125.00 2 115.00 5 105.00 1 95.00 10 $60 19 Date of Birth State 1/2/50California 2/10/60California 1/17/80 Nevada 3/14/00 Nevada 1/28/55 Alabama 5/2/40 Maine 1/10/80 Washington 5/20/90 Oregon 10/10/94 California 11/1/55 Alabama Female Female Male Male Male Male Male Female Male I Male $ $ $ $ 5 Customer ID 6 CID100A 7 CID100B 8 CID100C 9 CID100D 10 CID100F 11 CID100G 12 CID 100H 13 CID1001 14 CID100) 15 CID100K 16 17 18 19 20 21 22 23 24 25 26 27 Customers Products Queries + B E F G I 1 2 3 4 Sales Price Materials 5 Product ID 6 PID100A 7 PID100B 8 PID100C 9 PID100D 10 PID100E 11 PID100F 12 PID100G 13 14 15 Salinas Pizza Unit Price Manufactured Date 19 1/1/20 18 4/12/18 21 5/10/19 24 6/24/20 26 10/2/20 18 8/10/19 21 2/14/20 16 17 18 19 20 21 22 23 24 25 26 27 Customers Products Queries + A B E F G H 1 J K 1 2 3 4 Salinas Pizza 5 6 7 Answer Question 1 Below 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Customers Products Queries +