Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need the correct functions for these problems please. Dell co obs Ob 10 May Total C 500 1 2 IM A more co SO

I need the correct functions for these problems please.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Dell co obs Ob 10 May Total C 500 1 2 IM A more co SO + 1 > 2 1 $2.000 SAATI NORS 2. SA SH SU ON $ 50 00 50 NOON ES 40 50 50 1 SA 16 VI 14 15 16 7 SOMS NOON O os 50 40 CH 1 2 24 73829328 883 RSRSR88888 VINO 30,00 51.73 SA 11 NO M NO 1 15 DO we 11 30 30 ON ON ON 30 > 32 1 PE 0 su 54 Se SE ho 1 > 2 2 2 2 2 3 1 1 2 2 1 1 IS 18 12 M su 1 WOON NO 4 100 S. SL . R $1,250 $2,50 1 10 BONUS ON 95 2 WOLON VE 06 19 1 VI NOR NOBO ON SA 15 Table 2 Toucher e HR For my dow T Cu tie BONS 0 WIM WA CE SM 11 12 1 1 TE 150 y of By Tallestial may To Te ONS SULES (2.2) Use the AND function to complete the "Time Bonus?" column of Table 1. An employee earns a time bonus if the "Hours Worked" on a project are less than the "Estimated Hours" for that project as long as the work "Quality" is also greater than 1. Reuse your formula to complete the column. 12.5 2.3) Use the OR function to complete the "Outcome Bonus?" column of Table 1. An employee earns an outcome bonus if the difficulty of a job is greater than 3 or the quality of their work is equal to 3. Reuse your formula to complete the column. 12.5 2.4 Use the IF function to complete the "Time Bonus $" column of Table 1. If an employee earns a time bonus (the corresponding cell in the "Time Bonus?" column is TRUE), then "Time Bonus $" is the "Job Pay" for that project times the bonus percentage in cell M3 Otherwise "Time Bonus $" is 0. Reuse your formula to complete the column. 10 2.5 Use the IF function to complete the "Outcome Bonus $" column of Table 1. If an employee earns an outcome bonus (the corresponding cell in the "Outcome Bonus?" column is TRUE), then "Outcome Bonus $" is the "job Pay" for that project times the outcome bonus percentage in cell M4 Otherwise "Outcome Bonus $" is 0. Reuse your formula to complete the column. A (2.6) Use the IF function to complete the "Comments" column of Table 1. Display "Good Job" if both the "Hours Worked" are less than or equal to the "Estimated Hours" for a project and the assessed "Quality" of that project is greater than 1. Note: you can combine "less than" and "equal to" operators - "4" to check for less than or equal to" Display "Too Much Time" if the "Hours Worked" on a project exceed the "Estimated Hours" for that project Otherwise, display "Poor Quality": Reuse your formula to complete the column

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Databases And Information Systems 25th European Conference Adbis 2021 Tartu Estonia August 24 26 2021 Proceedings Lncs 12843

Authors: Ladjel Bellatreche ,Marlon Dumas ,Panagiotis Karras ,Raimundas Matulevicius

1st Edition

3030824713, 978-3030824716

Students also viewed these Databases questions

Question

how would you have done things differently?

Answered: 1 week ago

Question

What were the reasons for your conversion or resistance?

Answered: 1 week ago