Using Excel, create a workbook with the following worksheets

Sheet 1: Create a worksheet that will do:

1. 9's complementary representation computation of decimal numbers (three digit values only).
2. 1's complementary representation computation of binary numbers (8 bits).

Sheet 2: Write the equivalent Conventional Binary and Binary Coded Decimal of your student number. Please ensure to put 4 bits per cell.