5330

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

5331

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

5332

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

5333

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

5334

Automatically fill in the cell range A5:A110 using the pattern appearing in the cell range A3:A4.

5335

Adjust the width of the A column in 1.0".

5336

Select all cells containing the word motherboard in the active worksheet.

5337

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.

5338

Select column B and row 4 from the active worksheet.

5339

Select the cell range Â1:Ê9 and set it as print range.

5340

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.

5341

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

5342

Select the whole worksheet.

5343

Delete column H and row 12.

5344

Undo the previous action.

5345

Repeat the last action 3 times.

5346

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

5347

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

5348

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

5349

Select the rows 3, 5 and 7.

5350

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

5351

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

5352

Adjust the height of the second row to 0,50".

5353

Change the content of the cell B4 of the SALES worksheet from COMPANY to BUSINESS.