Question 1. Question : 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
Question 2. Question : 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
Question 3. Question : 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 : 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
Question 5. Question : 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
Question 6. Question : 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
Question 7. Question :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 :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
Question 9. Question :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
Question 10. Question :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
Question 11. Question :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 :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 :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.
Question 14. Question : 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 :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