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