Dashboards

Question 1

Adding a range name

Answer 1

Select range, then enter the name in the name box
Or select an array and under formula tab select create from selection.
Use name manager to edit

Question 2

Add developer tab

Answer 2

Access macros and form controls.
Insert (button you can attach to a macro) check box, combo box returns numeric value of position, list box, radio button, labels)

Question 3

Active x

Answer 3

Form controls with vba

Question 4

Look up feature in a dashboard

Answer 4

Use a combo box to create a drop down to select that field. Then reference that cell in your lookup function.

Question 5

Index()

Answer 5

A look up function: index looks in a data range
Index(array or reference, row number, column number)