Question 1

 

(TCO 4) _____ column and row headings enables you to keep these headings on the screen when scrolling through a large spreadsheet.

   

Formatting

 

 

   

Freezing

 

   

Resizing

 

   

Tiling

 

See Chapter 4 in the textbook.

 

Question 2

 

(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

 

See Chapter 4 in the textbook.

 

Question 3

 

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

 

  

click within the table, click the Table Tools Design tab, and then select Convert to Range

   

click the Insert tab and then click Range in the Range group

 

  

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

See Chapter 4 in the textbook.

 

Question 4

 

(TCO 4) Filtering the Last_Name column (field) to show only records that begin with the letter S is an application of _____.

   

the use of a table element as a formula

 

   

a Number Filter

 

 

   

a Text Filter

 

   

a Date Filter

 

See Chapter 4 in the textbook.

 

Question 5

 

(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

 

See Chapter 4 in the textbook.

 

Question 6

 

(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

 

See Chapter 4 in the textbook.

 

Question 7

 

(TCO 4) For subtotals to be useful and accurate, it is important that the data be _____ ly.

 

   

sorted

 

   

formatted

 

   

aligned

 

   

labeled

 

See Chapter 5 in the textbook.

 

Question 8

 

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

 

   

tables

 

   

format

 

   

layout

 

   

chart

 

See Chapter 5 in the textbook.

 

Question 9

 

(TCO 4) Data mining techniques, such as pivot tables can detect _____ of data.

 

   

patterns

 

   

categories

 

   

styles

 

   

groups

 

See Chapter 5 in the textbook.

 

Question 10

 

(TCO 4) A faster way to expand all categories at one time is to click _____.

   

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

 

See Chapter 5 in the textbook.

 

Question 11

 

(TCO 4) Data displayed in the pivot table will be updated _____.

 

   

when you right-click a cell in the pivot table and select Refresh

 

   

automatically as soon as the source data changes

 

   

when you select the worksheet containing the pivot table

 

   

when you create a pivot chart

 

See Chapter 5 in the textbook.

 

Question 12

 

(TCO 4) The _____ option allows you to change the position of a field in a pivot table.

   

Transition dialog box

 

   

filter

 

 Answer

   

move

 

You Answered

   

Find and Replace dialog box

 

See Chapter 5 in the textbook.

 

Question 13

 

(TCO 4) The _____ and _____ are used to fine-tune a pivot table with specific data.

   

See Chapter 5 in the textbook.

 

   

Flags and filters

 

 

   

Arrows and filters

 

   

Filters and slicers

 

   

Filters and fielders

 

See Chapter 5 in the textbook.

 

Question 14

 

(TCO 4) When Excel creates a pivot chart, it uses the current pivot table settings. If you want to change that data you might use _____.

   

Insert PivotTable

 

   

Insert Function

 

 

   

PivotTable Field List

 

   

Filter Connections

 

See Chapter 5 in the textbook.

 

Question 15

 

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

 

   

column chart

 

   

scatter chart

 

   

radar chart

 

   

surface chart

 

 

SmartExpert

(118)

Status NEW Posted 09 Nov 2017 09:11 PM My Price 8.00

BIS----------- 15-----------5 W-----------eek----------- 3 -----------Qui-----------z A-----------nsw-----------er-----------

Attachments

file 1510262327-BIS 155 Week 3 Quiz Answer.docx preview (549 words )

Q-----------ues-----------tio-----------n 1----------- 2----------- /----------- 2Â----------- pt-----------s -----------(TC-----------O 4-----------) _-----------___-----------_ c-----------olu-----------mn -----------and----------- ro-----------w h-----------ead-----------ing-----------s e-----------nab-----------les----------- yo-----------u t-----------o k-----------eep----------- th-----------ese----------- he-----------adi-----------ngs----------- on----------- th-----------e s-----------cre-----------en -----------whe-----------n s-----------cro-----------lli-----------ng -----------thr-----------oug-----------h a----------- la-----------rge----------- sp-----------rea-----------dsh-----------eet-----------. ----------- Â-----------  -----------For-----------mat-----------tin-----------g -----------  ----------- Co-----------rre-----------ct!----------- Â----------- Â ----------- F-----------ree-----------zin-----------g -----------  -----------  -----------  ----------- Re-----------siz-----------ing----------- Â-----------  ----------- Â-----------  -----------Til-----------ing----------- Â-----------  -----------See----------- Ch-----------apt-----------er -----------4 i-----------n t-----------he -----------tex-----------tbo-----------ok.----------- Â-----------  -----------Que-----------sti-----------on -----------2 -----------2 -----------/ 2----------- p-----------ts ----------- (T-----------CO -----------4) -----------Whi-----------ch -----------of -----------the----------- fo-----------llo-----------win-----------g b-----------est----------- de-----------scr-----------ibe-----------s a----------- pa-----------ge -----------bre-----------ak?----------- Â----------- Â ----------- F-----------ree-----------zes----------- on-----------ly -----------the----------- to-----------p r-----------ow -----------  ----------- Â----------- Â ----------- T-----------he -----------seq-----------uen-----------ce -----------in -----------whi-----------ch -----------pag-----------es

Not Rated(0)

• Buy Answer