BIS 155 Week 3: Lab Exercise, Quiz plus Discussion
(BIS 155 Week 3)
- Question: (TCO 4) How many possibilities exist when thinking about the freeze options?
- Question: (TCO 4) In Excel, a table is … as _____.
- Question: (TCO 4) To create a table from an existing range of data, _____.
- Question: (TCO 4) Filtering the Cost column (field) to show only records greater than $10,000 is an application of _____.
- Question: (TCO 4) To apply a red background color to cells for employees who have sales greater than $1,000, you can use _____.
- Question: (TCO 4) Using Conditional Formatting to draw attention to cells that are blank _____.
- Question: (TCO 4) For subtotals to be useful and accurate, it is important that the data be _____
- Question: (TCO 4) _____ are created to organize and summarize data in pivot tables.
- Question: (TCO 4) When creating a pivot table, you should use a good descriptive name as a best practice because _____.
- Question: (TCO 4) To create a calculated field, select _____ located on the Pivot Table Tools Options tab.
- Question: (TCO 4) Excel applies basic formatting to pivot tables such as _____.
- Question: (TCO 4) Excel uses the SUM function as the default summary statistic for the Value Field Settings. Which of the following calculations can you choose to summarize a value?
- Question: (TCO 4) The _____ and _____ are used to fine-tune a pivot table with specific data.
- Question: (TCO 4) When Excel creates a pivot chart, it uses the current pivot table settings. If you want to change that data you might use _____.
- Question: (TCO 4) Pivot charts look best when they use basic charts, such as a _____.