Module 6 Vocabulary

Question 1

Table

Answer 1

An organized collection of rows and columns of similarly structured data on a worksheet.

Question 2

Database

Answer 2

A collection of data organized in a manner that allows access, retrieval, and use of that data.

Question 3

Record

Answer 3

A row of data in a table, representing a complete set of field values for a specific person, place, object, event or idea; also called a tuple.

Question 4

Fields

Answer 4

A column containing a specific property for each record, such as a person, place, object, event, or idea.

Question 5

Banded Row

Answer 5

Rows in a table that are formatted in alternating colors.

Question 6

Table Array

Answer 6

A table of information in which data is looked up.

Question 7

Lookup Table

Answer 7

A table that stores the data you want to retrieve with a lookup function; also called a table array.

Question 8

HLOOKUP Function

Answer 8

Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array; used when comparison values are located in a row across the top of a table of data.

Question 9

VLOOKUP Function

Answer 9

A function that returns values from a vertical lookup table.

Question 10

Lookup Value

Answer 10

The value that is being looked up in a lookup table.

Question 11

Table Arguments

Answer 11

The left columns in a table array.

Question 12

Return Value

Answer 12

The data values being retrieved by the lookup function from a lookup table.

Question 13

Column Index Number

Answer 13

The column location of the return value within the table array.

Question 14

Calculated Field

Answer 14

A field whose values are not entered but calculated based on other fields.

Question 15

Computational Field

Answer 15

A table column or field that contains a formula, function, cell reference, structured reference, or condition.

Question 16

Structured Reference

Answer 16

A reference that allows table formulas to refer to table columns by names that are automatically generated when the table is created.

Question 17

Data Bars

Answer 17

In conditional cell formatting, colored horizontal rectangles in a cell; the larger the number, the wider the data bar.

Question 18

Sorting

Answer 18

To organize data, such as table rows, items in a list, or records in a mail merge, in ascending or descending order, based on criteria such as date, alphabetical order, file size, or filename.

Question 19

Ascending Order

Answer 19

The arrangement of text alphabetically from A to Z, numbers from smallest to largest, and dates from oldest to newest.

Question 20

Descending Order

Answer 20

Data sorted from highest to lowest, most recent to earliest, or alphabetically from Z to A.

Question 21

Sort Keys

Answer 21

The field or fields on which records are sorted in a query.

Question 22

Criteria

Answer 22

A logical rule by which data is tested and chosen.

Question 23

Query

Answer 23

A request for information from a data source.

Question 24

Search String

Answer 24

The sequence of letters you enter in a search box.

Question 25

Wildcard Characters

Answer 25

A special symbol that substitutes for unknown characters in search text; the most common are the question mark (?), which stands for any single character, and the asterisk (*), which represents any group of characters.

Question 26

Criteria Range

Answer 26

A location separate from the table used to list specific search specifications.

Question 27

Extract Range

Answer 27

A range in which Excel copies the records that meet the comparison criteria in the criteria range in a search or filter to another part of the worksheet.

Question 28

DAVERAGE Function

Answer 28

A function that calculates the average of numbers in a table field that pass a test.

Question 29

DCOUNT Function

Answer 29

A function that counts the number of numeric entries in a table field that pass a test.

Question 30

MATCH Function

Answer 30

The function that returns the position number of an item in a range or table.

Question 31

INDEX Function

Answer 31

An alphabetical list of terms and topics and the page numbers on which they appear; usually appearing at the end of a document.

Question 32

AND Function

Answer 32

A logical function that returns the word TRUE if both arguments are true.

Question 33

OR Function

Answer 33

A logical function that returns TRUE if either part of the condition is true.

Question 34

XOR Function

Answer 34

A rarely used logical function that returns TRUE if either argument is true, and returns FALSE if both are true or false.

Question 35

NOT Function

Answer 35

A logical function that uses a single argument and returns TRUE is the condition is false.

Question 36

TRANSPOSE Function

Answer 36

A function that lets you change the orientation of a range - that is, return a vertical range of cells as a horizontal range, or vice versa.

Question 37

AVERAGEIF Function

Answer 37

An Excel function that calculates the average of values within a range that meet multiple criteria.

Question 38

Control Field

Answer 38

A field on which you sort.

Question 39

Outline Symbols

Answer 39

In Outline view, the buttons that, when clicked, change the amount of detail that appears in the outlined worksheet.

Question 40

Treemap Chart

Answer 40

An Excel chart that provides a hierarchical, visual view of data, making it easy to spot patterns and trends.