1245

Sort the cell range A1:C21 by team in ascending order and by the points they have received in descending order.

1270

Create an advanced filter on the cell range B33:D34, to display the number of white shoes sold by salesman Fasoulas.

1273

Create a new workbook based on the Expense Report template.

1277

Run mymacro in the cell B4.

1279

Record a new macro using the name newmacro to apply Bold and Italics.

1291

Open the Expense Report template located in the IL-ates\Excel folder on your desktop and apply Green font color on the text Balance. Save the template.

(Note: use Excel's menu to open the template)

1517

Sort all data of the active worksheet firstly by column data01 then by column data02 and then by column data03. Apply all sortings in ascending order.

1518

Sort all data of the active worksheet firstly by column data15 in ascending order then by column data08 in descending order and lastly by column data01 in descending order.

1519

Sort by the 1st row from left to right in descending order, then by the 1500th row in descending order and lastly by the 1499th row in descending order.

1520

Disable the filter (turn filtering off).

1521

Apply Filter and display only the entries where the salesman is Baitsopoulos I. and the color is Black.

1522

Apply a filter to the data and display only the East District entries with a Color beginning with the letter B and Price is >=70 or <=10.

1523

Insert the appropriate data in the cell range A51:C51 so that if you apply an advanced filter, only the salesman Dounias B entries, with Black color and a total > 2000 are displayed. Apply the filter.

1524

Insert the appropriate data in the cell range Á51:C52 so that if you apply an advanced filter, only entries:

Black color, pieces <50 and Total >2000 or

Red color, pieces >50 and Total <2000 are displayed. (Insert data in the provided order).

Copy the outcome in the cell range beginning from cell A60.

1860

Create an advanced filter to display only orders placed after 02/02/2004, by Lambropoulos Stelios, in a quantity greater than 10.

1871

Apply sorting firstly by Month and then by Amount.

1920

Apply descending sorting on the pivot table by the field Sales in EURO.