Exam 14: Excel 2013 : Managing Data Using Tables

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

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

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

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

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

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

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

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?

The Print Titles button is on the ____ tab.

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

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

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

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

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

Tables are organized into rows,called ____.

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

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

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

-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?

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