# DEVRY BIS155/BIS 155 WEEK 1 QUIZ 1 NEW 2015 - 92238

Solution Posted by

## anjis_devis

Rating : (20)B
Solution Detail
Price: \$12.00
Request Description
Question 1. Question : (TCO 1) 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 2 of 2 Question 2. Question : (TCO 1) 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 2 of 2 Question 3. Question : (TCO 1) 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 2 of 2 Question 4. Question : (TCO 1) 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 2 of 2 Question 5. Question : (TCO 1) 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 2 of 2 Question 6. Question : (TCO 1) 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 2 of 2 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: workbook. ledger. document. journal. 2 of 2 Question 8. Question : (TCO 1) 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 2 of 2 Question 9. Question : (TCO 3) 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 2 of 2 Question 10. Question : (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. column chart pie chart bar chart line chart 2 of 2 Question 11. Question : (TCO 3) 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 2 of 2 Question 12. Question : (TCO 3) 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. 2 of 2 Question 13. Question : (TCO 3) 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. 2 of 2 Question 14. Question : (TCO 3) 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 2 of 2 Question 15. Question : (TCO 3) 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 : Textbook Chapter 3 2 of 2
Solution Description

Question 1. Question :

(TCO 1) 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

2 of 2

Question 2. Question :

(TCO 1) 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

2 of 2

Question 3. Question :

(TCO 1) 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 an

Attachments