Excel Vocab
Wrap text
A formating technique that allows you to keep the data you enter confined to one cell; accessed through the Home tab, alignment section.
SHIFT + F11
Insert another worksheet
row
There are 1,048,576 horizontal ____ in a worksheet. They are numbered 1, 2,3,...
column
There are 16,384 vertical ________ in a worksheet. They are identified by a letter (A,B,C,...). The 27th ______ is AA, the 28th ______ 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 (your best friend)
Y axis
Vertical axis on a chart
theme
a collection of coordinate 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 fomat
value
a number entered in the worksheet
template
a pre-designed 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 your 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 graphics to interpret data. A grid composed of rows and columns that intersect to form cells.
workbook
an Excel file is called a _______. By default, a ______ contains three worksheet tabs or pages.
formula
an instruction Excel uses to calculate a new result based upon the numeric data entered in specific cells. An equation that begins with an equal sign (=) and indicates values or cell references.
CTRL + G
change active cell
F5
change active cell
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 gridlines.
CTRL + N
create a new, blank workbook
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
sheet tabs
located at the bottom of a worksheet, the ______ indicates which worksheet is currently active. The default number of _____ in a new file is three. ______ 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 recieve 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
CTRL + Spacebar
select entire column
SHIFT + Spacebar
select entire row
SHIFT + Arrow keys
select range of adjacent cells
active cell
the cell with the black border; data can only be entered in the ______
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 setting used in software, such as a column width or number of worksheets in a workbook
format
to apply attributes to cell data to change the appearance of the worksheet
