Insert the date 12/31/2004 in cell Â19 of the SALES worksheet.
Replace the content of 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 B2:H11 by Total cost in a descending order.
Automatically fill in the cell range A5:A110 using the pattern appearing in the cell range A3:A4.
Adjust the width of the A column in 1.0".
Select all cells containing the word motherboard in the active worksheet.
On the 2ndhour2 worksheet select the cell range Â22:Ç22 and move it to the cell range B13:H13. Then wrap the contents of cell B20.
Select column B and row 4 from the active worksheet.
Select the cell range Â1:Ê9 and set it as print range.
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 containing a value less than or equal to 1000 are displayed in style Heading1.
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.
Repeat the last action 3 times.
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 from cell Â10.
Adjust the height of the second row to 0,50".
Change the content of the cell B4 of the SALES worksheet from COMPANY to BUSINESS.