Access database tables cannot be imported into Excel.

What is a lookup table used for?

Please download the attached Mortgage Calculator.xlsx and save it as Mortgage Calculator_YOURNAME.xlsx. Add formulas to compute the values for the cells highlighted in yellow color. You can use the previous assignments as references. Attach your completed solution file to this question.  

Which of the following is NOT one of most commonly used chart types?

Which of the following is NOT true about PivotTables?

A bar chart:

The UPPER function will capitalize every character of a text string.

To begin a formula in a cell, first type the # symbol.

In order for the OR function to return a true value, one or more arguments must be true.

A chart is: