Devry BIS 155 Week 2 Quiz
(TCO 2) The _____ number is the number of the column in the lookup table that contains the return values. (Points : 2)
- lookup value
- column index
- lookup table
- random
Question 2. 2. (TCO 2) Which of the following best describes the HLOOKUP function? (Points : 2)
- The periodic interest rate, such as a monthly interest rate
- Calculates the periodic payment for a loan with a fixed interest rate and fixed term
- Looks up a value in a lookup table where the first column contains the values to compare with the lookup value
- Looks up a value in a lookup table in which the first row contains the values to compare with the lookup value
Question 3. 3. (TCO 2) The _____ function tallies the number of cells in a range that contain values you an use in calculations. (Points : 2)
- =COUNT
- =MIN
- =COUNT()
- =TODAY()
Question 4. 4. (TCO 2) When calculating a PMT function, the RATE would be described best by which of the following? (Points : 2)
- It is the periodic interest rate, such as a monthly interest rate.
- It is the total number of payment periods.
- It is a word or a string of characters that represent one or more cells.
- It is the present value of the loan.
Question 5. 5. (TCO 3) A data series is a group of related _____. (Points : 2)
- charts on a worksheet
- category labels on a horizontal axis
- data points on a chart
- numerical values on a vertical axis
Question 6. 6. (TCO 3) Which of the following best describes a column chart? (Points : 2)
- Displays data comparisons vertically in columns
- A horizontal line that borders the plot area to provide a frame of reference for measurement
- Contains graphical representation of values in data series
- Contains the entire chart and all of its elements
Question 7. 7. (TCO 3) Which of the following best describes the chart area? (Points : 2)
- 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
Question 8. 8. (TCO 3) To display similar data in a single column, with each series of data distinguished by a different color, use a _____. (Points : 2)
- stacked column chart
- pie chart
- 3-D column chart
- box diagram
Question 9. 9. (TCO 3) To visually determine whether there is a relationship between two variables, use a _____. (Points : 2)
- bar chart
- scatter chart
- pie chart
- 3-D pie chart
Question 10. 10. (TCO 3) In Excel, an area chart _____. (Points : 2)
- 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
Question 11. 11. (TCO 3) Which of the following best describes a trendline? (Points : 2)
- A line used to depict trends and forecast future data
- Text that describes a collection of data points in a chart
- A group of related data points
- Displays data comparisons vertically in columns
Question 12. 12. (TCO 3) When you select a chart, Excel displays three icons on the right. Which icon comes first? (Points : 2)
- Chart layouts
- Chart elements
- Chart design
- Chart examples
Question 13. 13. (TCO 3) Which of the following describes the Error bar? (Points : 2)
- Visuals to indicate a standard error amount, percentage, or standard deviation
- Lines that span the chart to help people identify values plotted
- A key that identifies the visual components assigned to each data series
- A grid that contains the data source values and labels
Question 14. 14. (TCO 3) You can apply multiple settings like fill colors and borders at the same time using the Format _____. (Points : 2)
- task pane
- title window
- quick layout tool
- developer dialog box
Question 15. 15. (TCO 3) What is the logical sequence for creating a chart? (Points : 2)
- Select the chart type, then the data source, then the size of the chart.
- Select the cell where the chart will be placed, then the chart type, then the data source.
- Select the data source, then size the chart, and select a type.
- Select the data source, then choose the chart type, and finally size and position the chart.