AFM 112 chp 10

Question 1

what are the basic steps to develop a dashboard

Answer 1

1. start with the outcome in mind and think backward
2. think about the data you will use to create the dashboard
3. first, get the data ready to use
4. then build the dashboard’s tables/graphs

Question 2

whats the Vlookup function

Answer 2

VLOOKUP(search_key, range, index, is_sorted)