BIS155 Quiz Week 3

$5.00

BIS155 Quiz Week 3
(TCO 4) The Insert Calculated Field dialog box requires you do all the following EXCEPT…

Description

BIS155 Quiz Week 3

BIS155 Quiz Week 3

A+

(TCO 4) _____ column and row headings enables you to keep these headings on the screen when scrolling through a large spreadsheet. (Points : 2)

Formatting

Freezing

Resizing

Tiling

(TCO 4) In Excel, the print area is defined as _____. (Points : 2)

an individual piece of data, such as a last name

a complete set of data for an entity

the sequence in which pages print

the range of data to print

TCO 4) _____ column and row headings enables you to keep these headings on the screen when scrolling through a large spreadsheet. (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

(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

(TCO 4) Filtering the Last_Name column (field) to show only records that begin with the letter S is an application of _____. (Points : 2)

the use of a table element as a formula

a Number Filter

a Text Filter

a Date Filter

(TCO 4) Which of the following best describes conditional formatting? (Points : 2)

Highlights or emphasizes cells that meet certain conditions

Tags a table element as a reference in a formula

Formats the condition of the worksheet in preparation for printing

Calculates an aggregate for values in a range or database

(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

(TCO 4) When data is grouped, the margin area displays the _____. (Points : 2)

aggregate columns

group headings

collapse and expand buttons

group totals

 

(TCO 4) A _____ allows you to identify relationships between variables in your data. (Points : 2)

Function

Field

Pivot table

filter

(TCO 4) Excel applies basic formatting to PivotTables such as _____. (Points : 2)

subtotals in italics

primary row labels in bold

primary row labels in italics

subtotals in red

(TCO 4) What are the areas of a PivotTable 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

(TCO 4) To go to the top of your spreadsheet quickly, use the _____ key(s). (Points : 2)

PivotTable Field List

Chart Layout command

Format Tab

Data Tab

(TCO 4) To build a PivotTable and PivotChart at the same time, click the PivotTable arrow and then select _____. (Points : 2)

PivotTable & PivotChart

PivotChart

Auto PivotTable

Auto PivotChart

(TCO 4) Which of the following will NOT delete a PivotChart? (Points : 2)

Go to the Home tab and click Cut

Right-click the chart and click Cut

Select the chart and then press Delete

Click and drag the PivotChart off the worksheet

(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

(TCO 4) To create a table from an existing range of data, _____. (Points : 2)

Click within the range, click the Table Tools Design tab, and then select Convert to Table

Select any cell in the worksheet and then click Existing Range in the Tools group

Click in a cell and on the Home tab, and click the Insert arrow in the Cells group

Click the Insert tab and then click Table in the Tables group

(TCO 4) Filtering the Cost column (field) to show only records greater than $10,000 is an application of _____. (Points : 2)

A Date Filter

A Text Filter
the use of a table element as a formula

A Number Filter

(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 PivotTable

A multiple level sort

Conditional formatting

A range name

(TCO 4) Using Conditional Formatting to draw attention to cells that are blank _____. (Points : 2)

Displays a particular color based on the relative value of the cell contents to other selected cells

Displays an icon representing a value in the top third, quarter, or fifth based on values in the selected range

Helps locate where data may be missing

Helps locate errors in cells quickly

(TCO 4) For Subtotals to be useful and accurate, it is important that the data be _____ correctly. (Points : 2)

sorted
formatted

aligned

labeled

(TCO 4) To add a PivotTable, choose the Insert PivotTable command from the _____ group. (Points : 2)

Tables

Format

Layout

Chart

(TCO 4) The Insert Calculated Field dialog box requires you do all the following EXCEPT _____. (Points : 2)

Enter formulas using field names instead of cell references
Enter a description column heading for the calculated field

Build formulas using mathematical operands such as +, -, and *

Enter formulas using cell references

(TCO 4) Data displayed in the PivotTable will be updated _____. (Points : 2)

When you right-click a cell in the PivotTable and select Refresh

Automatically as soon as the source data changes

When you select the worksheet containing the PivotTable

When you create a PivotChart

(TCO 4) A quick way to display the Go to dialog box is to press the _____ key(s). (Points : 2)

F4

Ctrl+Home

Ctrl+End
F5

(TCO 4) To go to the top of your spreadsheet quickly, use the _____ key(s). (Points : 2)

Ctrl+End

Arrow

Ctrl+Home

Esc

(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

(TCO 4) Pivot Charts look best when they use basic charts, such as a _____. (Points : 2)

Column chart

Scatter chart

Radar chart

Surface chart

(TCO 4) Which of the following best describes a page break?

Freezes only the top row

The sequence in which pages print

Indicates where data starts on a new printed page

Stops the printer from printing

(TCO 4) The Subtotal command is located on the _____ tab.

Data

Formula

Page layout

Insert

(TCO 4) _____ are created to organize and summarize data in PivotTables.

Categories

Types

Titles

Levels

(TCO 4) To create a calculated field, select _____ located on the PivotTable Tools Options tab.

Calculations

Insert Calculated Field dialog launcher

Tools

PivotTable Calculation

(TCO 4) A Pivot Table Style controls all the following EXCEPT _____.

Bolding

Font colors

Number format

Shading colors

(TCO 4) The PivotChart Tools contextual tab includes all the following EXCEPT _____.

Design

Layout

Format

Type

(TCO 4) Which of the following will NOT delete a PivotChart?

Go to the Home tab and click Cut

Right-click the chart and click Cut

Select the chart and then press Delete

Click and drag the PivotChart off the worksheet

BIS155 Quiz Week 3

DeVry