Info Systems Exam #2

Name Box

Displays the cell reference or the name of a selected cell or range.

Formula Bar

The area where you enter or edit formulas or data in a cell, displaying the contents of the active cell.

Active Cell

The currently selected cell in the worksheet, indicated by a bold border.

Equal Sign (=)

Essential to begin any formula or function in Excel, without which the entry is treated as text.

Number Formats

Formats that determine how numbers are displayed in Excel, including General, Accounting, Currency, Percent, etc.

Formula

A user-defined calculation in Excel, e.g., =A1+B1.

Function

A pre-defined formula in Excel, such as SUM(A1:A10).

Order of Operations (PEMDAS)

The order in which calculations are performed: Parentheses, Exponents, Multiplication and Division, Addition and Subtraction.

Relative References

Cell references that change when copied to another cell, e.g., A1.

Absolute References

Cell references that remain constant when copied, indicated by dollar signs ($), e.g., $A$1.

Mixed References

Combination of relative and absolute references; either the row or the column is fixed, e.g., $A1 or A$1.

VLOOKUP

A function that looks up a value in a table array and returns a corresponding value; understand its arguments.

IF

A function used to create logical tests, with parameters for value_if_true and value_if_false.

MIN

A function that returns the smallest number in a set of values.

MAX

A function that returns the largest number in a set of values.

SUM

A function that adds all the numbers in a range of cells.

AVERAGE

A function that calculates the average of a set of numbers.

Logical Operators

Used in functions like IF to create logical expressions, including =, >, <, >=, <=, and <>.