1897

Modify the chart so that it looks identical to the chart appearing the Exercise.pdf file located in the IL-ates\Excel folder on your Desktop. The files you are going to need are located in the same folder.

1898

Derive data from the delimited.txt file located in the IL-ates\Excel folder on your Desktop and place them in cell A2. Sort the cell range A2:Â12 by Grade in descending order and apply conditional formatting in the cell range Â3:Â12 according to the data displayed in the cell range E3:F5.

1899

Create a new worksheet within the existing workbook so that it looks identical to the photo named Exercise.gif located in the IL-ates\Excel folder on your Desktop.

1900

Create two new worksheets in the existing workbook, so that they look identical to the ones of the following photos: Pivot.jpg and Scenario.jpg, located in the IL-ates\Excel folder on your Desktop.

1901

Use the data from the cars.csv file located in the IL-ates\Excel folder on your Desktop and perform the necessary actions on the already opened worksheet, so that the outcome looks identical to the one of the photo Picture.jpg located in the IL-ates\Excel folder on your Desktop.

1902

Perform any changes required in the already opened worksheet so that it looks identical to the one of the photo Picture.jpg located in the IL-ates\Excel folder on your Desktop.