Devry BIS155 Week 3 QUIZ Latest 2015 November

QUESTION

Devry BIS155 Week 3 QUIZ Latest 2015 November

1. Question : (TCO 4) In Excel, a dataset would be which of the
following?

Question 2. Question
: (TCO 4) Which of the following
best describes a page break?

Question 3. Question
: (TCO 4) To convert a table
back into a range, _____.

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

Question 5. Question
: (TCO 4) Which of the following
best describes conditional formatting?

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

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

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

Question 9. Question
: (TCO 4) When creating a
PivotTable, you should use a new worksheet because _____.

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

Question 11. Question
: (TCO 4) Excel applies basic
formatting to PivotTables such as _____.

Question 12. Question
: (TCO 4) What are the areas of
a PivotTable Report where fields can be placed?

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

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

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

ANSWER:

REQUEST HELP FROM A TUTOR