Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
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
|