44 terms

Excel Lesson 1 - 3

STUDY
PLAY

Terms in this set (...)

Formula Bar
Located below the ribbon on the left. It displays the contents of the active cell.
Name Box
Located below the ribbon on the left. It displays the address of the active cell.
Active Cell
The cell that is currently selected.
Worksheet
Separate documents within a workbook
Workbook
An excel file
Sheet Tab
Located at the bottom of the Excel window and they identify individual worksheets. By default each workbook contains one worksheet tab.
Column
Run vertically on a worksheet. Identifiable by letters. Each worksheet contains 16, 384.
Row
Run horizontally across a worksheet. Identifiable by numbers. Each worksheet contains 1,048,576.
Cell
The intersection of a column and row.
Cell Address
A unique reference to each cell that is comprised of its column letter and row number (B2)
Edit Mode
Places the insertion point at the end of the incorrect label.
Orientation Button
Allows the rotation of the worksheet to Portrait or Landscape.
AutoComplete
Feature that enters labels automatically if you have previously entered them in the same column.
AutoFill
Uses the fill handle to complete a series based on a pattern you establish.
Control + F2
Print Preview
Print Area
Defines the area of the worksheet for print.
Label
Cells that contain text or non-mathmatical symbols as the first character.
Label Alignment
Left aligned
Value
When a date or number is the first character in a cell.
Value Alignment
Right-aligned
Control O
Keyboard shortcut that opens an existing workbook.
Control N
Keyboard shortcut that creates a new workbook
Range
Group of cells in a row, column or block
Control 1
Keyboard shortcut that open the format cells dialog box.
Template
Model worksheet design containing permanent worksheet settings.
Theme
A set of font, color and style formatting choices for an entire worksheet.
Cell Styles
Defines a set of formats
Alt + =
Keyboard shortcut for AutoSum
Autofit
The most efficient way to adjust column width. Execute this task by double clicking between the column heading letters.
AutoSum
Automatically enters a function to find the total of a group of cells. (=SUM(B4:B7)
Control V
Pastes
Control X
Cuts or Moves
Control C
Copies
Count
Counts the number of values in a range.
Format Painter
Copies number or text format.
Formula
Equations or instruction to calculate values on a worksheet. They always start with the = symbol.
Function
A built in formula that perfoms a specific calculation automatically.
MAX
Calculates the highest value in a range.
MIN
Calculates the lowest value in a range.
Office Clipboard
Temporary storage location for cut/copy/past items
SUM
A feature that adds the selected numbers in a column.
How many columns on a worksheet?
Over 16,000
How many rows in a worksheet?
Over a million
#####
Means the column is too short. Use autofit.