Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
33 Cards in this Set
- Front
- Back
|
active cell
|
A cell that is highlighted or outlined by a bold black line.
|
|
|
Backstage
|
. A view that enables you to easily navigate and customize different features that you frequently use in Excel
|
|
|
column
|
Cells that run from top to bottom on the grid and are identified by letters.
|
|
|
command tab.
|
Task-oriented tabs that are organized on the Ribbon.
|
|
|
cell.
|
A box on the grid identifi ed by the intersection of a column and a row
|
|
|
Dialog Box Launcher
|
An arrow in the lower-right corner of some command group headers in the Ribbon tabs
|
|
|
File tab
|
Displays a menu of basic commands for opening, saving, and printing files as well as more advanced options
|
|
|
Help system
|
A system in Excel 2010 that is rich in information, illustrations, and tips that can help users complete any task as they create a worksheet and workbook.
|
|
|
Hotkey
|
Another name for a Keytip.
|
|
|
Keytip
|
Small “badges” revealed by pressing and releasing the Alt key, which displays keyboard shortcuts for specifi c tabs and commands on the Ribbon and Quick Access Toolbar
|
|
|
Name box
|
Located below the Ribbon at the left end of the formula bar. When the user keys a cell location in this box and presses Enter, the cursor moves to that cell.
|
|
|
Quick Access Toolbar
|
A toolbar that permits fast and easy access to the tools a user employs most often in any given Excel session
|
|
|
Ribbon
|
A broad band that runs across the top of the window that organizes tools from the Menu toolbar into an easy-to-use interface.
|
|
|
row
|
Cells that run from left to right on the grid and are identified by numbers.
|
|
|
sceentip.
|
Small onscreen windows that display descriptive text when users rest the pointer on a command or control
|
|
|
workbook
|
A spreadsheet file
|
|
|
worksheet
|
Sheets similar to pages in a document or a book in which you can enter information
|
|
|
Group.
|
1. Information on each ribbon is organized in a collection
|
|
|
Truncated
|
4. Shortened or cut off
|
|
|
Range
|
6. A group of selected cells that may be formatted, moved, copied or deleted as a group
|
|
|
Copy
|
8. To replicate
|
|
|
Formula Bar
|
formulas to be entered or edited
|
|
|
Title Bar
|
11. The area of the Microsoft Excel 2010 window displays the name of the workbook that is active
|
|
|
Auto Complete
|
12. Microsoft Excel 2010 feature automatically inserts data into a cell that begins with the same characters as a previous entry
|
|
|
Auto Fill
|
13. Microsoft Excel 2010 feature automatically inserts words, numbers, or formulas that are a part of a series
|
|
|
Smart Tags
|
14. The name of the pop-ups that appear near the active cell
|
|
|
Cell Styles
|
15. A command is used on the Home ribbon to apply a style to selected cells in a workbook
|
|
|
Name Box
|
17. The area of the Microsoft Excel 2010 window that displays the cell address of the active cell
|
|
|
Delete Key
|
18. When entering data into a cell, this keyboard key is used to move characters to the right of the insertion point
|
|
|
Mixed Reference
|
19. When a formula contains references that allow both the address to adjust and the reference to remain constant, this type of reference considered
|
|
|
Windows Control Buttons
|
20. These commands are located in the upper right corner of the Microsoft Excel 2010 window to allow the user to minimize, maximize, or close the window
|
|
|
Status Bar
|
21. The area of the Microsoft Excel 2010 window that displays information about the worksheet and active cell, view buttons and the zoom buttons and the zoom slider bar
|
|
|
Home Ribbon
|
22. The command buttons to cut, copy, or paste items in Microsoft Excel 2010 are located on
|
