Devry BIS 155 Week 1 Quiz 1 New

Devry BIS 155 Week 1 Quiz 1 NewQuestion 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 workbookIs at the intersection of a column and a rowIdentifies the address of the current cellDisplays the content of the active cell2 of 2Question 2. Question :(TCO 1) In Excel 2010, a sheet tab ________.displays the content of the active cellconceals the applicable formulas for the workbookidentifies the address of the current celldisplays the name of a worksheet within a workbook2 of 2Question 3. Question :(TCO 1) Which of the following best describes the AutoComplete function?Adds all the numbers in the row automaticallySearches for and displays any other similar label in the current column as you begin to typeAdds all the numbers in the columns automaticallyIs a number that represents a quantity and can be the basis of calculations2 of 2Question 4. Question :(TCO 1) Why would you use cell references in formulas instead of constant values?You can easily include letters, numbers, and spacesIt is easier to debug the errorsYou can change the input values without changing the formulasYou can control the sequence in which Excel performs arithmetic operations2 of 2Question 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 columnChanges the background color of the selected cells to yellowCopies the formula in the active cell to other cells and adapts it based upon the type of cell references in the original formulaHas two or more sub-commands related to the command2 of 2Question 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 themClick and drag across the cells to select them and use any sizing method you chooseDrag the fill handle across the cellsType A1 in the “Go To” dialog box2 of 2Question 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 2Question 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 cellRemoves the vertical lines running through the dataPuts a line horizontally through the dataRefers to the left-right position of contents in a cell2 of 2Question 9. Question :(TCO 3) A chart can be defined as ________.a group of related data pointsa visual representation of numerical dataa numeric value that describes a single value on a charttext that describes a collection of data points in a chart2 of 2Question 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 chartpie chartbar chartline chart2 of 2Question 11. Question :(TCO 3) Which of the following best describes the chart area?Contains graphical representation of values in data seriesContains the entire chart and all of its elementsA vertical line that borders the plot area to provide a frame of reference for measurementA horizontal line that borders the plot area to provide a frame of reference for measurement2 of 2Question 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 2Question 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 2Question 14. Question :(TCO 3) In Excel, an area chart _______.shows the high, low, and close prices for individual stocks over timetrends using two dimensions on a continuous curveemphasizes the magnitude of changes over time by filling in the space between lines with a colorshows a relationship between two variables2 of 2Question 15. Question :(TCO 3) Which of the following best describes a sparkline?A label that describes either the category axis or the value axisA miniature chart contained in a single cellThe value or name of a data pointA label that describes the chart: Textbook Chapter 3We are ready to write this paper for you from scratch.Place an order for this assignment or any other paper with us. We guarantee that the paper will be delivered within the specified deadline. We also have a personalized customer support and you will be able to communicate with your writer throughout the order preparation process. Thank you for choosing us.