Instructions:

Create an Excel spreadsheet that contains 12 row by 5 columns of random integers that range from 1000 to 100,000, assume these are the sales data of 5 divisions of a company from January to December, apply appropriate column headings and row headings. Then, excise the following tasks:

Format the numbers to currency format so that each number has a leading $ sign and two decimal places.

Using Excel functions and relative cell reference, calculate maximum, minimum, average and total sales figure for each division.

Calculate 0.5 % of total sales figure of each division.

Using conditional formatting, highlight or bold the numbers larger than $75,000.

Insert a 2-D Column chart for entire spreadsheet, position the chart at an appropriate location.