36 terms

Microsoft Excel Basic Terms

There terms are all about Excel.
Grid of rows and columns in which you enter text, numbers, and the result of calculations
Computerized spreadsheet
File used to store worksheets
Appear vertically and are identified by letters at the top of the worksheet
Appear horizontally and are identified by numbers on the left side of the worksheet
Intersection of a row and column
Formula Bar
Displays a formula when the cell of a worksheet contains a calculated value
equation that calculates a new value from values currently in a worksheet
Portrait Orientation
Page turned so the shorter side is on top
Landscape Orientation
Page turned so the longer side is on top
Combine into one cell
Words hidden in a cell because they do not fit
Wrap Text
See all text stored in a cell
Collection of design elements, such as fonts, colors, and other effects
Number formats
Changes way data looks in cell
Format Painter
Allows you to copy formatting from one worksheet cell and paste it to other cells
Office Clipboard (Clipboard)
Temporary storage area for up to 24 selections you copy or cut
Copies cell's contents and/or formatting into another cell
Freeze Panes
Rows and columns visible in a worksheet as you scroll throughout the worksheet
Print area
Cells and ranges designated for printing
Shorthand way to write an equation that performs a calculation
Value the function uses to perform a calculation
Arranging the data in a more meaningful order
Ascending sort
Data with letters is arranged in alphabetical order (A to Z)
Descending sort
Data arranged with letters Z to A
Displays a subset of data that meets certain criteria and hides the rows that do not meet the criteria
Used to make page more attractive
SmartArt Graphic
Used to enhance worksheets by providing a visual representation of information and ideas
A picture of all or part of something you see on your monitor (taken by pressing the F14 button)
Predesigned workbook file that you can use as a basis or model
Reference that opens a Web page, a file, a specific location in the current workbook, a new document, or email
Note attached to a cell that you can use to explain or identify information contain in the cell
Research task pane
Provides access to information typically found in references such as dictionaries, thesauruses, and encyclopedias
Column chart
Uses bars of different heights to illustrate data
Line chart
Similar to column chart, but uses points connected by lines instead of bars
Pie chart
Shows relationships of parts as a whole