Bus308: Excel

Q6- what is the average pay rate of employees who work full time and who started working before 2022 Q7- what is the number of employees who work as either server, manager, or supervisor and who are making more than $17 as pay rate

Q8- What is the pay rate of the employee whose first name is Aquib? Q9- how many employees have a last name that has the letter "e" as the second letter and has a position "Prep" Q10- 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 Q11- how many employees have a salary between $15 and $18 dollars and work full-time at the company Q12- in the lookup sheet, put a dropdown list to select the first name of the employee, and then use a lookup function to find the employee's pay rate and position. (vlookup)

AutoSave O OFF sp23 exam OP Home Insert Draw Page Layout Formulas Data Review View Automate Tell me Comments Share Calibri (Body) 11 A ab A General Conditional Formatting v Insert v Format as Table mix Delete v Analyze Paste BIUV A $ v % " Editing Cell Styles v Format v Data B28 X V fx C D G H M Q U W AA Q6 ID No. First Last Date Address Phone Pay Rate Exemptio Position | FLSA Name Name | employed Number 17 Server Manager Supervisor 20 24 #VALUE! 26 27 28 29 30 Q8 31 Date Phone ID No. First Last Address Pay Rate | Exemptio Position FLSA 32 Name Name | employed Number RedSea employees Database functions Lookup + Ready Accessibility: Good to go 80%AutoSave O OFF sp23 exam OP Home Insert Draw Page Layout Formulas Data Review View Automate Tell me Comments Share X Calibri (Body) A ab 11 A General Conditional Formatting v Insert v Format as Table mix Delete v Paste BIUV A $ v % " Editing Analyze Cell Styles v Format v Data B28 X V fx B C D F G H K M Q U W AA 29 30 Q8 31 ID No. First Last Date Address Phone Pay Rate | Exemptio Position | FLSA 32 Name Name| employed Number n 33 35 39 40 43 Q9 First Last Date ID No. Address Phone Pay Rate | Exemptio Position | FLSA 44 Name employed Number 45 50 53 54 55 56 Q10 ID No. Last Date Address Phone Pay Rate Exemptio Name Name| employed Number n Position | FLSA RedSea employees Database functions Lookup + Ready Accessibility: Good to go 80%