Deck 14: Excel 2013 : Managing Data Using Tables

Question 1

Inserting extra spaces at the beginning of a cell entry in a table can affect sorting and finding data later.

Answer 1

True

Question 2

Records are composed of ____.

A) databases
B) fields
C) worksheets
D) files

Answer 2

B

Question 3

The Find and Replace dialog box can be opened by clicking the Find & Select button in the Editing group.

Answer 3

True

Question 4

In addition to using Excel's spreadsheet feature,you can analyze and manipulate data using a ____ structure.

A) table
B) record
C) field
D) workbook

Question 5

Tables are organized into rows,called ____.

A) values
B) labels
C) fields
D) records

Question 6

You can add new rows to a table by typing data directly below the last row,and then pressing [Tab].

Question 7

The Wildcard dialog box helps you find records in a table.

Question 8

The first row of a table that contains field names is called a ____.

A) title row
B) table title
C) header row
D) row

Question 9

When you create a table,Excel automatically applies a default table style.

Question 10

Which of the following is NOT a guideline you should follow when planning a table?

A) Plan and design your table so that all rows have similar items in the same column.
B) Avoid blank columns.
C) Avoid blank rows.
D) Use a variety of formats for all cells in a column.

Question 11

Tables are organized into records which are composed of fields.

Question 12

A ____ is a column in a table that describes a characteristic about a record.

A) field
B) label
C) value
D) header

Question 13

The question mark (?)wildcard stands for any single character.

Question 14

Field names should be similar to cell addresses,such as G2.

Question 15

The wildcard asterisk (*)always represents one single character.

Question 16

To delete a table row,place the cursor in any cell in the row you wish to delete,then click Delete Table Rows from the Delete list arrow in the Cells group.

Question 17

You can add new rows and columns to a data table by dragging the sizing handle in the table's lower-right corner.

Question 18

You should not have any blank columns or rows in your table.

Question 19

Records are columns in a table that describe a characteristic about a field,such as a customer's last name or street address.

Question 20

The Match case option in the Find and Replace dialog box is used to search for duplicate records.

Question 21

In the accompanying figure,the header row is in row ____.

A) 1
B) 2
C) 3
D) 4

Question 22

A multilevel sort calls for using the ____ feature.

A) multi-sort
B) alpha-sort
C) custom sort
D) data sort

Question 23

Which of the following is NOT a guideline when naming a field?

A) Field names should be short.
B) Field names should be unique.
C) Use numbers to name fields.
D) Use descriptive names.

Question 24

Which wildcard symbol is a substitute for any single character?

A) ?
B) *
C) #
D) @

Question 25

If Denise specifies Jan? as a search criterion,Excel will locate all of the following records EXCEPT ____.

A) Janet
B) Jane
C) Jani
D) Jany

Question 26

You can ____ a table field if the information stored in a field becomes unnecessary.

A) block
B) freeze
C) remove
D) hide

Question 27

In the accompanying figure,how many records are in the table?

A) 2
B) 3
C) 4
D) 5

Question 28

In the accompanying figure,the first row of the table is called a ____ row.

A) total
B) field
C) header
D) tools

Question 29

If Denise specifies Jan* as a search criterion,which of the following will Excel locate?

A) Jane
B) Janet
C) January
D) All of the above.

Question 30

In a table,what appears in the cell of a column header?

A) Sort list arrow
B) Style list arrow
C) Filter list arrow
D) Formula list arrow

Question 31

The Remove Duplicates button is found on the ____ tab.

A) TABLE TOOLS DESIGN
B) DATA
C) HOME
D) FILE

Question 32

To add an additional record to a table,type below the last record,then press ____.

A) [Enter]
B) [Tab]
C) [Insert]
D) [Ctrl]

Question 33

The Print Titles button is on the ____ tab.

A) HOME
B) INSERT
C) PAGE LAYOUT
D) TABLE OPTIONS

Question 34

Which of the following is NOT included in a table style?

A) type color
B) borders
C) pattern fills
D) fill color

Question 35

In the accompanying figure,the filter list arrow appears next to each ____ header.

A) field
B) column
C) row
D) title

Question 36

In the accompanying figure,row 5 is called a ____ row.

A) record
B) table total
C) header
D) blank

Question 37

Which wildcard symbol is a substitute for one or more characters?

A) ?
B) *
C) #
D) @

Question 38

You can easily format a table using table ____.

A) styles
B) galleries
C) fields
D) themes

Question 39

In the accompanying figure,how many fields are in the table?

A) 12
B) 13
C) 4
D) 5

Question 40

To see additional table styles,click the Table Styles ____ button.

A) Plus
B) Advanced
C) Extras
D) More

Question 41

In the accompanying figure,which item should you click to replace all occurrences of the choice in the Find what text box with the text entered in the Replace with text box?

A) 1
B) 2
C) 3
D) 4

Question 42

In the accompanying figure,how many records are in the table?

A) 7
B) 8
C) 9
D) 10

Question 43

In the accompanying figure,where should you make an entry of I* to find all states that start with the letter I?

A) 5
B) 2
C) 3
D) 4

Question 44

Table ____________________ allow you to easily format a table.

Question 45

Which tab contains the print options for gridlines and headings?

A) HOME
B) INSERT
C) PAGE LAYOUT
D) TABLE OPTIONS

Question 46

A column label that describes a field is known as the field ____________________.

Question 47

Which feature do you use to add summary information to the end of a table?

A) Total Row check box in the Table Style Options group
B) Summary Row check box in the Table Style Options group
C) AVERAGE Row check box in the Table Style Options group
D) Field Summary check box in the Table Style Options group

Question 48

C,B,A is an example of a(n)____________________ alphabetic sort order.

Question 49

The ____ feature allows formulas to refer to table columns by names that are automatically generated when you create a table.

A) calculated formula
B) structured reference
C) sort by name
D) structured name

Question 50

Where do you commonly add new records to an Excel table?

A) Between the header row and the first record.
B) Below the last row of the existing table.
C) To the right of the header row.
D) Above the header row.

Question 51

In the accompanying figure,which item should you click to replace the current item that matched the Find what text box with the text entered in the Replace with text box?

A) 1
B) 2
C) 3
D) 4

Question 52

A column in a table that describes a characteristic about a record is called a(n)____________________.

Question 53

In the accompanying figure,which item should you click to make sure your find and replace operation respected capitalization?

A) 1
B) 2
C) 3
D) 4

Question 54

____________________ list arrows automatically appear in the column header cells when you create a table.

Question 55

The print title prints at the top of every ____.

A) header
B) row
C) page
D) record

Question 56

After you enter a single formula into a table cell,the ____ feature fills in the remaining cells with the formula's results.

A) structured reference
B) calculated columns
C) table styles
D) absolute reference

Question 57

In the accompanying figure,what field is used as the sorting field?

A) Tour
B) Depart Date
C) Number of Days
D) Seat Capacity

Question 58

A(n)____________________ sort rearranges table data using more than one field,where each field is a different level,based on its importance in the sort.

Question 59

A(n)____________________ is a table row that contains data about an object,person,or other type of item.

Question 60

In the accompanying figure,how many fields are in the table?

A) 2
B) 4
C) 7
D) 9

Question 61

You can include capitalization as a sort criterion by clicking Options in the Sort dialog box,then selecting the ____________________ sensitive check box.

Question 62

Dennis wants to search his table for all customers whose last name is Johnson and Johnsen.What should Dennis do in order to find all the customers that fall into this category?

Question 63

Lily asks you if it is possible to sort the records in her table first by state,then by Zip code.What will you tell her?

Question 64

Because tables often have more rows than can fit on a page,you can define the first row of a table as the print ____________________,which prints at the top of every page.

Question 65

Explain the structured reference feature in Excel.Give an example.

Question 66

You can use Excel's ____________________ feature to rearrange the order in which records in your table appear.

Question 67

The ____________________ reference feature allows your formulas to refer to table columns by name.

Question 68

Explain calculated columns.