Excel Test

Columns

Vertical sections in a spreadsheet identified by letters (A, B, C).

Rows

Horizontal sections in a spreadsheet identified by numbers (1, 2, 3).

Cell

The intersection of a row and a column.

Active Cell

The cell currently selected, outlined by a thick border.

Range

A group of cells, written with a colon (e.g., A1:C5 means all cells from A1 to C5).

Worksheets

Individual pages of a file; the Workbook is the entire file.

Labels

Text entries that Excel does not use for calculations.

Values

Numbers that can be used in formulas.

Formula Bar

Shows the underlying data or formula of the selected cell.

Cell Alignment

Options include Left, Center, Right, and Merge & Center.

Number Formatting

Allows changing how values appear without altering the actual number.

AutoFill

Quickly copies patterns, dates, or formulas into neighboring cells.

Equal Sign (=)

The mandatory first character of any calculation.

Cell References

Using a cell's name in a formula instead of the number, allowing automatic updates.

Operator Order

Excel follows PEMDAS (Parentheses, Exponents, Multiplication/Division, Addition/Subtraction).

SUM Function

Efficiently adds a long list of numbers.

AVERAGE Function

Calculates the arithmetic mean of a range.

MIN and MAX

Identify the lowest and highest values in a set of data.

COUNT

Tells how many cells in a range contain numbers.

Column/Bar Charts

Best for comparing different categories.

Line Charts

Best for showing data that changes over time.

Pie Charts

Used to show parts of a whole or percentages of a total.

Legend

The key that explains what different colors or patterns on a chart represent.

Ctrl + Z

Shortcut to undo the last action.

Ctrl + ` (Tilde)

Shows all formulas on the entire sheet at once.

Error

Occurs when a column is too narrow to display the number inside.

DIV/0! Error

Occurs when a formula tries to divide a number by zero.