Excel Lesson 3 Expert

What is the parameters of a function?

• Arguments

• Criterion

• Condition

A formula in which the result is determined by the presence or absence of a particular condition.

• Conditonal Formula

• Argument Formula

• Criterion Formula

A condition you specify to limit which records are returned when filtering data.

• Criteria

• Query

• Filter

An efficient way to search for and insert a value in a cell when the desired value is stored elsewhere in the worksheet or even in a different workbook.

• Lookup Function

• Search Function

• CONCATENATE Function

A range of cells in a worksheet that contains related data and can be used by a lookup function.

• Table

• Field

• Set

• Row

Data in a table arranged in rows and columns. A table of text, numbers, or values that you use for the formula.

• Table array

• Table set

• Table range

Name of the dialog box that enables you to create, edit, delete, and filter range names in a workbook.

• Name Manager

• Rules Manager

• Range Manager

Excel functions returns both the current date and time in a cell.

• NOW

• PRESENT

• TODAY

• CURRENT

Argument in both the VLOOKUP and HLOOKUP function syntax refers to the range in which you want to look up data. Hint: it is arranged in rows and columns

• Table Array

• Spreadsheet

• Table Set

• Table Range

AND, OR, and NOT functions are included in which category of Excel functions

• Math and Trig

• Logical

• True/False

• Discrete Math