devry BIS155 week 3 qui

Page 1

Question 1.1.(TCO 4) If there are certain columns of information that are not needed at a particular time but might be needed later, _____ the unneeded columns to allow users to focus on only the essential information.(Points : 2)

hide
delete
freeze
format

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) To convert a table back into a range, _____.(Points : 2)

click within the table, click the Table Tools Design tab, and then select Convert to Range
click the Insert tab and then click Range in the Range group
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

Question 4.4.(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

Question 5.5.(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

Question 6.6.(TCO 4) In addition to sorting and filtering cells by content, you can sort and/or filter by _____.(Points : 2)

top/bottom rules
conditional formatting
icon sets
the data bar

Question 7.7.(TCO 4) The Subtotal command is located on the _____ tab.(Points : 2)

data
formula
page layout
insert

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

function
field
pivot table
filter

Question 9.9.(TCO 4) Data mining techniques such as PivotTables can detect _____ of data.(Points : 2)

patterns
categories
styles
groups

Question 10.10.(TCO 4) A faster way to expand all categories at one time is to click _____.(Points : 2)

Collapse Entire Field in the Active Field group
Expand All Categories in the Show group
Expand All Categories in the Actions group
Expand Entire Field in the Active Field group

Question 11.11.(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

Question 12.12.(TCO 4) The _____ enables you to move to a cell quickly by typing the desired cell reference in it and pressing Enter.(Points : 2)

Formula bar
F4 function key
Go to dialog box
Find and Replace dialog box

Question 13.13.(TCO 4) After a PivotChart has been created, the PivotTable Settings can still be changed by using the _____.(Points : 2)

PivotTable Field List
Chart Layout command
Format Tab
Data Tab

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

devry BIS155 week 3 qui

devry BIS155 week 3 qui

Like this:

Related

devry BIS155 week 3 qui

devry BIS155 week 3 qui

Share this:

Like this:

Related