Devry bis155 week 1 quiz 1 latest

    0

    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

                                                                                                                                      Order Now