Bus308: Excel

Complete Questions 1-5

AutoSave O OFF sp23 exam OP Home Insert Draw Page Layout Formulas Data Review View Automate Table Tell me Comments Share X Times New Roman A ab A Accounting Conditional Formatting v Insert v 11 Format as Table v mix Delete v Paste B IUV A $ v % " Editing Analyze Cell Styles v Format v Data P6 X V fx B C D F G H L M N P RedSea Employees database W N 21 03 04 Last Date ID No. First Name Address Phone Number Pay Rate Exemption Position FLSA Email Address Date of first payment Street Name Promotion Pay increase Name employed 49271 Monique Neriah 10/1/20 4283, Rockford Road 202-918-2132 $ 16.00 Non-Exempt Prep Part-Time Neriah_Monique@redsea. com 1/7/20 Rockford 91923 Mohammed Avila /19/18 2430, Morgan Street 425-466-9611 $ 16.00 Non-Exempt Prep Part-Tim Avila Mohammed@redsea. com 10/25/18 Morgan 40123 Muir Maja 1/1/21 4080, Wright Court 201-494-5274 16.00 Non-Exempt Prep Part-Time Maja_Muir@redsea. com 2/7/21 Wrigh 89123 Kyran Sorcha 2/7/20 1304, Brentwood Drive 82-529-7912 $ 16.00 Non-Exempt Busser Full-Time Sorcha Kyran@redsea. com /13/20 Brentwood 10 78932 Barton Mckenzie 4/9/20 2429, Whitman Court 315-988-2414 $ 16.00 Non-Exempt Busser Full-Time Mckenzie Barton@redsea. com 5/15/20 Whitman 13042 Asiling Jeremiah 5/21/22 2132, Hoffman Avenue 582-400-7595 $ 16.00 Non-Exempt Busser Full-Time Jeremiah_Asiling@redsea. com 6/27/22 Hoffman 40172 Tai Moss 5/22/22 4676,Johnny Lane 504-386-9218 17.50 Non-Exempt Server Part-Time Moss_Tait@redsea.com 6/28/22 Johnny 13 10389 Jia Deanne 5/23/22 3743, Augusta Park 82-201-3330 $ 17.50 Non-Exemp Server Part-Time Deanne_Jia@redsea. com 5/29/22 August 89032 Forbes Mej 5/24/22 3803,Memory Lane 505-436-5666 $ 17.50 Non-Exempt Server Part-Time Meji_Forbes@redsea. com 6/30/22 Memory 12349 Ed Isla /25/22 2074, Brookview Drive 205-797-9490 $ 17.50 Non-Exempt Server Full-Time Isla Ed@redsea.com 7/1/22 Brookview 71230 Spencer Philippa /26/22 2003, Stanton Hollow Road 582-262-4589 $ 17.50 Non-Exempt Serve Full-Time Philippa Spencer@redsea. com /2/22 Stanton Hollow 16032 Frye Currie /27/22 3833, Goldie Lane 307-403-1826 $ 17.50 Non-Exempt Server Full-Time Currie_Frye@redsea.com /3/22 Goldie 59843 Medina Guerrero 5/28/22 4284, Tator Road 82-222-0185 $ 18.00 Non-Exempt Bartender Full-Time Guerrero_Medina@redsea. com 7/4/22 Tator 56192 Maddison Arran /29/22 1139,Joy Lane 582-282-7500 $ 18.00 Non-Exempt Bartende Full-Time Arran_Maddison@redsea.com 7/5/22 Joy 20 37410 Aquib Sannah /30/22 1972, Coplin Avenue 239-794-2601 $ 18.00 Non-Exempt Bartender Full-Time Sannah_Aquib@redsea. com 7/6/22 Coplin 13402 Darlene Moore 5/31/22 3983, Boone Lane $09-748-3405 $ 20.00 Non-Exemp Supervisor Full-Time e Darlene@redsea. com /7/22 Boone 18043 Brianna Hamid 6/1/22 233, Nelm Street 82-682-0070 $ 20.00 Non-Exempt Supervisor Full-Time Hamid_Brianna@redsea. com /7/22 Nelm 23 12043 Power Noble 6/2/22 7543, Pretty View Lane 212-948-6363 $ 27.00 Non-Exempt Chef Full-Time Noble_Power@redsea. com 18/22 Pretty 57024 Vu Johnathon 6/3/22 5203, hamilton Street 580-234-2409 $ 27.00 Non-Exempt Che Full-Tim Johnathon_Vu@redsea.com 7/9/22 hamilton 12340 Tran Toan 6/4/22 9824, Percasex Aveune 123-523-5393 $ 27.00 Non-Exempt Che Full-Time Toan_Tran@redsea. com 7/10/22 Percasex 26 23405 Sydney Wooten 6/5/22 2534, Camel Road 308-371-5672 $ 29.00 Exempt Manager Full-Tim Wooten_Sydney@redsea. com 7/11/22 Camel 28502 Medlina Johnathon 5/6/22 3171,Jessie Street 505-696-9246 $ 29.00 Exempt Manager Full-Time Johnathon Medlina@redsea. com 7/12/22 Jessie RedSea employees Database functions Lookup + Ready Accessibility: Good to go 90%Page 1 > of2 - ZOOM + Q4- In the promotion column, enter either "Eligible" or "not eligible" according to the following: if the employee is a full-time employee and has a pay rate greater than $15, then she is eligible for promotion, otherwise, she is not eligible. (IF) 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) 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