Fill in the Blanks: Module 6 Vocab


Fill in the Blanks Module 6 VocabOnline version Excel by Audra Graves 1 Banded Row A is rows in a table that are formatted in alternating colors . 2 Lookup Functions is a function that retrieves a value that matches a specified condition from a table of data . 3 Table Lookup A is a table that stores the data you want to retrieve with a lookup function ; also called a table array . 4 FUNCTION XLOOKUP The searches for a value in a lookup table or range and returns a corresponding value to the cell containing the function . 5 HLOOKUP Function The searches for a value in the top row of a lookup table , and then searches down a specified number of rows to return a corresponding value in the same column . 6 Function VLOOKUP The searches for a value in a column of a lookup table , and then searches a specified number of columns to the right to return a value in the same row . 7 Value Lookup The is the value that is being looked up in a lookup table . 8 Value Return The is the data values being retrieved by the lookup function from a lookup table . 9 Field Calculated A is a field whose values are not entered but calculated based on other fields . 10 Field Computational A is a table column or field that contains a formula , function , cell reference , structured reference , or condition . 11 Reference Structured A is a reference that allows table formulas to refer to table columns by names that are automatically generated when the table is created . 12 Bars Data is a conditional cell formatting , colored horizontal rectangles in a cell ; the larger the number , the wider the data bar . 13 Sortin Arranging records in a specific sequence is called 14 order Ascending is the arrangement of text alphabetically from A to Z , numbers from smallest to largest , and dates from oldest to newest . 15 order Descending is sorted from highest to lowest , most recent to earliest , or alphabetically from Z to A . 16 Key Sort The field or fields you select to sort are called 17 String Search The sequence of data you enter is called the . 18 Characters Wildcard is 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 . 19 Criteria A Range is a location separate from the table used to list specific search specifications . 20 Extract Range An is 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 . 21 Function DAVERAGE A is a function that calculates the average of numbers in a table field that pass a test . 22 Function DCOUNT The is the function that counts the number of numeric entries in a table field that pass a test . 23 Function MATCH The is the function that returns the position number of an item in a range or table . 24 Function AVERAGEIF The is an Excel function that calculates the average of values within a range that meet multiple criteria . 25 Control Field For subtotals , the field on which you sort is called the . 26 Symbols Outline The are the buttons that , when clicked , change the amount of detail that appears in the outlined worksheet . 27 Chart Treemap A provides a hierarchical , visual view of data , making it easy to spot patterns and trends .

1

Banded Row

A is rows in a table that are formatted in alternating colors .

2

Lookup Functions

is a function that retrieves a value that matches a specified condition from a table of data .

3

Table Lookup

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

4

FUNCTION XLOOKUP

The searches for a value in a lookup table or range and returns a corresponding value to the cell containing the function .

5

HLOOKUP Function

The searches for a value in the top row of a lookup table , and then searches down a specified number of rows to return a corresponding value in the same column .

6

Function VLOOKUP

The searches for a value in a column of a lookup table , and then searches a specified number of columns to the right to return a value in the same row .

7

Value Lookup

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

8

Value Return

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

9

Field Calculated

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

10

Field Computational

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

11

Reference Structured

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

12

Bars Data

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

13

Sortin

Arranging records in a specific sequence is called

14

order Ascending

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

15

order Descending

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

16

Key Sort

The field or fields you select to sort are called

17

String Search

The sequence of data you enter is called the .

18

Characters Wildcard

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

19

Criteria

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

20

Extract Range

An is 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 .

21

Function DAVERAGE

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

22

Function DCOUNT

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

23

Function MATCH

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

24

Function AVERAGEIF

The is an Excel function that calculates the average of values within a range that meet multiple criteria .

25

Control Field

For subtotals , the field on which you sort is called the .

26

Symbols Outline

The are the buttons that , when clicked , change the amount of detail that appears in the outlined worksheet .

27

Chart Treemap

A provides a hierarchical , visual view of data , making it easy to spot patterns and trends .

		%
	Anonymous	%
		%
		%

Module 6 Vocab