AE1

Adjacent

(adj) near, next to, adjoining.

Mathematical Operators

+ plus - minus *times /division

Currency

A format for numbers in Excel that will display $1,000,000

COUNT

A function that Counts how many cells in a cell range contain a number

MAX

A function that finds the largest number in a cell range

MIN

A function that finds the smallest number in a cell range

SUM

A function that will add all numbers in a cell range

Cell Range

A group of cells in a block. eg. A1:A4 is every cell from A1 to A4

Fill Handle

A small balck square in the bottom right hand corner of a cell. It is used to copy adjacent cells.

Priority

A thing that is regarded as more important than another.

AutoSum

A way to quickly add up all the numbers in a row or column by clicking on the empty cell.

Add Up

Addition of a set of numbers

Intersection

An intersection is a single cell where two lines meet or cross each other

Symbols

Anything that meaningfully represents something else

types of data

Excel has Three types of data; Text, Values, Formula

Column

From top to bottom

Format

How a value or label looks.

Formula

In excel starts with an = equals sign and is used to perform calculations.

Function

Special keywords you can use in a formula to perform particular tasks, eg. MAX MIN COUNT

Cell

The intersection of a column and a row is a cell

Cell Address / Cell Reference

The letter and number that represents a cell

Value

The number in a cell

Priority of Operators

The order in which operators are run in excel: BEDMAS () brackets, ^ Exponent/power , / division, * multiplication, + addition, - subtraction

Absolute Cell Reference

Used when you do not want a refrence to change when copying it to another location. Examples $a$1 $a1 a$1

label

Words used to describe what the number in a cell means

Spreadsheet

a grid of rows and columns containing numbers, text, and formulas

Row

from left to right