Basic Formulas Assessment

Create a Drop Down Box in C5 that allows me to pick an NBA player. Then write formulas that return the selected player’s 3P, PTS, and Blocks.

This is the file needed to answer question 1: Basic Lookup Q1

My income in Year 1 is $80,000. I will work for 35 years and then retire. Assume  all income is received at the beginning of the year. Then I consume from my income and compute my cash position. All my cash earns the return on savings given below.

Annual Income Growth 5%

Annual Return on Savings 10%

Fraction of Income Consumed 90%

How much money will I have at end of year 35? Your spreadsheet must work if I change information in C7:C9. I filled in years 1 and 2, but you need formulas.

This is the file needed to answer question 2: Basic Lookup Q2

Use one formula involving MATCH and INDEX that can be copied from R8 to T22 that lookups the appropriate information for each QB.

This is the file needed to answer this question: Basic Lookup Q3