How can we help?

You can also find more resources in our Help Center.

Bst terms part 1, 2 and 3

STUDY
PLAY
Excel 2007
a spreadsheet program that allows users to organize data, complete calculations, make decisions, graph data, and develop professional looking reports
Worksheet
a 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 alphabetic label at the top of the column
Row
a horizontal line of cells identified by a row number at the left end of the row
Column headings
a column letter above the grid that identifies each column
Row headings
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 on the actual worksheet
Worksheet size
each worksheet can have over 16 thousand (16,384) columns and over 1 million (1,048,576) rows for a total of over 17 billion (17,179,869,180) cells
Block plus sign
the shape of the mouse pointer whenever the mouse pointer is located in a cell
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 info 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 only displayed when you work with certain tasks or object such as charts or tables
Gallery
a set of choices, often graphical, arranged in a grid or list
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 than can remain open and visible while you work in the worksheet instead f 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 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, hyphen, or a space
Row content
rows 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
Label
a text entry in an Excel worksheet
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 a 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)
Column content
columns typically contain descriptive information about items in rows or contain information that helps to group the data in the worksheet