BIS 155 Week 1 Quiz (Updated)

Share on facebook
Share on whatsapp
Share on twitter
Share on pinterest
Share on linkedin
Share on reddit
Share on skype
Share on email

BIS 155 Week 1 Quiz (Updated)


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

Hi there! Get instant help with . Without paying anything upfront.


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.


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


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

do you want to boost your grades? yes?

stop thinking we are eager to help you out

Payment Methods


Scroll to Top