RE-POST

PLEASE SHOW THE EXCEL FORMULA

HOMEWORK: The table in the above picture represents the sales information for the first 10 days of October, 2022 of a computer accessories shop named 'Computer Tech'. Your tasks are: 1. Create the above table in an excel workbook. Name that sheet as "Computer Tech". 2. Create a central header named "Computer Tech: Monthly Sell" and bold it. (Hint: Merge cells to create the central header.) 3. Bold all the column header and fill them with light green. 4. Randomly fill in the values for the 'Order ID' column and these should be unique. (Hint: Random values for the 'Order ID' column can be generated with the RANDBETWEEN() function.) 5. Fill in the values for the 'Order Date' column for the first 10 date of the month of October 2022. 6. Randomly fill in the values for the "Product Name", "Product ID", "Buying Price Per Unit", "Selling Price Per Unit" and "Number of Products" columns. (Hint: Selling Price Per Unit must be greater than Buying Price Per Unit) 7. Calculate the 'Total Price' for each order. 8. Calculate the 'Total Profit" for each order. (Hint: The profit can be calculated with the subtraction of sell price from the buy price.) 9. Calculate the "Grand Total Number of Items" and bold it. 10. Calculate the "Grand Total Price" and bold it.(Hint: Sum all Total Price) 11. Calculate the "Grand Total Profit" and bold it. 12. Also, calculate the percentage of profit for each order. 13. All cell data should be aligned horizontally and vertically centered