• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
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

image

Play button

image

Play button

image

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