Question: how do you create a structured reference formula in excel?
Answer: Select cell E1, type Bonus, and press Enter. Excel automatically formats the column for you.
Select cell E2 and type =0.02*[
A list of structured references (the columns) appears. ... 
Close with a square bracket and press Enter. ... 
First, select a cell inside the table. ... 
Select cell E18 and enter the formula shown below.