Formulas & Functions
This button allows you to find and build formulas and functions.
Fx
OR
Insert Function
This is information that appears when you click on a cell; it usually tells you what should be entered into the cell.
Input Message
An amount of money given to the borrower for a set period of time. After the set time has passed, the money must be paid back plus the lending fee, called interest. Payments are normally made over a series of months.
Loan
How do you change the result of the PMT formula from a negative number to a positive number?
Put a dash between the equal sign and the PMT in the formula.
This is always required when using a Sumif or Sumifs formula.
Numbers
This formula performs a vertical lookup by searching for a value in the first column of a table and returning the corresponding value in the column that you specify.
VLookup
This tool puts a circle around data that does not meet the rules set for entering data.
Circle Invalid Data
A group of cells
Range
Where is the best place to fix an error in a formula?
In the argument window
What type of formula is an IF formula?
Logical
OR
Conditional
This is the range of data that a lookup formula uses to find a specific piece of data.
Table Array
Rules that limit the type of data that can be entered in a cell.
Data Validation
Percentage of amount borrowed to be added to the amount loaned and paid back.
Interest Rate
When using the PMT formula, you always divide this by 12.
Interest Rate
Which formula should you use to solve this problem: How many shipments of iPads went to New York?
Countifs
Open a new blank workbook in Excel then write a formula that will combine the contents of cells A1 and A2, use a hyphen to separate the data.
=CONCATENATE(A1,"-",A2)
Use this tool to keep a portion of the worksheet visable wherever you scroll.
Freeze Panes
The place in an Excel formula where you add the data that the formula is based on.
Argument Window
When using the "Text to Columns" tool, what is the very first thing that you need to do?
Make sure you have space in your worksheet
What tool do you need to use when updating data in a pivot table or a pivot chart?
Refresh
OR
Refresh All
Open a new blank worksheet in excel, then write a formula that will calculate the monthly payment for a $17,000 loan payed back over 5 years at an interest rate of 3.5%
$309
OR
=PMT(3.5%/12,60,17000)
OR
=PMT(H5/12,H3,H4)
This tool splits a single column of text into multiple columns of text.
Text To Columns
To join or link things together.
Concatenate
When building a formula, it's best to use these instead of just typing in the information.
Cell References
List 2 differences between a regular Excel Chart and an Excel Pivot Chart.
You don't need to highlight data to build the chart
A pivot chart comes with filtering tools
Pivot chart contextual tabs include Analyze, Design, and Format, a regular chart only has Design and Format.