Shared Flashcard Set

Details

Microsoft Excel Review Cards
Review for your test here
23
Business
Not Applicable
04/03/2009

Additional Business Flashcards

 


 

Cards

Term
Name box
Definition
Displays the active cell address
Term
Formula bar
Definition
Allows you to enter or edit data in the worksheet
Term
Cell
Definition
The intersection of a column and a row
Term
Cell address
Definition
The coordinates of the intersecting column and row
Term
Cell pointer
Definition
Dark rectangle that outlines the cell in which you are working
Term
Active Cell
Definition
The cell in which you are working
Term
Sheet tabs
Definition
Located at the bottom of the worksheet, these allow you to switch from sheet to sheet in a workbook
Term
Worksheet
Definition
Electronic spreadsheet
Term
Workbook
Definition
Contains worksheets; in Excel 2007, the file extension is .xlsx
Term
Status bar
Definition
Located at the bottom of the Excel window; provides a brief description of the active command
Term
Function
Definition
Built-in formula
Term
Values
Definition
Numbers, formulas, and functions that can be used in calculations
Term
Page layout view
Definition
Provides a more accurate view of how the worksheet will look when printed
Term
Complex formula
Definition
Uses more than one aritmetic operator
Term
Relative cell reference
Definition
Results will reflect the NEW formula location
Term
Absolute cell reference
Definition
Reference DOES NOT change when you copy the formula; place a "$" before and after the letter of the cell that does not change
Term
Conditional formatting
Definition
When Excel automatically applies different formats depending on conditions you specify
Term
Max number of sheets
Definition
255
Term
Charts
Definition
Present information in a pictorial format
Term
Horizontal axis
Definition
X-axis or category axis
Term
Vertical axis
Definition
Y-axis or value axis
Term
Plot area
Definition
Area inside the horizontal and vertical axes
Term
Data series
Definition
A collection of related data points
Supporting users have an ad free experience!