Setting up your worksheet with formulas of reference

In this next task, you will showcase only the data you want to chart using formulas of reference to extract the top 3 countries' medal tallies from the dataset and show them in the dashboard.

Diese Übung ist Teil des Kurses

<Kurs>Datenvisualisierung in Google Sheets</Kurs>

Übungsanweisungen

Create a formula of reference in cell A1 that shows the contents of A1 in the Olympics sheet.
Copy the calculation down and across the sheet to show all data for the first 3 ranked countries.
Make sure column B is wide enough to see the entire country name.

Interaktive praktische Übung

Verwandle Theorie mit einer unserer interaktiven Übungen in die Praxis