Chapter 2

Question 1

Argument

Answer 1

The value that an excel function uses to perform calculations or operations

Question 2

Filtering

Answer 2

The process of displaying only a portion of the data based on matching specific value to show only the data that meets the criteria specified

Question 3

NOW function

Answer 3

The function that retrieves and then displays the date and time from the computer.

Question 4

Conditional Format

Answer 4

A format that changes the appearance of a cell based on conditions

Question 5

IF function

Answer 5

A function thats uses a logical test to check whether a condition is met, and then returned one value if true and another if value is false

Question 6

Logic Test

Answer 6

any value that can evaluate as being true or false

Question 7

COUNTIF function

Answer 7

A statistic function that counts the number of cells within a range that meet the given condition and which has two arguments the range cells to check and the criteria

Question 8

Criteria

Answer 8

Condition that you specify in a logic function

Question 9

Function

Answer 9

A predefined formula that adds all the numbers in a selected range