Formulas
Practice Problems
Tables
Tools
Other
100

The formula for simple interest 

What is S=P+PxRxT?

100

Simple Interest: If you finance a $25,000 car at a 6% interest rate for five years, how much interest will you pay? 

What is $7500?

100

How does the border option look like? 

What is a square cut up into four pieces? 

100

The option which makes all words and letters in a cell fit together 

What is wrap text or column adjustment? 

100

Is retirement important? 

What is yes? 

200

The formula for compound interest 

What is A=P(1+r)^nt? 

200

Simple Interest: If you finance a $27,000 car at a 3.5% interest rate for 5 years, how much interest will you pay?

What is $4,725?

200

What is the name of the option for standard borders? 

What is all borders? 

200

The option which centers your text in a cell 

What is middle alignment and center text? 

200

Does your CA have a dog 

What is yes? 

300

The formula for monthly deposit 

What is A=D[(1+R)^t-1]/r ?

300

Compound Interest: 

Determine the future value of an investment with the following information: 

Principal: $7,500 APR: 7% Time: 10 years Compounding: quarterly

What is $15,011.98? 

300

What does the option for coloring a cell look like? 

What is a paint bucket tipping over? 

300

The option which allows you to change your unit in a cell to money

What is $option? 

300

What type of dog does your CA have? 

What is yorkie? 

400

The formula for monthly annuity yield 

What is Y=Nr(1+R)^t/(1+R)^t-1?

400

Compound Interest: 

Determine the future value of an investment with the following information: 

Principal: $2,500 APR: 6% Time: 8 years Compounding: monthly 

What is $4,035.36? 

400

How can you highlight multiple cells in a table 

What is fat plus click and hold? 

400

The option which allows you to make an absolute cell reference 

What is $ before letter and $ before number? 
400

How much does professor Ryan make a year? 

What is $51,500? 

500

What must every formula start with? 

What is =?

500

Nest Egg: 

If someone deposited $1500 into a retirement account with a 4% APR for 40 years, how much would the end balance be?

What is $1,772,942.01? 

500
How do you lower a formula to other cells? 

What is skinny plus drag and drop? 

500

The option which allows you to take away the borders of cells. 

What is merge and center? 

500

What is your CA's middle name 

What is Alejandro? 

M
e
n
u