| Question 1. | Question : | (TCO 1) An Input Area (as it applies to Excel 2010) is defined as______. |
| | Student Answer: | | a range of cells containing results based on the output 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) In Excel 2010, a sheet tab ________. |
| | Student Answer: | | 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 : | (TCO 1) If you wanted to insert the current date into an active cell, which of the following would you use? |
| | Student Answer: | | F4 | | | | Ctrl + Alt + Delete | | | | The Ctrl + D key combination | | | | The Ctrl and semicolon key combination | | | |
| |
| Question 4. | Question : | (TCO 1) In Excel a Formula is _______. |
| | Student Answer: | | 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. | Question : | (TCO 1) Which of the following best describes the result of using the fill handle on a cell containing a formula? |
| | Student Answer: | | 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 : | (TCO 1) In Excel 2010, a column width ________. |
| | Student Answer: | | is adjustable so you can display more or less characters in a column | | | | is not adjustable so keep the formulas as short as possible | | | | always switches back to default | | | | is best left unchanged unless you absolutely have to | | | |
| |
| 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: |
| | Student Answer: | | workbook. | | | | ledger. | | | | document. | | | | journal. | | | |
|
| Question 8. | Question : | (TCO 1) When you paste copied data, Excel displays the Paste Options button: |
| | Student Answer: | | 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) A data series is a group of related ____________. |
| | Student Answer: | | charts on a worksheet | | | | category labels on a horizontal axis | | | | data points on a chart | | | | numerical values on a vertical axis | | | |
|
| Question 10. | Question : | (TCO 3) Which best describes a data point? |
| | Student Answer: | | A numeric value that describes a single value on a chart | | | | A group of related data points | | | | Displays data comparisons vertically in columns | | | | Text that describes a collection of data points in a chart | | | |
| |
| Question 11. | Question : | (TCO 3) When creating a chart in Excel, the plot area ________. |
| | Student Answer: | | 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. | Question : | (TCO 3) When creating a chart in Excel, a multiple data series _______. |
| | Student Answer: | | 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. | Question : | (TCO 3) A pie chart with one or more slices separated for emphasis is called a(n) ____________ pie chart. |
| | Student Answer: | | expanded | | | | exploded | | | | displaced | | | | clustered | | | |
| |
| Question 14. | Question : | (TCO 3) Which of the following best describes the X Y (scatter) chart? |
| | Student Answer: | | Shows values as percentages of the whole but may contain more than one data series | | | | Shows the high, low, and close prices for individual stocks over time | | | | Shows trends using two dimensions on a continuous curve | | | | Shows a relationship between two variables | | | |
| |
| Question 15. | Question : | (TCO 3) Which of the following best describes a sparkline? |
| | Student Answer: | | 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 | |
|
|
