Combo with Excel Chapter 1 Key Terms Part 6 and 5 others

STUDY
PLAY

Terms in this set (...)

X-axis
The horizontal (left and right) axis on a chart: also called the Category axis
Z-axis
On a 3-D chart, the Y-axis becomes this axis: indicating depth
Chart
A visual representation of a table
Snaps
Refers to the action that occurs when you hold down the ALT key down and drag chart and the edge of the chart area aligns (snaps) to the worksheet gridlines
Legend
Identifies what specific areas of colors in a chart are
Auto Calculate area
Located on the status bar, provides you with the tools to obtain information about the numbers in a range
AVERAGE
Auto Calculate shortcut command that displays the average of the numbers in the selected range
COUNT
Auto Calculate shortcut command that displays the number of non-blank cells in the selected range
NUMERICAL COUNT
Auto Calculate shortcut command that displays the number of cells containing numbers in the selected range
MAXIMUM
Auto Calculate shortcut command that displays the highest value in the selected range
MINIMUM
Auto Calculate shortcut command that displays the lowest value in the selected range
SUM
Auto Calculate shortcut that displays the total of the numbers in the selected range
In-Cell Editing
The process of selecting a cell and editing the contents of the cell
Ascending Sort
A sort order that sorts values from A to Z and number values from 1 to 10
Descending Sort
A sort order that values from Z to A and number values from 10 to 1
Splitting a merged cell
The process of unmerging or splitting a merged cell
Account Number Format
Causes The cells to display with two so that the decimal places in cells align vertically
Comma Style Format
Causes the cells to display with two decimal places and commas as thousands separators
ALT+PAGE DOWN
selects the cell one worksheet window to the right and moves the worksheet window accordingly
ALT+PAGE UP
Keyboard command that selects the cell one worksheet window to the left and moves the worksheet window accordingly
ARROW
Keyboard command that selects the adjacent cell in the direction of the arrow key
CTRL+HOME
Keyboard command that selects cell A1 or the cell one column and one row below to the right of frozen titles and moves the worksheet window accordingly
Home
Keyboard command that selects the cell at the beginning of the row that contains the active cell and moves the worksheet window accordingly
NAME BOX
Keyboard command that selects the cell in the workbook that corresponds to the cell reference you enter in the NAME BOX
PAGE DOWN
Keyboard command that selects the cell DOWN one worksheet window from the active cell and moves the worksheet window accordingly
PAGE UP
Keyboard command that selects the cell UP one worksheet window from the active cell and moves the worksheet window accordingly
Column Chart
A good way to compare values side-by-side
Clustered Column Chart
A good way to compare values across categories
Embedded Chart
A chart that is drawn on the same worksheet as the data used to create the chart
Y-axis
The vertical (up and down) axis on a chart; also called the Value axis
Source area/Copy area
The cell or range of cells that are being copied
Destination area/Paste area
The cell or range of cells receiving the copy from the source area
Relative Reference
Cell reference in a formula that automatically adjusts to the new location when you copy the formula to another cell or range
Absolute Reference
A cell reference in a formula that does not change when you copy the formula to another cell or range
Fill Handle
The small, black square located in the lower-right corner of a selected cell or range that you can use to copy a value or formula to adjacent cells
Auto Fill Option Button
Allows you to choose whether you want to copy the values from the source area to the destination area with formatting, without formatting, or copy only the format
File
A saved workbook
File Name
The name assigned to a file when it is saved
Book 1
The default workbook name excel assigns to a saved workbook
Format
Modify the appearance of text and numeric entries on a worksheet
Calibri
The preset font type of an excel workbook
Theme
A collection of cell styles having common characteristics, such as font type and color scheme
Office Theme
The default workbook theme in excel
Merging Cells
The process of creating a single cell by combining two or more cells
Merge and Center
The process of merging cells and centering the data in the cells
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