Question 

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

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

: Textbook Chapter 4

2 of 2

Question 2. Question : 

(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

: Textbook Chapter 4

2 of 2

Question 3. Question : 

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

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

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

: Textbook Chapter 4

2 of 2

Question 4. Question : 

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

a Date Filter

a Text Filter

the use of a table element as a formula

a Number Filter

: Textbook Chapter 4

0 of 2

Question 5. Question : 

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

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

: Textbook Chapter 4

2 of 2

Question 6. Question : 

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

top/bottom rules

conditional formatting

icon sets

the data bar

: Textbook Chapter 4

0 of 2

Question 7. Question : 

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

aggregate columns

group headings

collapse and expand buttons

group totals

: Textbook Chapter 5

0 of 2

Question 8. Question : 

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

 tables

format

layout

chart

: Textbook Chapter 5

0 of 2

Question 9. Question : 

(TCO 4) To begin a filter based on a particular field, you drag the desired field to which area under Drag fields between areas below?

Column Labels

Report Filter

Row Labels

Values

: Textbook Chapter 5

0 of 2

Question 10. Question : 

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

Calculations

Insert Calculated Field dialog launcher

Tools

PivotTable Calculation

: Textbook Chapter 5

0 of 2

Question 11. Question : 

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

subtotals in italics

primary row labels in bold

primary row labels in italics

subtotals in red

: Textbook Chapter 5

2 of 2

Question 12. Question : 

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

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

: Textbook Chapter 5

2 of 2

Question 13. Question : 

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

PivotTable Field List

Chart Layout command

Format TabDevry busn319 week 4 quiz latest july 2015,Business & Finance,$20.00,

Get a Unique Answer HERE or Order a Similar Paper

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.