71155 Based on the information given below, fill in the prediction spreadsheet, naming it Lux Lights Spreadsheet: Business Computing Assessment 3, OP, NZ

Task 1:
Based on the information given below, fill in the prediction spreadsheet, naming it Lux Lights Spreadsheet.

You will need to use functions and formulas to:
• fill in the identifier page at the front of the worksheet
• ensure that all numbers (except headers) are right-aligned, and font size 10 in the Verdana font
• all cells containing numbers (except headers) should be in the accounting format, to two decimal places
• fill up cells B3 and B4 using the information from the profit & loss sheet
• identify the Gross profit/net sales (B6)
• identify subtotal and net profit before taxes (B22 and B23)
• calculate the taxes (B24, C24, D24) using the tax rates shown at the bottom of the table (B29, B30)
• create range names in cells B24, C24, and D25 under the names ‘Corporate_Tax2021’, ‘Corporate_Taxweb’, ‘Corporate_Taxproducts’