1248 Calculate the subtotals of the turnover, for each change in Geographical Direction within the cell range A3:C19. 1255 Replace the formulas of the cell range K5:K9 with the values of the same cells. 1263 Create two scenarios using the following data. The changing cells will be D7:D9. The first one, named Optimistic, will display: value 1323 in the cell D7 value 543 in the cell D8 value 987 in the cell D9. The second, named Pessimistic, will display: value 989 in the cell D7 value 243 in the cell D8 value 890 in the cell D9. 1282 On a new worksheet create a Pivot Table Report based on the data of the cell range B5:F26. Display the Product field in Column Labels, the Salesman field in Row Labels and the Color and Quantity fields in the Values. 1283 Navigate to report worksheet and group the dates which appear in the pivot table by quarters. 1506 Insert the data of the out1.txt file located in the ΙL-ates\Excel folder on your Desktop in cell Β10. (Delimiter is the semicolon ; ). 1512 Calculate subtotals in the column Turnover at each change in Orientation. Display the Summary below data. 1513 Use a One-Variable Data Table to calculate in the cell range B2:B25 the VAT of the values appearing in the cell range A2:A25. The formula is provided in cell E3 and VAT percentage is displayed in the cell Ε1. 1514 Use a Two-Variable Data Table to calculate in the cell range D7:J30 the VAT of the values appearing in the cell range C7:C30. VAT percentages are provided in the cell range D6:J6. The appropriate formula is provided in the cell B3. 1525 Navigate to the SALES worksheet located in the IL-ates1525 workbook of the IL-ates\Excel file on your desktop. Copy and paste the data included in the cell range Β20:J20 of the SALES worksheet in the cell range A1:Ι1 of the already opened workbook as link. 1526 Change the linked archive from IL-ates1526_1 to IL-ates1526_2. Both files are located in the IL-ates\Excel file on the desktop. 1555 Create two Scenarios with the following data: 1) Name: Min, changing cells: C5:C8, values: 5, 6, 10, 8 2) Name: Max, changing cells: C5:C8, values: 11, 12, 15, 10. Display the scenario Max. 1556 Create a scenario summary using the default values. 1560 Remove the SubTotals. 1566 Display the subtotal for the turnover appearing on the cell range A3:C19 at each change in Geographical Direction. Make sure there are page breaks between groups. 1853 Apply subtotals in the cell range A1:D201. 1854 Create a table in the cell range C3:H13 to multiply the values displayed in the cell range B3:B13 by the quantities displayed in the cell range C2:H2. 1859 Create a pivot table report beginning from the cell G5. The report will derive data from the cell range A1:D201 and will display the field Order date as row labels and the field Full name as column labels. Set the Sum of the field Quantity in Values area. 1862 Enter the data of the out1.txt file located in the IL-ates\Excel folder on your Desktop to a new workbook, using semicolon (;) as delimiter. Save the workbook as final.xlsx to the same folder. 1867 Navigate to the pivot table and apply grouping by Months on the column OrderDate. 1868 Navigate to the pivot table and apply the options required to display the total of quantities (count) instead of the Sum. 1869 Remove the field Description from the pivot table and apply the Currency format on the Values. 1870 Modify the worksheet to display the product's total price instead of Quantity in the pivot table (Do not use a calculated field, and do not move the pivot table). 1878 Apply the adjustments required in the subtotal structures so that only the total amount for each client and the Grand total are displayed. 1919 Ιn the Sheet1 worksheet, insert the following entries: Lambropoulos 75.00€ 109.75€ Goutoudis 45.00€ 65.85€ and update the pivot table in the Sheet2 worksheet. 1921 On the Sheet1 worksheet delete the scenario called Scenario1. 1922 Apply a validation rule in the cell B3 to allow only decimal numbers greater than 0. Insert the text Only numbers as Error Message. 1924 Make sure we navigate to the address www.infolearn.gr by clicking on the text appearing in the cell A1. Then delete the hyperlink of the cell A2 without deleting the text. 1925 Activate Track Changes in the document and Highlight changes for all users and all dates. Save the document. 1928 Reject all changes effectuated in the document by all users. 1929 Merge the active workbook with the merge file located in the IL-ates\Excel folder on your Desktop.