Page 1
Question 1.1.(TCO 1) An Output Area (as it applies to Excel 2010) is defined as_______.(Points : 2)
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.2.(TCO 1) In Excel 2010, a sheet tab ________.(Points : 2)
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
Question 3.3.(TCO 1) Which of the following best describes the AutoComplete function?(Points : 2)
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.4.(TCO 1) In Excel a Formula is _______.(Points : 2)
a number that represents a date and can be the basis of calculations
a combination of cell references, operators, values, and/or functions used to perform calculations
a number that represents a quantity and can be the basis of calculations
should be used in each column of a workbook
Question 5.5.(TCO 1) Which of the following best describes the result of using the fill handle on a cell containing a formula?(Points : 2)
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
Question 6.6.(TCO 1) Which of the following would allow you to adjust the column width and/or row height of many cells at once?(Points : 2)
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
Question 7.7.(TCO 1) The three types of data that can be entered in a cell in an Excel worksheet are ________________.(Points : 2)
columns, rows, and fields
numbers, fonts, and styles
functions, comments, and macros
text, values, and formulas
Question 8.8.(TCO 1) Which of the following describes the horizontal Alignment in Excel 2010?(Points : 2)
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
Question 9.9.(TCO 3) A chart can be defined as ________.(Points : 2)
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
Question 10.10.(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.(Points : 2)
column chart
pie chart
bar chart
line chart
Question 11.11.(TCO 3) When creating a chart in Excel, the plot area ________.(Points : 2)
contains graphical representation of values in data series
is a vertical line that borders the plot area to provide a frame of reference for measurement
is a horizontal line that borders the plot area to provide a frame of reference for measurement
provides descriptive group names for subdividing the data series
Question 12.12.(TCO 3) When creating a chart in Excel, a multiple data series _______.(Points : 2)
groups or clusters similar data in columns to compare values across categories
compares two or more sets of data in one chart
is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart
places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color
Question 13.13.(TCO 3) To visually determine whether there is a relationship between two variables, use a:(Points : 2)
bar chart.
scatter chart.
pie chart.
3-D pie chart.
Question 14.14.(TCO 3) In Excel, an area chart _______.(Points : 2)
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.15.(TCO 3) Which of the following best describes a sparkline?(Points : 2)
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