An Output Area (as it applies to Excel 2010) is defined as

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