URGENT!!!!! Bus308: Excel questions

Q5- In the "pay increase column", write down the pay rate increase value according to the following:

If the employee is full-time and has a position of a server the employee's salary increases by 10%, otherwise if the employee's position is chef and works full-time, the employee's salary increase is 10%, otherwise, the employee gets no increase. (IF formula) Q11- How many employees have a salary between $15 and $18 dollars and work full-time at the company?

AutoSave O OFF A AFSC. Sp23 exam Home Insert Draw Page Layout Formulas Data Review View Automate Tell me Comments LE Share fx ? A Define Name 7 Trace Precedents Use in Formula v Trace Dependents Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Name Show Error Watch Calculation Function Used Time Reference Trig Functions Manager Bi Create from Selection Remove Arrows v Formulas Checking Window Options A32 X V fx =DCOUNTA(Table_1[#All], Table_1[[#Headers], [Pay Rate]], 'Database functions'!A30:L31) M U W 13 What is the pay rate of the employee whose first name is Aquib? First Last Date ID No Address Phone Pay Rate Exemption Position FLSA 14 Name Name | employed Number Aquib S 18 18 09 how many employees have a last name that has the letter "e" as the second letter and has a position "Prep" ID No. First Last Date Phone Position FLSA 19 Name Name employed Address Number Pay Rate Exemption 20 ?e* Prep 1 23 what is the average pay rate of employees with a phone number starting with area code 582 and who work as either a bartender or a supervisor Last Date ID No. First Name Name| employed Address Phone Pay Rate Exemption Position FLSA 24 Number 25 582* Bartende 26 582* Supervisor 27 S 20 28 29 Q1 How many employees have a salary between $15 and $18 dollars and work full-time at the company ID No. First Last Date Phone Name Name | employed Address Number Pay Rate Exemption Position FLSA Pay increase Pay increase 30 Full-Time >=15 10%), F8*1. 1025, IF(AND((D8, 1)"A",K8>=10, K8