Capstone Project,Instructions-Saved to this PC nces Mailings Review View Help Tell me what you want to do +-2 r A AaBbCcDd AabccDd AaBbCc AaBbcco Aa B AaBbccD ::.. , ..h ...-1 Normal 1Nospac Heading i Heading2 Title Subtite Styles Paragraph Read the scenario c. Scenario 1: You would like to find out the average hourly wage for employees tha the job titles of Supervisor and Sr. Officer One. You must use Database functions to complete this t live in town with a. Referring to scenario 1 or the label in cell A22, complete cell E22, using a database function. b. use cells in row 22, beginning under column F and moving to the right (ie. G22, H22, etc.) to type in as many criteria labels as needed Use as many cells necessary beneath your criteria labels to perform your database function. Format your results in cell E22 in the accounting style. Save your work. c. d. Scenario 2: You would like to find out the Total Wages per Shift for all Supervisors that worked more than seven hours and Jr. Officer Twos having worked less than six hours. a. Referring to scenario 2 or the label in cell A26, complete cell E26, using a database function. Use cells in row 26, beginning under column F and moving to the right (i.e. G26, H26, etc.) to c. Use as many cells necessary beneath your criteria labels to perform your database function. Scenario 3: Find the number of employees that have been assigned cars, worked more than 6 hours type in as many criteria labels as needed. d. Format your results in cell E26 in the accounting style. Save your work. and live in town. a. Referring to scenario 3 or the label in cell A30, complete cell E30, using a database function. b. Use cells in row 30, beginning under column F and moving to the right (i.e. G30, H30, etc.) to type in as many criteria labels as needed c. Use as many cells necessary beneath your criteria labels to perform your database function. d. Save your work. Capstone Project,Instructions-Saved to this PC nces Mailings Review View Help Tell me what you want to do +-2 r A AaBbCcDd AabccDd AaBbCc AaBbcco Aa B AaBbccD ::.. , ..h ...-1 Normal 1Nospac Heading i Heading2 Title Subtite Styles Paragraph Read the scenario c. Scenario 1: You would like to find out the average hourly wage for employees tha the job titles of Supervisor and Sr. Officer One. You must use Database functions to complete this t live in town with a. Referring to scenario 1 or the label in cell A22, complete cell E22, using a database function. b. use cells in row 22, beginning under column F and moving to the right (ie. G22, H22, etc.) to type in as many criteria labels as needed Use as many cells necessary beneath your criteria labels to perform your database function. Format your results in cell E22 in the accounting style. Save your work. c. d. Scenario 2: You would like to find out the Total Wages per Shift for all Supervisors that worked more than seven hours and Jr. Officer Twos having worked less than six hours. a. Referring to scenario 2 or the label in cell A26, complete cell E26, using a database function. Use cells in row 26, beginning under column F and moving to the right (i.e. G26, H26, etc.) to c. Use as many cells necessary beneath your criteria labels to perform your database function. Scenario 3: Find the number of employees that have been assigned cars, worked more than 6 hours type in as many criteria labels as needed. d. Format your results in cell E26 in the accounting style. Save your work. and live in town. a. Referring to scenario 3 or the label in cell A30, complete cell E30, using a database function. b. Use cells in row 30, beginning under column F and moving to the right (i.e. G30, H30, etc.) to type in as many criteria labels as needed c. Use as many cells necessary beneath your criteria labels to perform your database function. d. Save your work