Unit G: Managing Data Using Tables

Question 1

Table

Answer 1

organized collection of rows and columns of similarly structured worksheet data

Question 2

Record

Answer 2

table row that contains data about an object, person, or other item

Question 3

Fields

Answer 3

columns in the table; each field describes a characteristic of the record

Question 4

Field Name

Answer 4

column label

Question 5

Header Row

Answer 5

contains the field names

Question 6

Planning a table

Answer 6

• identify the purpose
• plan the structure
• plan your row and column structure
• document the table design

Question 7

Identify the purpose

Answer 7

determines the kind of information the table should contain

Question 8

Plan the structure

Answer 8

determine the fields you need to achieve the tables purpose

Question 9

Plan row and column structure

Answer 9

all rows have similar types of info in the same column, no blank rows or columns

Question 10

Document the design

Answer 10

make a list of the field names to document the type of data and any special number formatting required for each field, field names should be as short as possible while still accurately describing the info.

Question 11

Table Styles

Answer 11

allow you to easily add formatting to your table by using preset formatting combinations of fill color, borders, type style, and type color.

Question 12

Banding

Answer 12

creates different formatting for adjacent rows and columns

Question 13

Wildcards

Answer 13

special symbols that substitute for unknown characters

Question 14

*

Answer 14

one or more characters meaning that the search text “ir*” will find “iron, hair, bird”

Question 15

?

Answer 15

any single unknown character. “to?” “top & tot” not “tone”

Question 16

sort

Answer 16

change the order of the records using this feature

Question 17

Ascending order

Answer 17

lowest value (A, or earliest date) appears at the top of the table

Question 18

Descending order

Answer 18

highest value (Z, or latest date) appears at the top of the table

Question 19

Multilevel sort

Answer 19

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

Question 20

Calculated columns

Answer 20

fills the remaining cells with the formula’s results. The column continues to fill with the formula resoles as you enter rows in the table

Question 21

Structured reference

Answer 21

allows your formula to refer to table columns by names that are automatically generated when you create the table. These names adjust as you add or delete table fields (ex. =[Sales]-[Costs], where sales and costs are field names

Question 22

Table total row

Answer 22

specific area at the bottom of the table for calculations using the data in the table columns

Question 23

Print title

Answer 23

prints at the top of every page