Deck 21: Excel: Datasets and Tables: Managing Large Volumes of Data

Question 1

________ displays alternate fill colors for even and odd rows to help distinguish fields.

A)Filtered rows
B)Banded columns
C)First/Last columns
D)Banded rows

Answer 1

B

Question 2

What is a field?

A)A complete set of data for an entity
B)Indicates where data starts on a new worksheet
C)An individual piece of data,such as an address
D)All data about one specific item

Answer 2

C

Question 3

In Excel 2013 a dataset:

A)indicates where data starts on a new printed page.
B)is a collection of structured,related data in columns and rows.
C)is a grouping of similarly formatted worksheets.
D)is a grouping of worksheets with similar content.

Answer 3

B

Question 4

Which of the following is NOT an option on the Page Layout tab?

A)Manage page breaks
B)Set the print area
C)Print titles
D)Print preview

Question 5

A Table style controls:

A)check boxes to select format actions such as Total Row.
B)check boxes to select format actions such as Header Row.
C)the fill color of the header row and rows of records.
D)the background and watermarks of a worksheet.

Question 6

Each column in a table:

A)needs to be converted to a range in order to work with it.
B)represents a record.
C)is a complete set of data for an entity.
D)represents a field which can contain an individual piece of data for a record.

Question 7

Print order:

A)represents a Field which is an individual piece of data.
B)is the sequence in which pages print.
C)represents a record.
D)is the command to print in Excel 2013.

Question 8

To create a table from an existing range of data:

A)click within the range,click the Table Tools Design tab,and then select Convert to Table.
B)select any cell in the worksheet then click Existing Range in the Tools group.
C)click in a cell and on the Home tab,click the Insert arrow in the Cells group.
D)click the Insert tab and then click Table in the Tables group.

Question 9

Sorting arranges records in a table by:

A)using filter arrows.
B)the row number.
C)the value in field(s)within a table.
D)permanently removing extraneous data.

Question 10

The Freeze Top Row option:

A)is the sequence in which pages print.
B)enables you to adjust settings to control how the worksheet will print.
C)defines the range of data to print.
D)keeps only the top row visible as you scroll through a worksheet.

Question 11

Which of the following is TRUE about the print area feature?

A)In Page Break Preview,the area of the worksheet that won't be printed has a dark blue background.
B)In Page Break Preview,the print area has a white background and dashed red border.
C)The print area can be cleared from the Home tab.
D)The print area defines the range of data to print.

Question 12

Each row in an Excel table:

A)is an individual piece of data,such as a last name.
B)is the sequence in which pages print.
C)represents a Field which can contain an individual piece of data for a record.
D)represents a record.

Question 13

How are manual page breaks indicated in a worksheet?

A)By solid blue lines
B)By dotted red lines
C)By blue dashed lines
D)By solid black lines

Question 14

Which of the following shows where automatic page breaks will occur in a worksheet?

A)By solid blue lines
B)By dotted red lines
C)By blue dashed lines
D)By solid black lines

Question 15

Which of the following is NOT a Table Style option?

A)Subtotal Row
B)Filter Button
C)First Column
D)Banded Rows

Question 16

What is a record?

A)An individual piece of data,such as a last name
B)Defines the range of data to print
C)A complete set of data for an entity
D)All data within one full column

Question 17

A page break:

A)indicates which worksheet is set to print.
B)is the sequence in which pages print.
C)indicates where data starts on a new printed page.
D)stops the printer from printing.

Question 18

Freezing rows and/or columns:

A)collects structured,related data in columns and rows.
B)keeps them visible as you scroll through a worksheet.
C)keeps all worksheets on the screen.
D)enables you to adjust settings to control how the worksheet will print.

Question 19

The Freeze Panes option keeps:

A)only the first column visible as you scroll through a worksheet.
B)both rows and columns above and to the left of the active cell visible as you scroll.
C)only the designated rows visible as you scroll through a worksheet.
D)all row names and column headings on the screen for preparation in printing.

Question 20

Which of the following is NOT included in the Table Style Options group?

A)Footer Row
B)Last Column
C)Banded Columns
D)Filter Button

Question 21

Filtering:

A)helps to remove duplicate data in a dataset.
B)displays data in chronological order.
C)is the process of displaying only records that meet special conditions.
D)arranges dates in alphabetical order.

Question 22

A structured reference:

A)is a tag or use of a table element,such as a field heading.
B)highlights or emphasizes cells that meet certain conditions.
C)is a table element that uses relative references in a formula within a table.
D)formats cells based upon their value in reference to the value of other cells.

Question 23

Sorting dates oldest to newest:

A)is the process of displaying only records that meet specific conditions.
B)arranges dates in alphabetical order.
C)is a Text filter.
D)displays data in chronological order.

Question 24

If the automatic page breaks occur in undesirable locations,you can adjust the page breaks.

Question 25

Filtering the First_Name field to display only records that begin with the letter J uses a:

A)field.
B)sort filter.
C)text Filter.
D)conditional filter.

Question 26

You can create a table by selecting a range,clicking the Quick Analysis button,and clicking Tables.

Question 27

A page break indicates where the end of all the columns (fields)occurs.

Question 28

A color scale:

A)highlights cells meeting specified criteria with a specified color,font,or border.
B)is a conditional format that displays an colored icon representing a value in the top third,quarter,or fifth based on colors in the selected range.
C)calculates an aggregate for values in a range or database.
D)is a conditional format that displays a color based on the relative value of the cell contents.

Question 29

A total row appears as the last row of a table to:

A)highlight or emphasize cells that meet certain conditions.
B)format cells based upon their value in reference to the value of other cells.
C)tag a table element as a reference in a formula.
D)display summary statistics,such as a sum.

Question 30

Unfreeze Panes only appears on the menu when you have frozen rows and/or columns.

Question 31

Freeze Panes only locks columns above the active cell as you scroll through a worksheet.

Question 32

Default column headings of a table are Column1,Column2,and so on.

Question 33

In addition to sorting and filtering cells by content you can sort and/or filter by:

A)Top/Bottom rules.
B)conditional formatting.
C)icon sets.
D)the data bar.

Question 34

Excel enables you to sort data on ________ different levels.

A)116
B)18
C)256
D)64

Question 35

In Page Break Preview,the print area has a white background with a dotted blue border.

Question 36

Press F6 to display the Go To dialog box.

Question 37

Top/Bottom Rules:

A)is a horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells.
B)moves data from the top of the workbook to the bottom for analysis.
C)highlight cells meeting specified criteria with a specified color,font,or border.
D)format cells based upon their value in relation to the value of other cells.

Question 38

Sorting values smallest to largest:

A)arranges names in sequential order.
B)arranges numbers in sequential order.
C)arranges dates in alphabetical order.
D)is the process of displaying only records that meet specific conditions.

Question 39

Tables provide advantages over regular ranges but you cannot convert a table back to a regular range of data.

Question 40

After you have created a table,you cannot add new fields to it.

Question 41

If the default conditional format options do not provide what you need,you can create your own rule for formatting.

Question 42

A structured reference uses field names instead of cell references to make it easier to create formulas.

Question 43

In a worksheet,it is possible to ________ a manual page break to a new,desired location.

Question 44

A table style controls the fill color of header rows.

Question 45

Table Styles use Live Preview.

Question 46

Text can be sorted A to Z or Z to A.

Question 47

A page ________ indicates where data starts on a new printed page.

Question 48

To keep columns and/or rows on the screen and visible,use the Windows group on the View Tab ,and then click ________ Panes.

Question 49

A structured reference requires parentheses around column headings or field names.

Question 50

When you no longer need conditional formatting,you can clear it for a selected range or for an entire worksheet.

Question 51

You can only apply one filter to a large dataset in Excel 2013.

Question 52

In Excel 2013,you can delete conditional formatting rules that you create but you cannot edit them.

Question 53

You can sort data by one or more columns.

Question 54

Semiselection cannot be used to create formulas in a table.

Question 55

Banded Rows display alternate fill colors for every five sets of rows to distinguish records.

Question 56

Conditional formatting is the process of conditioning data to make it more manageable.

Question 57

________ keeps rows and/or columns visible as you scroll through a worksheet.

Question 58

With data arranged in a table,you can display a total row after the last record.Excel sums the values in the last column automatically

Question 59

You can apply text,value,and date filters to fields based on the data in a particular field.

Question 60

Function key ________ accesses the Go To command in Excel.

Question 61

________ arranges records in a table by the value in the field or fields within a table.

Question 62

The calculations on a total row in a table use the ________ function.

Question 63

To create a(n)________ from an existing range of data,click the Insert tab and then click Table in the Tables group.

Question 64

The use of field headings without row references in a structured formula is called a(n)________ reference.

Question 65

________ displays alternate fill colors for even and odd rows to help distinguish fields.

Question 66

In addition to sorting and filtering cells by content,you can sort and/or filter by ________ formatting.

Question 67

The ________ Table Style option displays the field names of a table when checked.

Question 68

Filtering the Last_Name field to show only records that begin with the letter P is an application of a(n)________ filter.

Question 69

A(n)________ is an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis.

Question 70

A(n)________ bar is a horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells.

Question 71

Sorting by ________ arranges data together for cells containing a particular fill or font color.

Question 72

A(n)________ row appears as the last row of a table to display summary statistics,such as a sum.

Question 73

A(n)________ structured reference is a structured formula that includes references,such as table numbers.

Question 74

Click the ________ tab and click Remove Duplicates to open the Remove Duplicates dialog box.

Question 75

A(n)________ is a space for an individual piece of data within a record,such as a street name.

Question 76

Each ________ in an Excel table represents a record.

Question 77

Print ________ is the sequence in which pages of a workbook are printed.

Question 78

To ________ a table into a range,click within the table,click the Table Tools Design tab,and from the Tools group,select Convert to Range.

Question 79

A(n)________ defines the range of data from a worksheet to print.

Question 80

The ________ Table Style option applies a different format to the first column of a table so that the row headings stand out.