Excel Lesson 4

18 terms

Filter

to show only the parts that you need in a worksheet. Can be found in the "Data Tab"> "Sort and Filter Group".

Range

a group of cells, that you wish to filter.

Sort

to organize information; Excel can automatically do it for you. Found in the "Data Tab">"Sort and Filter" Group.

Operator

a symbol for mathematical operations (such as * for multiplication, + for addition, - for subtraction, and / for division). Can find them by pressing the "Insert Function" button.

Function

a preset formula from a list

Relative reference

changes when the formula is pasted into a new location.

Absolute reference

a locked cell that maintains a constant reference when copied to another location. You need dollar (\$) signs to make a reference absolute.

Mixed reference

a cell reference that is part relative and part absolute. It has either an absolute column and a relative row, or relative column and an absolute row

Chart

a graphic that organizes data visually so that you can compare different kinds of data or evaluate how data changes over time. Found in "Insert Tab">"Charts Group"

COUNT function

used to find the number of cells in a range that contain numerals. In the Sum drop-down list, it is called Count Numbers. "Home Tab">"Editing Group".

COUNTA function

used to find the number of cells in a range that contains any kind of data (both numbers and text). "Home Tab">"Editing Group".

NOW function

displays the date and time that a worksheet is opened or used.

PMT function

calculates the monthly payment for a loan using the amount of the loan, the interest rate, and the number of payments. Used to create and update your personal budget.

IF function

allows a worksheet to compare numbers.

a rule

Formula

an equation that performs a calculation. Every formula begins with an equal (=) sign.