Excel Lesson 1 - 3
Terms in this set (...)
Located below the ribbon on the left. It displays the contents of the active cell.
Located below the ribbon on the left. It displays the address of the active cell.
The cell that is currently selected.
Separate documents within a workbook
An excel file
Located at the bottom of the Excel window and they identify individual worksheets. By default each workbook contains one worksheet tab.
Run vertically on a worksheet. Identifiable by letters. Each worksheet contains 16, 384.
Run horizontally across a worksheet. Identifiable by numbers. Each worksheet contains 1,048,576.
The intersection of a column and row.
A unique reference to each cell that is comprised of its column letter and row number (B2)
Places the insertion point at the end of the incorrect label.
Allows the rotation of the worksheet to Portrait or Landscape.
Feature that enters labels automatically if you have previously entered them in the same column.
Uses the fill handle to complete a series based on a pattern you establish.
Control + F2
Defines the area of the worksheet for print.
Cells that contain text or non-mathmatical symbols as the first character.
When a date or number is the first character in a cell.
Keyboard shortcut that opens an existing workbook.
Keyboard shortcut that creates a new workbook
Group of cells in a row, column or block
Keyboard shortcut that open the format cells dialog box.
Model worksheet design containing permanent worksheet settings.
A set of font, color and style formatting choices for an entire worksheet.
Defines a set of formats
Alt + =
Keyboard shortcut for AutoSum
The most efficient way to adjust column width. Execute this task by double clicking between the column heading letters.
Automatically enters a function to find the total of a group of cells. (=SUM(B4:B7)
Cuts or Moves
Counts the number of values in a range.
Copies number or text format.
Equations or instruction to calculate values on a worksheet. They always start with the = symbol.
A built in formula that perfoms a specific calculation automatically.
Calculates the highest value in a range.
Calculates the lowest value in a range.
Temporary storage location for cut/copy/past items
A feature that adds the selected numbers in a column.
How many columns on a worksheet?
How many rows in a worksheet?
Over a million
Means the column is too short. Use autofit.
Excel Chapter 1
Symmes EXCEL CH 1 Test Review
Combo with Excel Chapter 1 Key Terms Part 6 and 5 others
Combo with Excel Chapter 1 key terms Part 3 and 1 other
Internet Unit Terms - Part 1