Question Demo 1
Completion requirements
1. Remove hidden properties and personal information from the workbook. Do not remove any other content.
2. On the “Orders” worksheet, name the range A3:A10 as “Identification”.
3. Navigate to the range named "Buy" and delete the contents of the selected cells
4. On the "Orders" worksheet, in the cells B4:B1940, format the cells to display the numbers to three decimal places
5. On the “Customers” worksheet, change the horizontal alignment of the Customers column to LEFT(Indent). Set the indent to 2
6. On the “Products” worksheet, in cells B2:B92, use conditional formatting to apply a Yellow Fill with Dark Yellow text to the cells that contain values greater than 300.00
7. Remove all conditional formatting rules from the “Customers” worksheet.
8. On the “Customers” worksheet, adjust the width of columns D:F to exactly 20.
2. On the “Orders” worksheet, name the range A3:A10 as “Identification”.
3. Navigate to the range named "Buy" and delete the contents of the selected cells
4. On the "Orders" worksheet, in the cells B4:B1940, format the cells to display the numbers to three decimal places
5. On the “Customers” worksheet, change the horizontal alignment of the Customers column to LEFT(Indent). Set the indent to 2
6. On the “Products” worksheet, in cells B2:B92, use conditional formatting to apply a Yellow Fill with Dark Yellow text to the cells that contain values greater than 300.00
7. Remove all conditional formatting rules from the “Customers” worksheet.
8. On the “Customers” worksheet, adjust the width of columns D:F to exactly 20.
Grading method: Highest grade