|Total of questions: 236|
|Total of questions: 236|
|First steps (3 questions)|
|Basic Settings (19 questions)|
|Cells (4 questions)|
|Formulas and Functions (34 questions)|
|Formatting (12 questions)|
|Charts (21 questions)|
|Special functions 1 (20 questions)|
|Special functions 2 (19 questions)|
|Images (3 questions)|
|Data (31 questions)|
|Sortings, Filters, Macros, Templates (19 questions)|
|DIPLOMA level questions (6 questions)|
|MS Excel Expert 2016, 2013, 2010, 2007, 2003 (BENCHMARK) (30 questions)|
|MS Excel Expert 2016, 2013, 2010, 2007, 2003 (ASSESSMENT) (15 questions)|
Sort the cell range A1:C21 by team in ascending order and by the points they have received in descending order.
Insert a button on the right of the button Save which appears on the Standard toolbar and assign the macro named mymacro to it.
Assign mymacro to myButton which appears on myToolbar. Then, change the name of the button from myButton to yourButton.
Create an advanced filter on the cell range B33:D34, to display the number of white shoes sold by salesman Fasoulas.
Create a new workbook based on the ExpenseStatement template.
Run mymacro in the cell B4.
Record a new macro using the name newmacro to apply Bold and Italics.
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)
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.
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.
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.
Disable the filter (turn filtering off).
Apply Filter and display only the entries where the salesman is Baitsopoulos I. and the color is Black.
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.
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.
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.
Create an advanced filter to display only orders placed after 02/02/2004, by Lambropoulos Stelios, in a quantity greater than 10.
Apply sorting firstly by Month and then by Amount.
Apply descending sorting on the pivot table by the field Sales in EURO.