36 terms

Microsoft Excel Basic Terms

There terms are all about Excel.
STUDY
PLAY
Spreadsheet
Grid of rows and columns in which you enter text, numbers, and the result of calculations
Worksheet
Computerized spreadsheet
Workbook
File used to store worksheets
Columns
Appear vertically and are identified by letters at the top of the worksheet
Rows
Appear horizontally and are identified by numbers on the left side of the worksheet
Cell
Intersection of a row and column
Formula Bar
Displays a formula when the cell of a worksheet contains a calculated value
Formula
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
Merge
Combine into one cell
Truncated
Words hidden in a cell because they do not fit
Wrap Text
See all text stored in a cell
Theme
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
Filling
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
Function
Shorthand way to write an equation that performs a calculation
Argument
Value the function uses to perform a calculation
Sorting
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
Filtering
Displays a subset of data that meets certain criteria and hides the rows that do not meet the criteria
Shapes
Used to make page more attractive
SmartArt Graphic
Used to enhance worksheets by providing a visual representation of information and ideas
Screenshot
A picture of all or part of something you see on your monitor (taken by pressing the F14 button)
Template
Predesigned workbook file that you can use as a basis or model
Hyperlink
Reference that opens a Web page, a file, a specific location in the current workbook, a new document, or email
Comment
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