Inserting the VLOOKUP
We want to create a histogram to show the distribution of volumes. You will need to start by getting the
Volume data you want to show on the dashboard.Bu egzersiz, kursun bir parçasıdır
Data Visualization in Google Sheets
Egzersiz talimatları
- In
F16, type in the heading "Volume". - In
F17, enter a formula that usesVLOOKUPto look at the date in columnAand returns theVolumefor that date from theASXTable. - Copy the calculation down the column from
F17toF26.
Uygulamalı etkileşimli egzersiz
Teoriyi etkileşime dönüştürün, interaktif egzersizlerimizden biriyle
Egzersize başla