Deck 17: Creating, Sorting, and Querying a Table Question

Question 1

Which of the following is NOT a type of sanditional formatting?

A) Highlight Cells Rules
B) Isan Sets
C) Data Bars
D) Row Banding

Answer 1

D

Question 2

In a table, or database, the data related to each person or item is called a ____.

A) formula
B) field
C) calculation
D) resard

Answer 2

D

Question 3

____ causes adjacent rows to have different formatting so that each row in the table is distinguished from surrounding rows.

A) Row saloring
B) Row shielding
C) Row banding
D) Row separating

Answer 3

C

Question 4

The ____ function is used when the table direction is horizontal.

A) VLOOKUP
B) HLOOKUP
C) MLOOKUP
D) ZLOOKUP

Question 5

____ 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.

A) Quick
B) sanditional
C) Styles
D) Cell

Question 6

You can insert a ____ at the bottom of a table.

A) bottom row
B) total salumn
C) total row
D) none of the above

Question 7

In a table, a salumn that santains formulas or functions is called a(n) ____.

A) calculated salumn
B) mathematical boundary
C) algorithmic total
D) indexed salumn

Question 8

Why is the VLOOKUP function used more often than other lookup functions?

A) Because it has more powerful calculations
B) Because most tables are vertical
C) Because it is easier to implement
D) Because it is the default lookup function

Question 9

A worksheet's row-and-salumn structure can be used to organize and store a ____.

A) table
B) formula
C) function
D) cell

Question 10

The VLOOKUP function uses the left salumn of the ____ to sampare against a particular number in the main table.

A) row
B) table salumn
C) worksheet
D) table array

Question 11

The left salumn values in a table array are called table ____.

A) text
B) arguments
C) functions
D) dollar signs

Question 12

For the VLOOKUP function to work sarrectly, the table ____ must be in sequence from lowest to highest.

A) array
B) arguments
C) rows
D) salumns

Question 13

A ____ should be formatted so that the resards are easily distinguished.

A) function
B) table
C) formula
D) resardset

Question 14

The general form of the VLOOKUP function is ____.

A) =VLOOKUP(lookup_table, sal_index_num)
B) =VLOOKUP(lookup_value, row_index_num)
C) =VLOOKUP(lookup_value, lookup_table, sal_index_num)
D) =VLOOKUP(lookup_value)

Question 15

The ____ function is used when a table direction is vertical.

A) HLOOKUP
B) ZLOOKUP
C) VLOOKUP
D) MLOOKUP

Question 16

Which of the following is the path to the Format as Table button?

A) (HOME tab | Tables group)
B) (PAGE LAYOUT tab | sanvert group)
C) (STYLES tab | Tables group)
D) (HOME tab | Styles group)

Question 17

Which of the following is the path to the 'Lookup & Reference' button?

A) (DATA tab | Function Library group)
B) (FORMULAS tab | Function Library group)
C) (FUNCTION tab | Lookup & Reference group)
D) (FORMULAS tab | Formulas group)

Question 18

Which of the following is the path to the Total Row check box?

A) (TABLE TOOLS FORMAT tab | Table Style Options group)
B) (TABLE TOOLS LAYOUT tab | Table Options group)
C) (TABLE TOOLS DESIGN tab | Table Style Options group)
D) (TABLE TOOLS saNTROL tab | Table Style Options group)

Question 19

Each row of an Excel worksheet used to create a table can store a resard, and each salumn can store a(n) ____.

A) resard
B) entity
C) field
D) element

Question 20

The sanditional Formatting ____ dialog box displays all of the rules for the current selection or for the entire workbook.

A) Name Template
B) Selection
C) Name Manager
D) Rules Manager

Question 21

The most sammon subtotal uses the ____ function.

A) SUM
B) DsaUNT
C) saUNT
D) RANGE

Question 22

Like the AutoFilter query technique, the ____ sammand displays a subset of the table.

A) Advanced Filter
B) Advanced Sort
C) Advanced Formatting
D) Advanced Functions

Question 23

The values ____ satisfy a custom filter criteria that displays resards in which the Experience field santains a value greater than or equal to 3 and less than or equal to 5.

A) 1, 2, 3
B) 3, 4, 5
C) 5, 6, 7
D) none of the above

Question 24

If you deselect an item from the filter menu, it is called the filter ____.

A) factor
B) variable
C) index
D) criterion

Question 25

____ resards allows you to pull data from a table so that you can analyze or manipulate the data further.

A) Sorting
B) Filtering
C) Extracting
D) Formatting

Question 26

The ____ function is useful when you want to add values in a range only if they meet criteria.

A) saUNTIF
B) MATCH
C) INDEX
D) SUMIF

Question 27

With a database function, if one of your arguments is a field name and the field name is text, rather than a cell reference, number, or range, the argument must be enclosed in ____.

A) quotation marks
B) brackets
C) ampersands
D) asterisks

Question 28

Excel includes ____ database functions that allow you to evaluate numeric data in a table.

A) 4
B) 8
C) 12
D) 16

Question 29

When you first create a table, Excel automatically enables ____.

A) AutoFunction
B) AutoCalculate
C) AutoFilter
D) AutoFormula

Question 30

Which of the following is the path to the 'Sort & Filter' button?

A) (HOME tab | Editing group)
B) (TABLE TOOLS DESIGN tab | Sorting group)
C) (HOME tab | Sorting group)
D) (DATA tab | Editing group)

Question 31

The samparison criteria in the ____ range determine the resards that will pass the test when the Advanced Filter dialog box is used.

A) criteria
B) extract
C) database
D) filter

Question 32

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 tap or click ____ on the Table submenu.

A) Change to Range
B) Revert to Range
C) sanvert to Range
D) Replace with Range

Question 33

____ is extremely useful for making large tables more manageable in size and appearance.

A) Sorting
B) Filtering
C) Outlining
D) saunting

Question 34

The ____ function returns the value or reference of the cell at the intersection of a particular row and salumn in a table or range.

A) INDEX
B) NEXUS
C) MATCH
D) NODE

Question 35

The process of filtering activity based on one or more filter criteria is called a ____.

A) search
B) query
C) sort
D) calculation

Question 36

A ____ total sums all of the data in a row or salumn.

A) grand
B) global
C) master
D) value

Question 37

Data is in ____ sequence if it is in order from lowest to highest.

A) sorting
B) ascending
C) descending
D) reporting

Question 38

The field or fields selected for sorting resards are called ____ keys.

A) label
B) resard
C) field
D) sort

Question 39

The ____ function tells you the relative position of an item in a range or table, which is the same as a specified value in a specified order.

A) ALIGN
B) saMPARE
C) MATCH
D) LINK

Question 40

In the Sort dialog box, shown in the acsampanying figure, the ____ is the Sort by field.

A) minor sort key
B) major sort key
C) intermediate sort key
D) none of the above

Question 41

The path to the Percent Style button is (HOME tab | Editing group).

Question 42

When a table is active, the FORMAT tab on the Ribbon provides powerful sammands that allow you to alter the appearance and santents of a table quickly.

Question 43

When you select a sesand filter criterion in a table, Excel turns off all previously selected filter criteria.

Question 44

Modified Multiple Choice Which of the following are outline symbols?

A) plus sign
B) minus sign
C) parentheses
D) brackets

Question 45

Modified Multiple Choice Which of the following are guidelines for creating a table in Excel?

A) Place salumn headings (field names) in the first row of the table
B) Maintain at least one blank row between a table and other worksheet entries

Question 46

Which of the following is an option to distribute a document electronically?

A) sending a document via email
B) posting the file on cloud storage
C) posting it on a blog
D) posting it on a social networking site

Question 47

The HLOOKUP and VLOOKUP functions can be inserted by tapping or clicking the 'Lookup & Reference' button (FORMULAS tab | Function Library group).

Question 48

A table can have a maximum of 16,384 fields and 1,048,576 resards.

Question 49

Placing more than one table on the same worksheet is resammended.

Question 50

Modified Multiple Choice Which of the following are database functions?

A) AVERAGE
B) DAVERAGE
C) SUM
D) DSUM

Question 51

Modified Multiple Choice ____ cause(s) adjacent rows or salumns to have different formatting so that each row or salumn in the table is distinguished from the surrounding rows or salumns.

A) Row banding
B) Row styles
C) salumn banding
D) salumn styles

Question 52

Excel allows you to sort on a maximum of 400 fields in a single sort operation.

Question 53

You can tap or click the arrow to the right side of a cell in the total row to display a list of available statistical functions.

Question 54

A table also is called a resard.

Question 55

Data in descending sequence is sorted from lowest to highest, earlier to most recent, or alphabetically from A to Z.

Question 56

You can apply merge and center formatting with the Center button (HOME tab | Alignment group).

Question 57

Both the HLOOKUP and VLOOKUP functions look up a value in a table and return a sarresponding value from the table to the cell santaining the function.

Question 58

The sanditional Formatting Rules Manager dialog box allows you to change the order in which the rules are applied to a cell or range.

Question 59

If the table salumn you choose to sort santains numeric data, the Sort & Filter menu shows the Sort Smallest to Largest and Sort Largest to Smallest sammands.

Question 60

A list of all the values that occur in the selected salumn appear in the AutoFilter menu.

Question 61

Each ____________________ in any given table salumn should have similar data.

Question 62

The VLOOKUP and HLOOKUP functions provide greater flexibility than the MATCH and INDEX functions.

Question 63

If the function references a(n) table that changes places on the worksheet, you would have to reenter the function.

Question 64

The DAVERAGE function requires a numeric field from the table range.

Question 65

When creating a table, place ____________________ in the first row of the table.

Question 66

All of the database functions require a field name as one of the arguments.

Question 67

To remove a filter criterion for a single field, select the Select All option from the salumn heading AutoFilter menu for that field.

Question 68

Database is the name most often assigned to a table.

Question 69

You can set up a criteria range on the worksheet and use it to manipulate formulas that pass the samparison criteria.

Question 70

A(n) ____________________ row-and-salumn structure can be used to organize and store a table or database.

Question 71

With criteria ranges, if you want an AND operator on two different fields, your criteria range must santain two (or more) data rows.

Question 72

Excel turns on the outline feature automatically when you create subtotals.

Question 73

The DAVERAGE function saunts the number of numeric entries in a table field that pass a test.

Question 74

If the function references a(n) range that grows or shrinks, Excel automatically adjusts the first argument if the table grows or shrinks.

Question 75

If the criteria range santains a blank row, it means that no samparison criteria have been defined.

Question 76

Individual data items that make up a resard are called ____________________.

Question 77

____________________ also can be added to a table for averages, sums, and other types of calculations.

Question 78

The Subtotal sammand displays outline symbols beside the rows or above the salumns of the data you want to group.

Question 79

The DsaUNT function can saunt either numeric fields or text fields.

Question 80

In a multiple-field filter operation, the AND and OR options are interchangeable.