Excel Formulas and Functions Flashcards

Vocabulary flashcards reviewing basic Excel formulas, functions, operators, and formatting rules based on lecture notes.

SUM

An Excel function with the formula format =SUM (range) that adds all numbers in a selected range (e.g., =SUM(B2:B10)).

AVERAGE

An Excel function with the formula format =AVERAGE (range) that finds the mathematical mean of a range of numbers (e.g., =AVERAGE(B2:B10)).

MIN

An Excel function with the formula format =MIN(range) that identifies the lowest value in a set of data (e.g., =MIN(B2:B10)).

MAX

An Excel function with the formula format =MAX(range) that identifies the highest value in a set of data (e.g., =MAX(B2:B10)).

COUNT

An Excel function with the formula format =COUNT(range) that counts how many cells contain numbers (e.g., =COUNT(B2:B10)).

COUNTA

An Excel function with the formula format =COUNTA(range) that counts all cells that are not empty, including numbers and text (e.g., =COUNTA(A2:A10)).

IF

An Excel function with the formula format =IF(test, true, false) that checks if a condition is met and returns one value if true, another if false (e.g., =IF(B2>=75,"Passed","Failed")).

VLOOKUP

An Excel function with the formula format =VLOOKUP(value, table, col) that searches for a specific piece of data in a table and brings back related info (e.g., =VLOOKUP(A2,F2:H10,2,FALSE)).

CONCAT

An Excel function with the formula format =CONCAT(text1, text2) that joins two or more pieces of text from different cells into one (e.g., =CONCAT(A2," ",B2)).

Equal Sign (=)

The character that indicates an entry is a formula; every Excel formula starts with this symbol.

Parentheses ( )

Characters in Excel that enclose the arguments used by a function and control the order of operations in formulas.

Colon (:)

The character in Excel formulas that represents a continuous range of cells (e.g., A1:A10).

Comma (,)

The character in Excel formulas that separates multiple arguments inside a function.

Addition (+)

The operator in Excel formulas used to add values (e.g., =A1+B1).

Subtraction (-)

The operator in Excel formulas used to subtract values (e.g., =A1-B1).

Multiplication (*)

The operator in Excel formulas used to multiply values (e.g., =A1*B1).

Division (/)

The operator in Excel formulas used to divide values (e.g., =A1/B1).

Exponent (^)

The operator in Excel formulas used to raise a number to a power (e.g., =A1^2).

Cell Reference

Also known as a Cell Address, it identifies the location of data in Excel (e.g., A1, B5, C10).

Function Name

A built-in formula in Excel that performs a specific calculation (e.g., SUM, MAX, IF).