Combo with Excel Chapter 1 key terms Part 3 and 1 other

STUDY
PLAY

Terms in this set (...)

In-Ribbon Gallery
Shows common gallery choices on the ribbon rather than in a drop down list
Task pane
Similar to a dialog box, this is a window that can remain open and visible while you work in the worksheet instead of having to be closed before you return to the worksheet
Formula bar
A bar that appears below the ribbon and displays your cell entry(s) as you type
Name box
Located on the left side of the of the formula bar, this displays the active cell reference (the cell which you are currently using)
Select a cell
To make the cell active
Text
Consists of any set of characters containing a letter, a hyphen, or a space
Row Content
Rows typically contain information that is similar to items in a list
Column Content
Columns typically contain descriptive information about items in rows or contain information that helps to group the data in the worksheet
Characters
Letters, numbers, punctuation marks, and symbols
Value
A numeric entry in an excel worksheet
Formula
A cell entry that performs calculations
Range
A series of two or more adjacent cells in a column or row or rectangle group of cells
SUM Function
Adds all of the numbers in a range of cells
Marquee
The flashing border that appears around a group of cells that have been selected to be summed (added)
Label
A text entry in an excel worksheet
Block Arrow
The shape of the mouse pointer whenever the mouse pointer is moved outside the worksheet or when you drag cell contents between rows or columns
Worksheet Window
The portion of the worksheet displayed on the screen
Normal view
The default (preset) view in Excel
Status Bar
Presents information about the worksheet and is located immediately above the windows taskbar at the bottom of the screen
Mode Indicators
On the status bar, this specifies the current mode of Excel, such as ENTER or READY
Ready Mode Indicator
Indicates that Excel is ready to accept the next command or data entry
Enter Mode Indicator
Indicates that Excel is in the process of accepting data through the keyboard into the active cell
Keyboard Indicators
Appear to the right of the mode indicator and shows which toggle keys are engaged (for example:Scroll Lock)
Ribbon
Consisting of tabs, groups, and commands, and is located near the top of the Excel window
Top Level Tab
Located on the ribbon, each tab surrounds a collection of groups
Group
Found on the ribbon, this is a collection of related commands
Home Tab
Also known as the primary tab, contains the more frequently used commands
Active Tab
The tab that is currently displayed
Contextual Tabs
Tabs that are displayed only when you work with certain tasks or objects such as charts or tables
Gallery
A set of choices, often graphical, arranged in a grid or in a list
Excel 2007(Excel)
A spread sheet program that allows users to organize data, complete calculations, make decisions, graph data, and develop professional looking reports
Worksheet
Page in an Excel workbook organized in vertical columns and horizontal rows
Spreadsheet
Another name for worksheet
Workbook
A collection of worksheets
Tables
Used to organize and store data within worksheets
Column
A vertical line of cells identified by an alphabetical label at the top of the column
Row
A horizontal line of cells indentified by a row number at the left end of the row
Column Heading
A column letter above the left side of the grid that identifies each column
Row Heading
A row number on the left side of the grid that identifies each row
Cell
The intersection of a row and a column
Active cell
The cell that is currently selected or being used
Cell reference
The coordinates of the intersection of a column and row, with the column letter first and the row number last
Gridlines
The horizontal and vertical lines on the actual worksheet
Worksheet Size
Each sheet can have over 16 thousand columns and over 1 million rows for a total of over 17 billion cells
Block plus sign
The shape of the mouse pointer whenever the mouse pointer is located in a cell