to show only the parts that you need in a worksheet. Can be found in the "Data Tab"> "Sort and Filter Group".
a group of cells, that you wish to filter.
to organize information; Excel can automatically do it for you. Found in the "Data Tab">"Sort and Filter" Group.
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.
a preset formula from a list
changes when the formula is pasted into a new location.
a locked cell that maintains a constant reference when copied to another location. You need dollar ($) signs to make a reference absolute.
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
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"
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".
used to find the number of cells in a range that contains any kind of data (both numbers and text). "Home Tab">"Editing Group".
displays the date and time that a worksheet is opened or used.
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.
allows a worksheet to compare numbers.
an equation that performs a calculation. Every formula begins with an equal (=) sign.
to modify, the cell references accordingly in the new formula so it calculates correctly.
a variation of the original.