... follows: * Entering Formulae * Adding comments * Conditional Formatting * Creating a lookup table * Data Validation * Using goal seek * Inserting Buttons and Macros These are key functions I will be using when I create our virtual spreadsheet. The first key function enables you to input formulae into your worksheets to calculate the maximum, minimum, average and total for what ever you are promoting, in this case it is to calculate the bills for the employees who use the cars under your management. Microsoft excel allows you to add comments which means that you are able to writ a comment next to a figure to explain what it means, and if there is a blank space you are able to explain why there is no figure in that space just by using this function. Conditional Formatting allows you to make certain figures stand out from the rest, you would want to too this for instance if ...

See this essay or coursework document in full right now