#### 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!

Loading...

Media is loading

#### 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