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