Insert the date 12/31/2004 in the cell B19 of the SALES worksheet.
Replace the content of the cell B8 of the SALES worksheet from IL-COM to IL-ram (without changing the cell format).
Enter a new column between Å and F columns, as well as a new row between row 4 and 5.
Sort the contents of the cell range B3:H12 by Total cost in a descending order.
Extend automatically the pattern of the cell range A3:A4 to the cell range A5:A138
Set the width of column A to 8.57 characters.
Select all the cells which contain the word motherboard in the active worksheet.
Select the cell range Â22:Ç22 of the 2ndhour2 worksheet and move it to the cell range B13:H13. Then wrap the contents of cell B20.
Select column B and row 4 on the active worksheet.
Select the cell range B1:K9 and set it as print area.
Sort all data of the Competiton1 worksheet firstly by Salesman then by District and lastly by Total. All fields should be sorted in ascending order. Then format the Total field so that the cells displaying a value less than or equal to 1000 are displayed in red font color.
Insert the following data on the active spreadsheet:
cell A1: 10 cell A2: 100 cell A3: 333 cell B1: kostas cell B2: stelios cell B3: despina
Select the whole worksheet.
Delete column H and row 12.
Undo the previous action.
Copy the cell range B2:H12 to the cell range J2:P12.
Delete the contents of the cell range B8:J8 in the SALES worksheet.
Replace the word mouse with the word rat in the whole worksheet.
Select the rows 3, 5 and 7.
Select the columns C, D, E, F and H.
Clear the contents, the format and the comments of the cell Â10.
Adjust the height of the second row to 36 points.
Change the content of the cell B5 of the SALES worksheet from COMPANY to BUSINESS
Add the word COMPUTER before the word COMPANY, in the cell B5 of the SALES worksheet.