Total of questions: 186

 First steps (3 Fragen) Basic Settings (19 Fragen) Cells (4 Fragen) Formulas and Functions (34 Fragen) Formatting (11 Fragen) Charts (20 Fragen) Special functions 1 (20 Fragen) Special functions 2 (19 Fragen) Images (3 Fragen) Data (30 Fragen) Sortings, Filters, Macros, Templates (17 Fragen) DIPLOMA level questions (6 Fragen)

 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 the 1st row from left to right in descending order, then the 1500th row in descending order and lastly 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 2/2/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.