Devry BIS 155 Week 3 Quiz
Question 1. (TCO 4) In Excel, a dataset would be which of the following? (Points : 2)
- Indicates where data starts on a new printed page
- Collection of structured, related data in columns and rows
- Freezing rows to keep them visible
- Freezing panes to keep them visible
Question 2. 2. (TCO 4) In Excel, a table is defined as _____. (Points : 2)
an area in the worksheet that contains rows and columns of related data formatted to enable data
- management and analysis
- a complete set of data for an entity
- a Field, which is an individual piece of data
- an individual piece of data, such as a last name
Question 3. 3. (TCO 4) When sorting in Excel, it arranges records in a table _____. (Points : 2)
- by the number of pages in the worksheet
- by the number of pages in the workbook
- by the value in field(s) within a table
- by permanently removing extraneous data
Question 4. 4. (TCO 4) Which of the following best describes the Excel filtering feature? (Points : 2)
- Helps to clean the data before printing in Backstage view
- Displays data in chronological order
- The process of displaying only records that meet specific conditions
- Arranges dates in alphabetical order
Question 5. 5. (TCO 4) To apply a red background color to cells for employees who have sales greater than $1,000, you can use _____. (Points : 2)
- a pivot table
- a multiple level sort
- conditional formatting
- a range name
Question 6. 6. (TCO 4) Using Conditional Formatting to draw attention to cells containing errors _____. (Points : 2)
- helps locate errors in cells quickly
- displays a particular color based on the relative value of the cell contents to other selected cells
- calculates an aggregate for values in a range or database
- displays an icon representing a value in the top third based on values in the selected range
Question 7. 7. (TCO 4) For subtotals to be useful and accurate, it is important that the data be _____ correctly. (Points : 2)
- sorted
- formatted
- aligned
- labeled
Question 8. 8. (TCO 4) A _____ allows you to identify relationships between variables in your data. (Points : 2)
- function
- field
- pivot table
- format
Question 9. 9. (TCO 4) Data mining techniques, such as pivot tables can detect _____ of data. (Points : 2)
- patterns
- categories
- styles
- groups
Question 10. 10. (TCO 4) To create a calculated field, select _____ located on the Pivot Table Tools Options tab. (Points : 2)
- Calculations
- Tools
- Pivot Table Calculation
- None of the above
Question 11. 11. (TCO 4) Data displayed in the pivot table will be updated _____. (Points : 2)
- when you right-click a cell in the pivot table and select Refresh
- automatically as soon as the source data changes
- when you select the worksheet containing the pivot table
- when you create a pivot chart
Question 12. 12. (TCO 4) What are the areas of a pivot table report where fields can be placed? (Points : 2)
- Criteria Range and Extract Range
- Values, Axis Fields, Legend Fields, and Report Filter
- Values, Row Labels, Column Labels, and Report Filter
- Database, Field, and Criteria
Question 13. 13. (TCO 4) The _____ and _____ are used to fine-tune a pivot table with specific data. (Points : 2)
- Flags and filters
- Arrows and filters
- Filters and slicers
- Filters and fielders
Question 14. 14. (TCO 4) Click the _____ to sort or filter the chart representation based on the values. (Points : 2)
- Axis Field arrows
- Report Filter arrows
- Values arrows
- Legend Field arrows
Question 15. 15. (TCO 4) Pivot charts look best when they use basic charts, such as a _____. (Points : 2)
- column chart
- scatter chart
- radar chart
- surface chart