stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Excel Lessons 5-10 Flashcards | StudBud
Explore
/
Excel Lessons 5-10
Excel Lessons 5-10
20 terms
·
StudBud Administration
·
41 plays
Intro to Excel 2010 Lessons 5-10
Flashcards
20 cards
F
Practice quiz
P
Host live
L
Questions
20
Answers
1
A button in a dialog box that you click to downsize a dialog box to make a selection.
contiguous range
collapse dialog box button
range
noncontiguous range
2
The order in which Excel performs the mathematical operations specified in a formula
order of precedence
formula
arithmetic operators
SUM function
3
Cells in a worksheet that act as a block, but are not necessarily adjacent to each other.
collapse dialog box button
noncontiguous range
range
contiguous range
4
A command that enables you to display the formulas in a worksheet so that you can check them.
show formulas
drag and drop
clipboard
cut
5
A graphical representation of data that enables you to identify comparisons and trends.
cut
chart sheet
chart
show formulas
6
A graphical representation of data that enables you to identify comparisons and trends.
chart sheet
cut
chart
show formulas
7
A sheet that contains a chart only.
cut
chart
show formulas
chart sheet
8
An instruction Excel uses to calculate a result.
arithmetic operators
SUM function
formula
order of precedence
9
A built-in calculation used to add a range of values together.
formula
order of precedence
arithmetic operators
SUM function
10
The command used to remove data from a cell or range of cells and place it on the Clipboard
show formulas
drag and drop
cut
clipboard
11
Where data or graphics are held prior to copying/pasting into another location.
show formulas
drag and drop
absolute reference
clipboard
12
The default chart type that displays each data point as a vertical column.
chart sheet
chart
cut
column chart
13
A block of cells in an Excel worksheet.
noncontiguous range
range
contiguous range
collapse dialog box button
14
A tool that enables you to copy formatting from a cell and apply it to another cell or range.
format painter
clipboard
show formulas
drag and drop
15
Symbols used in mathematical operations.
arithmetic operators
order of precedence
formula
SUM function
16
A block of adjacent cells in a worksheet.
collapse dialog box button
noncontiguous range
contiguous range
range
17
The command used to place a copy of data from the selected cell or range on the Clipboard.
drag and drop
show formulas
absolute reference
copy
18
The command used to place data from the Clipboard to a location on the worksheet.
clipboard
show formulas
format painter
paste
19
A method used to move or copy a range of cells by dragging the border of a selection
clipboard
drag and drop
cut
show formulas
20
A cell address in a formula that will not change when you copy it.
show formulas
drag and drop
clipboard
absolute reference
