CO 1) An Output Area (as it applies to Excel 2010) is
defined as_______.
a range of cells containing results based upon
manipulation of the variables in the input area
displays the name of a worksheet within a
workbook
a range of cells containing values for
variables used in formulas
displays the content of the active cell
Question 2. Question
:
(TCO 1) Which of the following best describes a cell
address?
Identifies the electronic
“neighborhood” of a spreadsheet
Identifies a cell by a column letter and a row
number
Searches for and displays similar labels as
you type
Is a number that represents a quantity and can
be the basis of calculations
Question 3. Question
:
(TCO 1) Which of the following best describes the
AutoComplete function?
Adds all the numbers in the row automatically
Searches for and displays any other similar
label in the current column as you begin to type
Adds all the numbers in the columns
automatically
Is a number that represents a quantity and can
be the basis of calculations
Question 4. Question
:
(TCO 1) Which of the following best describes the order of
precedence as it applies to math operations in Excel?
Includes letters, numbers, and spaces
Controls the sequence in which Excel performs
arithmetic operations
Is a software application used to create and
modify business communications
Includes formulas, functions, and formatting
Question 5. Question
:
(TCO 1) Which of the following best describes the result of
using the fill handle on a cell containing a formula?
Cannot complete a sequence of dates in a
column
Changes the background color of the selected
cells to yellow
Copies the formula in the active cell to other
cells and adapts it based upon the type of cell references in the original
formula
Has two or more sub-commands related to the
command
: 2 of 2
Comments:
Question 6. Question
:
(TCO 1) Ribbon Commands with arrows indicate_____.
a shortcut to cell A1
there are two or more sub-commands related to
the command
the next step in the process
directionality
Question 7. Question
:
(TCO 1) If you had worksheets that contained the inventory
of each room in your house, with a separate sheet for each room, all the sheets
together would be a:
workbook.
ledger.
document.
journal.
:
Question 8. Question
:
(TCO 1) When you paste copied data, Excel displays the Paste
Options button:
in the status bar at the left of the screen.
in the next set of nonadjacent ranges.
on the toolbar.
in the bottom right corner of the pasted data.
Question 9. Question
:
(TCO 3) Groups of related numeric values in an Excel
worksheet are:
data point.
data roles.
categories.
data series
Question 10. Question
:
(TCO 3) Which of the following best describes a column
chart?
Displays data comparisons vertically in
columns
A horizontal line that borders the plot area
to provide a frame of reference for measurement
Contains graphical representation of values in
data series
Contains the entire chart and all of its
elements
Question 11. Question
:
(TCO 3) Which of the following best describes the chart
area?
Contains graphical representation of values in
data series
Contains the entire chart and all of its
elements
A vertical line that borders the plot area to
provide a frame of reference for measurement
A horizontal line that borders the plot area
to provide a frame of reference for measurement
Question 12. Question
:
(TCO 3) To display similar data in a single column, with
each series of data distinguished by a different color, use a:
stacked column chart.
pie chart.
3-D column chart.
box diagram.
Question 13. Question
:
(TCO 3) A pie chart with one or more slices separated for
emphasis is called a(n) ____________ pie chart.
expanded
exploded
displaced
clustered
Question 14. Question
:
(TCO 3) In Excel, an area chart _______.
shows the high, low, and close prices for
individual stocks over time
trends using two dimensions on a continuous
curve
emphasizes the magnitude of changes over time
by filling in the space between lines with a color
shows a relationship between two variables
Question 15. Question
:
(TCO 3) After creating a chart, you can change the chart
type by using _____.
Page Layout tab / Chart Options button
Design tab / Change Chart Type button
Data tab / Chart Changer tool
You cannot change the chart.