PLANNING CREATION TASK

As my final term 3 task for creating a spreadsheet in Excel, I decided to use different functions that would be useful in a shop. My creation will be focused in an art store and it will include:

• Retailer stock database including a graph representation
• Art store checkout of a customer
• Worker's salary including commission

I will be using one unfamiliar function that we have not yet learnt at school. It is used to rank values in a desired order, ascending or descending. 

The syntax for the rank function is:

 RANK (number, array, [order])

Meanings:

Number: The number to find the rank for.
Array: A range of numbers to use for ranking purposes
Order: It specifies how to rank the numbers, but it is only optional

• Order = 0 means descending order
• Order = not 0 means ascending order