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