Question: create the following table using microsoft excell and fill the table as following mention variable X N x+3y2-62 averagely,z) status 8 12 14 7 15

create the following table using microsoft excell and fill the table as following mention variable X N x+3y2-62 averagely,z) status 8 12 14 7 15 34 16 19 5 3 15 17 22 34 2 9 5 23 22 18 23 17 3 11 6 15 7 15 17 4 18 18 13 4 20 max averages min averages count average- count if average >18 1) status =(x+y) if (y>z) else status=(x-y) 2) insert chart between x and average 3) sort the table ascending according average
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
