BIS 155 WEEK 3 QUIZ DATA ANALYSIS FUNCTIONS
To Download tutorial
Copy and Paste below Link into your Browser
BIS 155 Week 3 Quiz
Data Analysis Functions
Week 3 : Data Analysis
Functions – Quiz
Page 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
|
|
2. (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
|
|
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
|
|
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
|
|
5. (TCO 4) To create a new Conditional Formatting Rule,
_____. (Points : 2)
|
convert the cell to a Range
select any cell in the table and then click New Rule in the Tools group
click in a cell and on the Home tab, and click the Conditional arrow in the
Cells group
click Conditional Formatting from the Cell Styles group and select New Rule
|
|
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
|
|
7. (TCO 4) When data is grouped, the margin area displays
the _____. (Points : 2)
|
aggregate columns
group headings
collapse and expand buttons
group totals
|
|
8. (TCO 4) A _____ allows you to identify
relationships between variables in your data. (Points : 2)
|
function
field
pivot table
filter
|
|
9. (TCO 4) Data mining techniques such as PivotTables can
detect _____ of data. (Points : 2)
|
patterns
categories
styles
groups
|
|
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
|
|
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
|
|
12. (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
|
|
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
|
|
14. (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
|
|
15. (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
|
|
Comments
Post a Comment