Bis 155 Week 1 Quiz,With Correct Answers 100% Graded A.

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