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

Wait.... Hire Me To Get 100% Original Help In . With No Upfront Fees. Watch The Video Below For More Information & How It Works!

Play Video

Name: Jennifer Lucas
Status: Online ⬤
Classes Taken: 3878
Ratings: ⭐⭐⭐⭐⭐

Hire Me

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