excel test prior to the interview : Please complete the following test in the time given. Tasks 1. Make the table look more professional and presentable. 2. Using a formula and or/written text, highlight some differences between Areas 1 and 7 3. Create an extra column and row showing average values for the data. 4. Set a conditional format which highlights any number under 700 in red. 5. Sort the data by the July-23 totals descending. 6. Using the column created in Task 3 as a reference, show values in the table that are 'above average' or 'below average'. 7. Insert a column between Columns F & G to show the difference in the values in Columns F & G. 8. Create a graph of the data. 9. Demonstrate the use of the Count or Subtotal function 10. Add the following password 'Cl0ckwise' which users will then need to input to edit Sheet1.
