Excel Flashcards
Name Box
displays the cell reference of the active cell
Formula Bar
displays the value or formula entered into the active cell
Row Headings
Numbers along the left side of the workbook window that identify the different rows of the worksheet
Spreadsheet
Grouping of text and numbers in a rectangular grid or table
Workbook
Excel documents are called workbooks
Template
Preformatted workbook with many design features and some content already filled idn.
Keyboard Shortcut
Key or combination of keys that you press to access a feature or perform a command.
ScreenTip
A box with descriptive text about a command that appears when you point to a button on the ribbon
CTRL V
Paste
CTRL A
Close current workbook
CTRL X
Cut
CTRL Y
Repeat last command
CTRL Z
Undo last command
F1
Open Help window
F5
Go to a location in the workbook
F12
Save the current workbook with a new name or to a new location
ALT
Display the key tips for the commands and tools on the ribbon
CTRL A
Select All
CTRL C
Copy
CTRL G
Go to a new location
CTRL N
Open new
CTRL P
CTRL S
Save
Key Tips
Labels that appear over each tab and command on the ribbon
Sheets
Workbooks are organized into seperate pages called sheets. There are two types: Worksheets and Chart Sheets.
Worksheet
Contains a grid of rows and columns in which you can enter text, numbers, dates, and formulas and display charts
Chart Sheet
Contains a chart that provides a visual representation of worksheet data.
Cell Reference
Indicates the column and row in which the cell is located.
Cell References Appearance
The column letter always appears before the row number in any cell reference.
Active Cell
The cell that is currently selected in the worksheet
HOME
To column A of the current row
CTRL HOME
To cell A1
CTRL END
To the last cell in the worksheet that contains data
Enter
Down one row or to the start of the next row of data
Shift+Enter
Up one Row