1.Record a macro, named QUESTION1, that will help the user of this excel file calculate percentage of employees who have a salary of $45000 and are from a specific department (i.e. the user can choose which department these employees are from; thus, Inputbox function should be used here so that each user can type the department they want to find data about). Setup criteria on Queries worksheet, and answer should be on Queries sheet in the cell indicated. 1.Record a macro, named QUESTION1, that will help the user of this excel file calculate percentage of employees who have a salary of $45000 and are from a specific department (i.e. the user can choose which department these employees are from; thus, Inputbox function should be used here so that each user can type the department they want to find data about). Setup criteria on Queries worksheet, and answer should be on Queries sheet in the cell indicated.