Excel

Wrap Text

A formatting technique that allows you to keep the data you enter confined to one cell; accessed through the Home Tab, alignment section.

Worksheet

A worksheet consists of up to 256 vertical columns and 65,535 horizontal rows. A work area for calculating data, made up of columns and rows separated by grid lines.

Ctrl+G or F5

Keyboard shortcut to change active cell

Ctrl+N

Keyboard shortcut to create a new blank workbook

Insert another worksheet

Shift+F11

Row

There are 1.048,576 horizontal rows in a worksheet. They are numbered 1,2,3..

Column

There are 16,384 vertical columns in a worksheet. They are identified by a letter (A,B,C...). The 27th column is AA, the 28th column is AB, and so on through IV.

Sort

To re-arrange the order of rows, based upon the content of the cells in a column. For example, label data may be sorted alphabetically; numbers may be sorted high-to-low or low-to-high

Ctrl+Z

Undo last action

Theme

a collection of coordinated fonts, colors, and effects for graphic elements such as charts and images that can be quickly applied to all sheets in a workbook

Chart

a graphic that allows you to compare and contrast data in a visual format

Value

a number entered in the worksheet

Template

a pre-desinged or semi-completed document that you can use to create a new document, without starting from scratch

Function

a predefined formula that performs calculations by using specific values

Label

a text entry in a cell, used to identify what you numbers mean.

AutoSum

adds columns of numbers

Spreadsheet

also known as a worksheet. A program that allows you to store numeric data, make calculations, and generate graphs to interpret data. A spreadsheet is a grid composed of rows and columns that intersect for form cells.

Workbook

an Excel file is called a workbook. By default, a workbook contains three worksheet tabs or pages.

Formula

an instruction Excel uses to calculate a new result based upon the numeric data entered in specified cells. An equation that begins with and equal sign (=) and indicates values or cell referneces

Name Box

displays the location of the current active cell; located at the left end of the Formula Bar

AutoFilter

filtering allows you to control what rows you see in your worksheet. This feature is accessed through Data on the Menu Bar

X Axis

horizontal axis on a chart

Ctrl+Spacebar

keyboard shortcut to select entire column

Shift+Spacebar

keyboard shortcut to select entire row

Shift+Arrow Keys

keyboard shortcut to select range of adjacent cells

Sheet Tabs

located at the bottom of a worksheet, the sheet tabs indicates which worksheet is currently active. The default number of sheet tabs in a new file is three. Sheet tabs allow you to move from one worksheet to another

Cell Name Box

located in the Formula bar, this box indicates which cell is currently active, or selected to receive data.

Formula Bar

located right below the ribbon and is divided into 3 sections, the name box (cell address), the formula bar buttons and cell contents. As you enter data into an active cell, it appears in the Formula Bar (cell contents section); located above the worksheet. Can be used to enter and edit cell data.

Numbers

numeric data entered into a cell

Active Cell

the cell with the black border; data can only be entered in the active cell

Cell Reference

the column letter and row number that identify a cell's location in the worksheet; cell name (for example-A1)

Cell

the intersection of a column and a row on a worksheet. You enter data into cells to create a worksheet.

Fill Handle

the small black square that appears in the lower-right corner of the active cell. It may be used to duplicate labels, numbers, and formulas into adjacent cells by clicking and dragging

Default

the standard settings used in the software, such as column width or number of worksheets in a workbook

Format

to apply attributes to cell data to change the appearance of the worksheet

Y Axis vertical axis on a chart

vertical axis on a chart