Answered You can buy a ready-made answer or pick a professional tutor to order an original one.
Devry bUs155 week 3 quiz 3 latest
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 Tab
Data Tab
: Textbook Chapter 5
2 of 2
Question 14. Question :
(TCO 4) Click the _____ to sort or filter the chart representation based on the values.
Axis Field arrows
Report Filter arrows
Values arrows
Legend Field arrows
: Textbook Chapter 5
0 of 2
Question 15. Question :
(TCO 4) Which of the following will NOT delete a PivotChart?
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
- @
- 177 orders completed
- ANSWER
-
Tutor has posted answer for $13.00. See answer's preview
*********
**** ** ** ***** a ******* ***** ** which ** *** ***********
Indicates ***** **** starts ** a *** ******* *****
********** of structured ******* **** in columns *** *****
Freezing **** ** **** **** ********
******** panes ** **** them ********
* ******** Chapter **
2 of **
******** * ******** :
(TCO ** ***** ** *** following **** ********* a **** *******
Freezes **** *** top row
*** ******** in which ***** ******
********* ***** **** ****** on * new ******* *****
Stops the ******* **** *********
* Textbook ******* 4
* of **
Question * ******** **
(TCO 4) To create * table from ** ******** ***** of **** ******
***** within *** range ***** *** ***** ***** Design *** *** **** ****** ******* to ******
****** any **** ** *** worksheet *** then ***** ******** ***** ** *** ***** group
***** ** * **** and ** the **** tab and click the Insert ***** ** the ***** ******
**** *** ****** tab *** **** ***** ***** ** *** ****** ******
* Textbook Chapter **
* ** **
******** * Question **
**** ** ********* *** **** ****** ******* to show **** ******* ******* **** $10000 is ** *********** ** ******
* **** Filter
* **** *******
the *** ** * ***** ******* ** * ********
a ****** *******
* ******** ******* **
of **
******** * ******** **
**** 4) ***** ** *** ********* best describes *********** formatting?
********** ** ********** ***** **** **** ******* ***********
Tags * ***** ******* ** * ********* in a ********
******* *** ********* ** *** ********* ** preparation for printing
********** an ********* for ****** ** a range or database
* ******** Chapter **
* ** **
******** 6 ******** **
**** ** ** ******** ** ******* and filtering cells ** content *** can **** ****** ****** ** ******
********** ******
*********** formatting
icon *****
the data bar
* ******** Chapter **
** **
******** * Question :
**** ** When data is grouped *** ****** **** ******** the _____
********* ********
group *********
******** *** ****** ********
***** totals
* ******** Chapter **
of 2
******** 8 Question :
**** ** ** add * ********** ****** the ****** PivotTable ******* **** the _____ ******
*******
*******
layout
******
* ******** ******* 5
of **
Question 9 ******** :
(TCO ** To ***** a ****** ***** ** * particular ***** *** drag *** ******* ***** to which area ***** **** fields ******* ***** *******
Column *******
Report *******
Row *******
*******
: ******** Chapter **
** 2
Question 10 ******** **
**** ** ** create * ********** field ****** ***** ******* ** the ********** ***** ******* tab
*************
Insert ********** ***** dialog *********
Tools
********** Calculation
* Textbook Chapter 5
of **
******** ** ******** **
(TCO 4) Excel ******* basic formatting ** *********** **** ** ******
********* in ********
******* *** labels ** *****
******* *** labels ** ********
********* ** ****
* Textbook Chapter **
2 ** **
******** ** ******** :
(TCO ** **** *** the areas ** * ********** Report ***** ****** *** ** placed?
******** ***** *** ******* ******
****** Axis ****** ****** ****** and Report *******
Values *** ****** ****** ****** and ****** *******
******** ***** *** Criteria
* Textbook ******* **
* ** **
******** ** ******** :
**** 4) ***** * PivotChart *** **** ******* *** ********** Settings *** ***** ** ******* ** using *** _____
********** Field *****
Chart ****** command
****** ****
**** ****
* Textbook ******* **
2 ** **
******** ** ******** **
**** 4) Click *** ***** ** **** or ****** *** chart ************** ***** ** *** *******
**** ***** *******
****** ****** *******
****** arrows
****** ***** *******
: ******** ******* 5
** 2
******** ** ******** **
**** ** ***** ** *** ********* **** *** ****** a ************
** ** *** **** *** and ***** Cut
Right-click *** ***** *** ***** ****
****** *** ***** *** **** ***** *******
***** *** **** the PivotChart off *** *********