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 folder 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.

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 quantity for each client and the Grand total are displayed.

1919

Ιn the Sheet1 worksheet, insert the following entries:

Lambropoulos 75.00109.75
Goutoudis
45.0065.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.