Question 1. Question : 

(TCO 1) Which of the following describes the function of the Formula Bar (as it applies to Excel 2010)?

Displays the name of a worksheet within a workbook

Is at the intersection of a column and a row

Identifies the address of the current cell

Displays the content of the active cell

2 of 2

Question 2. Question : 

(TCO 1) In Excel 2010, a sheet tab ________.

displays the content of the active cell

conceals the applicable formulas for the workbook

identifies the address of the current cell

displays the name of a worksheet within a workbook

2 of 2

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

2 of 2

Question 4. Question : 

(TCO 1) Why would you use cell references in formulas instead of constant values?

You can easily include letters, numbers, and spaces

It is easier to debug the errors

You can change the input values without changing the formulas

You can control the sequence in which Excel performs arithmetic operations

2 of 2

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

Question 6. Question : 

(TCO 1) Which of the following would allow you to adjust the column width and/or row height of many cells at once?

Just type longer or taller formulas in some of them

Click and drag across the cells to select them and use any sizing method you choose

Drag the fill handle across the cells

Type A1 in the “Go To” dialog box

2 of 2

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.

2 of 2

Question 8. Question : 

(TCO 1) Which of the following describes the horizontal Alignment in Excel 2010?

Refers to the up-down position of contents in a cell

Removes the vertical lines running through the data

Puts a line horizontally through the data

Refers to the left-right position of contents in a cell

2 of 2

Question 9. Question : 

(TCO 3) A chart can be defined as ________.

a group of related data points

a visual representation of numerical data

a numeric value that describes a single value on a chart

text that describes a collection of data points in a chart

2 of 2

Question 10. Question : 

(TCO 3) A __________ is usually the most effective way to display proportional relationships, such as market share data, where the individual data values represent parts of a whole.

column chart

pie chart

bar chart

line chart

2 of 2

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

2 of 2

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.

2 of 2

Question 13. Question : 

(TCO 3) To provide your viewers with an explanation of the representations of the colors utilized in the data series in your chart, provide a:

diagram.

pop-up comment box.

legend.

note.

2 of 2

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

2 of 2

Question 15. Question : 

(TCO 3) Which of the following best describes a sparkline?

A label that describes either the category axis or the value axis

A miniature chart contained in a single cell

The value or name of a data point

A label that describes the chart

: Textbook Chapter 3

2 of 2