Module 3 Excel Definitions

Question 1

absolute cell reference

Answer 1

A cell reference that does not change when the formula containing that reference is moved to a new location.

Question 2

approximate match lookup

Answer 2

A lookup where the lookup value falls within a range of numbers in the compare values in the lookup table.

Question 3

argument

Answer 3

The numbers, text, or cell references used by the function to return a value

Question 4

AutoFill

Answer 4

A feature that enters formula or data patterns into a selected range based on the content of the starting cells in the range.

Question 5

compare values

Answer 5

The categories in a lookup table that are used for matching to a specified lookup value.

Question 6

comparison operator

Answer 6

A symbol that indicates the relationship between two values.

Question 7

constant

Answer 7

A value in a formula that doesn’t change.

Question 8

COUNT function

Answer 8

The Excel function that tallies how many cells in specified range contain numbers or dates.

Question 9

error value

Answer 9

A message in a cell that indicates some part of a formula is preventing Excel from returning a calculated value.

Question 10

exact match lookup

Answer 10

A lookup where the lookup value must exactly match one of the compare values in the lookup table.

Question 11

fill handle

Answer 11

A box that appears in the lower-right corner of a selected cell or range.

Question 12

Goal Seek

Answer 12

A feature that automates the trial-and-error process by allowing you to specify a value for the calculated item, which Excel uses to determine the input value needed to reach that goal.

Question 13

horizontal lookup table

Answer 13

A lookup table in which the compare values are located in the first row.

Question 14

IF function

Answer 14

A logical function that tests a condition and then returns one value if the condition is true and another value if the condition is false.

Question 15

logical function

Answer 15

A function that returns a different value depending on whether the given condition is true or false.

Question 16

lookup function

Answer 16

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

Question 17

lookup table

Answer 17

A table that stores the data you want to retrieve with a lookup function.

Question 18

lookup value

Answer 18

MAX function

Question 19

MEDIAN function

Answer 19

A function that returns the middle value in a range.

Question 20

MIN function

Answer 20

A function that returns the minimum value in the range.

Question 21

mixed reference

Answer 21

A cell reference that has both absolute and relative components.

Question 22

relative cell reference

Answer 22

A cell reference that changes when the formula containing that reference is moved to a new location.

Question 23

required argument

Answer 23

An argument that is needed for the function to return a value

Question 24

return values

Answer 24

The data values you want to retrieve from a lookup table.

Question 25

significant digits

Answer 25

The number of digits that should be displayed for a calculation; they indicate the accuracy of the measured and calculated values.

Question 26

TODAY function

Answer 26

A date function that returns the current date.

Question 27

vertical lookup table

Answer 27

A table used to retrieve data based on matching the category values found in the first column of the table.

Question 28

VLOOKUP function

Answer 28

A function that returns values from a vertical lookup table.

Question 29

WORKDAY function

Answer 29

A function that displays the date of a weekday that is a specified number of weekdays past a starting date.