BIS 155 WEEK 3 QUIZ DATA ANALYSIS FUNCTIONS

BIS 155 WEEK 3 QUIZ DATA ANALYSIS FUNCTIONS

To Download tutorial Copy and Paste below Link into your Browser

for any inquiry email us at  ( essayblue@gmail.com )

BIS 155 Week 3 Quiz Data Analysis Functions

Week 3 : Data Analysis Functions – Quiz

Time Remaining:

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

Popular posts from this blog

ECH 135 WEEK 7 ASSIGNMENT BENCHMARK- CLASSROOM ENVIRONMENT PLAN

ECH 135 TOPIC 4 ASSIGNMENT PRACTICUM APPLICATION NO. 2

DEVRY RELI448 WEEK 6 QUIZ