Vocabulary Study Sheet Spreadsheet

Sort

To arrange information by kinds or classes, or in a particular order. “Sort” is a command that may be used in spreadsheet or database programs

Formula

An equation which will perform a mathematical calculation in a spreadsheet

Cell

The space on a spreadsheet where a column and row intersect

Function

A pre-defined formula that allows you to quickly perform a more difficult operation

Column

A vertical set of cells in a spreadsheet

Column Width

The horizontal size of a spreadsheet column

Delete Cells

To remove cells entirely from a spreadsheet

Fill Down

A command used to copy and paste formulas many times down a spreadsheet column

Fill Right

A command used to copy and paste formulas many times to the right of a spreadsheet row

Formula

An expression used to return a specific value to a spreadsheet cell or database field

Insert Cells

A command used to add a row/column to a spreadsheet in a particular place

Number Format

A command used to make numbers appear with a certain format (I.e. commas, dollar signs, fixed decimals, percents, etc.)

Operators (numeric)

The basic math functions (+,-,*,/) used in formulas

Row

A horizontal set of cells in a spreadsheet

Row Height

The vertical size of a spreadsheet row

Formula Bar

The area of a spreadsheet where a cell's content is input or edited

Chart

A graphical object created with numbers from a spreadsheet