1104

Insert the date 12/31/2004 in the cell B19 of the SALES worksheet.

1105

Replace the content of the cell B8 of the SALES worksheet from IL-COM to IL-ram (without changing the cell format).

1120

Enter a new column between Å and F columns, as well as a new row between row 4 and 5.

1121

Sort the contents of the cell range B2:H11 by Total cost in a descending order.

1122

Extend automatically the pattern of the cell range A3:A4 to the cell range A5:A138

1123

Set the width of column A to 8.57 characters.

1124

Select all the cells which contain the word motherboard in the active worksheet.

1129

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.

1133

Select column B and row 4 on the active worksheet.

1134

Select the cell range B1:K9 and set it as print area.

1142

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.

1154

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

1155

Select the whole worksheet.

1156

Delete column H and row 12.

1157

Undo the previous action.

1158

Repeat the last action 3 times.

1159

Copy the cell range B2:H12 to the cell range J2:P12.

1160

Delete the contents of the cell range B8:J8 in the SALES worksheet.

1161

Replace the word mouse with the word rat in the whole worksheet.

1194

Select the rows 3, 5 and 7.

1195

Select the columns C, D, E, F and H.

1198

Clear the contents, the format and the comments of the cell Â10.

1199

Adjust the height of the second row to 36 points.

1210

Change the content of the cell B5 of the SALES worksheet from COMPANY to BUSINESS

1211

Add the word COMPUTER before the word COMPANY, in the cell B5 of the SALES worksheet.