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.
