Title

1 - Visualizing Wealth and Personal Finance

Authors

Alexander SaltzmanFollow

Files

Description

This section focuses on the power of investment and demonstrates how interest can make funds grow exponentially!

Publication Date

Spring 2020

City

New Orleans

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

Recommended Citation

Saltzman, Alexander, "1 - Visualizing Wealth and Personal Finance" (2020). Data Visualization Lab Videos. 6.
https://digitalcommons.xula.edu/data_instruct/6