• Shuffle
Toggle On
Toggle Off
• Alphabetize
Toggle On
Toggle Off
• Front First
Toggle On
Toggle Off
• Both Sides
Toggle On
Toggle Off
Toggle On
Toggle Off
Front

### How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

Play button

Play button

Progress

1/36

Click to flip

### 36 Cards in this Set

• Front
• Back
 A worksheet's row-and-column structure can be used to organize and store a _____. table Each row of an Excel worksheet used to create a table can store a record, and each column can store a(n) _____. field In a table, a column that contains formulas or functions is called a calculated _____. column In a table, or database, the data related to each person or item is called a _____. record A _____ should be formatted so that the records are easily distinguished. table Even though Excel is not a true _____ management system like Access, it does give you many of the same basic capabilities. database Which of the following is the path to the Format as Table button? (Home tab | Styles group) _____ causes adjacent rows to have different formatting so that each row in the table is distinguished from surrounding rows. Row banding A _____ column is a column in a table in which each row uses a common formula that references other fields in the table. calculated To change an active table back to a normal range of cells, right-click the table, point to Table on the shortcut menu, and then click _____ on the Table submenu. Convert to Range The _____ function is used when the table direction is horizontal. HLOOKUP The _____ function is used when a table direction is vertical. VLOOKUP Why is the VLOOKUP function used more often than other lookup functions? because most tables are vertical A value being looked up outside the range of the table causes the VLOOKUP function to return the _____ error message. #N/A The VLOOKUP function searches the far-left column of the _____. table array For the VLOOKUP function to work correctly, the table _____ must be in ascending sequence. arguments The table_array contains what are called table _____. The table_array contains what are called table _____. The general form of the VLOOKUP function is _____. =VLOOKUP(lookup_value, table_array, col_index_num) You can hide columns in a table by pressing the _____ keyboard shortcut keys. CTRL+0 If columns contain sensitive information, such as salary information, you can _____ the columns. hide Which of the following is the path to the Lookup & Reference button? (Formulas tab | Function Library group) _____ formatting allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell. Conditional Conditional formatting allows you to create _____ that change the formatting of a cell or range of cells based on the value of a cell. rules Which of the following is a type of conditional formatting? All of the above The Conditional Formatting _____ dialog box displays all of the rules for the current selection or for the entire workbook. Rules Manager Which of the following is the path to the Total Row check box? (Table Tools Design tab | Table Style Options group) Data is in _____ sequence if it is in order from lowest to highest. ascending The field or fields selected for sorting records are called ____ keys. sort Which of the following is the path to the Sort & Filter button? (Home tab | Editing group) The process of a filtering activity based on one or more filter criteria is called a _____. query You can display all records in the table after a query hid some of the records by clicking the Filter button on the _____. (Data tab | Sort & Filter group) The values _____ satisfy a custom filter criteria that displays records in which the Experience field contains a value greater than or equal to 3 and less than or equal to 5. 3, 4, 5 Like the AutoFilter query technique, the _____ command displays a subset of the table. Advanced Filter _____ records allows you to pull data from a table so that you can analyze or manipulate the data further. Extracting The comparison criteria in the _____ range determine the records that will pass the test when the Advanced Filter dialog box is used. criteria Excel includes _____ database functions that allow you to evaluate numeric data in a table. 12