MIS 1305 CH5 EXCEL VOCAB

DSUM function

a database function that is ideal for setting up a criteria range and then calculating the sum based on the filters within that criteria range.

Decision tree

a diagramming tool that allows you to break down potential decisions in a logical, structured format.

Conditional Aggregate Functions

a function that aggregates a subset of data that has been filtered based upon one or more criteria.

INDIRECT function

a function that can change a text string within a cell to a cell reference.

Complex function

a function that combines multiple functions within a formula.

NOT function

a function that is used when there are many options that fit the desired criteria and only one option that does not fit the criteria.

VLOOKUP function

a function that matches a provided value in a table of data and returns a value from a subsequent column. It also helps retrieve values located in another location and is used when your comparison values are located in a column—vertically—to the left of the data you want to find.

OR function

a function that returns TRUE if any one logical test supplied is true; otherwise, it returns FALSE.

Logical function

a function that returns a result, or output, based upon evaluating whether a logical test is true or false.

IF function

a function that returns one of two values depending upon whether the supplied logical test being evaluated is true or false.

Nested IF function

a function that uses IF functions as arguments within another IF function and increases the number of logical outcomes that can be expressed.

Conditional Math Function

a function that works in a similar fashion as statistical functions and include the SUMIF and SUMIFS functions.

IFERROR function

a function used for detecting an error and displaying something more user-friendly than the error message.

Competitive Advantage

a strategic advantage that a business has over its competition. Attaining a competitive advantage strengthens and positions a business better within the business environment.

Excel database

a way of storing data in Excel that is made up of records and fields.

COUNTIFS function

allows for multiple criteria in multiple ranges to be evaluated and counted.

Logical test

also known as a logical expression, an equation with comparison operators that can be evaluated as either true or false.

AVERAGEIFS function

averages a range of data, selecting data to average based on the criteria specified.

AVERAGEIF function

averages the number of cells that meet the specified criteria.

COUNTIF function

counts the number of cells that meet the specified criteria.

Static data

data that has been manually calculated and then typed into a worksheet.

HLOOKUP function

helps retrieve values located in another location and is used when your comparison values are located in a row—horizontally—above the data that you want to find.

MATCH function

looks for a value within a range and returns the position of that value within the range.

Double prime symbol

quotation marks that are used in functions and formulas to let Excel know that the element is a text string and not a numeric value, cell reference, or named range.

AND function

returns TRUE if all logical tests supplied are true; otherwise, it returns FALSE.

SUMIFS function

sums a range of data, selecting data to total based on the criteria specified.

SUMIF function

sums the number of cells that meets the specified criteria

Pseudocode

the rough draft of a formula or code. It is intended to help you understand the logic and determine the structure of a problem before you develop the actual formula.

A1 Reference Method

this refers to the way cell references are written. If letters appear for the column headings, the reference style for Excel is currently A1. In this mode, cells are referenced using a letter for the column and a number for the row.

R1C1 reference style

this refers to the way cell references are written. If numbers appear for the column headings, the reference style for Excel is currently R1C1.

Logical operator

used to create logical tests and includes <, >, <=, >=, and <>.

INDEX function

works in conjunction with the MATCH function; returns the value of an element in a table or array selected by the row and column number indices and has two argument lists to select.