Modify the default save intervals if necessary.
Cells, Ranges, and References
Each cell is referenced by its intersecting column (letter) and
e.g. cell A1 is the topmost left cell in the spreadsheet.
The cell reference is shown in the name box beside the formula bar.
A range is a rectangular group of cells in a worksheet:
can be one single cell or may be entire worksheet.
Selecting a range:
Click and hold left mouse button and drag from beginning of range to end
Select first cell, then hold the Shift key while clicking the last cell
Can consist of contiguous (together) or non-contiguous (not
Hold the Ctrl key to select non-contiguous ranges.
A contiguous range of cells is referenced by the top left cell
reference and the bottom right cell reference:
Entering & Editing Data
Entering Data in Cells:
Text, Numbers, Formulas can be entered either directly in each cell or through the
Editing Data in Cells:
Data in cells can be modified using one of three ways:
•Selecting the cell you want to edit, clicking the Formula Bar, making changes,
pressing Enter or the Check symbol.
•Double clicking the cell to be edited, making the changes, pressing Enter
•Selecting the cell, pressing the F2 key, making the changes, pressing Enter
Used to repetitively copy contents of one cell or a range of cells.
Used to complete a sequence, pattern or lists like numbers, increments, months
Enables you to copy or continue the content of a cell or a range of cells to its
adjacent cells (below or to the right).
Select a cell or range of cells to be copied or continued,
Drag the “fill handle” over an adjacent cell or range of cells
•The fill handle is a small black square appearing in the bottom-right corner of
•You can define your own custom lists in Excel to give more power to the
•Use the Excel Options control in the backstage view and look under Advanced
è Edit Custom Lists.
ADM1370 QUIZ #2