CIS034 Chapter 2

This Excel feature allows you to view totals, averages, or other statistical information without creating a formula:

It is important to remember that Excel calculates these operations before any others are performed:

The Excel tool button that allows you to step through each part of a formula is called:

This function calculates payment amounts when the borrower makes regular payments and the loan has a fixed interest rate

This function evaluates a specified condition or and returns one value if the condition or statement is true and anot

Excel comes with many built-in formulas called:

This type of cell reference does not change when copied and remains in a fixed position during operations:

The color-coded tool that applies different colors to each cell or cell range included within a formula is called the:

When you are creating formulas using a cell location, the default cell reference is:

A shortcut that turns a cell address in a formula into an absolute cell reference, adding the dollar sign ($) is:

When a formula contains a typo, missing punctuation, incorrect order of arguments, or an incorrect reference it returns:

To reference cells in another worksheet, but in the same workbook in which the current formula resides, use a:

In Excel, the acronym “Please Excuse My Dear Aunt Sally” helps the user remember:

This symbol alerts Excel that you are entering a formula and not text:

This Excel feature allows users to use common arithmetic operations to perform a calculation: