Title
1 - Visualizing Wealth and Personal Finance
Files
Download Visualizing Wealth and Personal Finance Quiz 1 ANSWERS.pdf (105 KB)
Description
This section focuses on the power of investment and demonstrates how interest can make funds grow exponentially!
Error loading player: No playable sources found
Publication Date
Spring 2020
City
New Orleans
Recommended Citation
Saltzman, Alexander, "1 - Visualizing Wealth and Personal Finance" (2020). Data Visualization Lab Videos. 6.
https://digitalcommons.xula.edu/data_instruct/6
Comments
=== Self-quiz: (See attachment for answers) ===
Q1: if we want to put 6% into google sheets, which of the following can we write?
a) 6%
b) 0.06
c) =6/100
d) All of the above will work
Q2: To put a formula (calculation) into a cell, what character do we need to begin with?
a) “
b) =
c) F
d) No character needed
Q3: To get the total value of $1000 after 1 year at 9% interest, what calculation should we make?
a) 1000*9
b) 1000*0.09
c) 1000*1.09
d) 1000*(1+9)
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