Create a new spreadsheet named final.xlsx. Enter the following data into the worksheet. Enter numbers exactly as you see them. The first row is a heading that should merge across all six columns.

Open Excel. Create a new spreadsheet named final.xlsx. Enter the following data into the worksheet. Enter numbers exactly as you see them. The first row is a heading that should merge across all six columns.

To complete your worksheet, add the following:

1. Enter a formula to compute the tax on each order (Price * 0.07). Format the values as ‘Currency’.
2. Use the IF function to find the shipping charge. If the weight is more than 125 pounds the shipping charge is $1.00 per pound (1.00 * pounds). Otherwise it is $0.75 per pound (.75 * pounds).
3. Use either a function or a formula to find the total cost of each order.
4. Display the numbers in the Tax, Shipping, and Total columns with two decimal places.
5. Make the title bold and increase the font size of it.

Sort the data by descending ‘Order No.