$1.$ Create the following data sheet in a new Excel worksheet: Marks $\_\_\_\_\_/1$

Name Employee Code Region Department Earning $($$$)$

Diana Stone $30$ East Marketing $60000$

Jesse Bennet $23$ South Sales $250500$

Rita Greg $9$ East Sales $380050$

Adam Long $18$ North Administration $90000$

Anna Morris $26$ West Accounts $150000$

Annie Philips $6$ West Human resources $60000$

David Ford $38$ North Customer support $150200$

Davis Lee $37$ East Accounts $73500$

$2.$ Apply blue fill to the first row of the data sheet. Marks $\_\_\_\_\_/2$

$3.$ Leave a blank row under the last record in the data table. In the next row, Calculate: Marks $\_\_\_\_\_/5$

i$.$ Total Earnings of all employees collectively

ii$.$ Number of employees

iii. Average earning

iv$.$ Minimum earning

v$.$ Maximum earning

$4.$ Also apply conditional formatting as: Marks $\_\_\_\_\_/2$

i$.$ Earnings less than average: light red fill with dark red text

ii$.$ Earnings grater than average: green fill with dark green text