1 - Visualizing Wealth and Personal Finance
Download Visualizing Wealth and Personal Finance Quiz 1 ANSWERS.pdf (105 KB)
This section focuses on the power of investment and demonstrates how interest can make funds grow exponentially!
Media is loading
Saltzman, Alexander, "1 - Visualizing Wealth and Personal Finance" (2020). Data Visualization Lab Videos. 6.
=== Self-quiz: (See attachment for answers) ===
Q1: if we want to put 6% into google sheets, which of the following can we write?
d) All of the above will work
Q2: To put a formula (calculation) into a cell, what character do we need to begin with?
d) No character needed
Q3: To get the total value of $1000 after 1 year at 9% interest, what calculation should we make?
Q4: Assuming a positive interest rate, which of the following will yield better results?
a) Investing $100 per month every year for 10 years
b) Investing $200 per month every year for 5 years, then $0 per month for 5 more years (i.e. interest growth only)
Q5: What is a big advantage of using formulas to reference cells within a spreadsheet?
a) We can copy-paste the formula in the cell below and Google Sheets will know to reference cells that are also a cell below
b) Modifying older cells will update our formulas