The intersection of a row and column in a spreadsheet where data is entered. Each cell has a unique address (like A1, B2, C3) based on its column letter and row number.

Horizontal lines in a spreadsheet identified by numbers (1, 2, 3, etc.). Each row runs left to right across the spreadsheet and contains multiple cells.

Vertical lines in a spreadsheet identified by letters (A, B, C, etc.). Each column runs top to bottom and contains multiple cells stacked vertically.

Equations that perform calculations in Excel. Formulas always begin with an equals sign (=) and can include cell references, numbers, and mathematical operators (e.g., =A1+B1 or =SUM(A1:A10)).

Pre-built formulas in Excel that perform specific tasks. Common functions include SUM (adds numbers), AVERAGE (finds the mean), COUNT (counts cells with data), and MAX/MIN (finds highest/lowest values).

Data Types (Text vs. Numbers)

Different categories of information in Excel. Text data includes letters and words (like names or descriptions), while numeric data includes numbers used for calculations. Excel treats these differently—numbers can be calculated; text cannot.

Changing the appearance of cells and data without changing the actual content. Examples include making text bold, changing font size, adding color, formatting numbers as currency or percentages, and adjusting cell borders.

Arranging data in a specific order—usually alphabetically (A-Z or Z-A) or numerically (smallest to largest or vice versa). Sorting helps organize and find information quickly in a spreadsheet.

Temporarily hiding rows that don't meet certain criteria to display only the data you want to see. Filters help you focus on specific information without deleting or changing the original data.

Text or information placed at the top of each column in a spreadsheet to label what data that column contains (e.g., "Name," "Age," "Sales"). Headers help organize and identify data.

Information placed at the bottom of a printed spreadsheet or page, such as page numbers, dates, or file names. Footers appear on every printed page and help with document organization.

Help

Options

focusNode

Didn't know it?
click below

Knew it?
click below

Don't Know

Remaining cards (0)

Know

retry

shuffle

restart

0:00

Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

Normal Size Small Size show me how

Excel Vocabulary

Formative Assessment on Excel Terms and Definitions

Term	Definition
Cell	The intersection of a row and column in a spreadsheet where data is entered. Each cell has a unique address (like A1, B2, C3) based on its column letter and row number.
Rows	Horizontal lines in a spreadsheet identified by numbers (1, 2, 3, etc.). Each row runs left to right across the spreadsheet and contains multiple cells.
Columns	Vertical lines in a spreadsheet identified by letters (A, B, C, etc.). Each column runs top to bottom and contains multiple cells stacked vertically.
Formulas	Equations that perform calculations in Excel. Formulas always begin with an equals sign (=) and can include cell references, numbers, and mathematical operators (e.g., =A1+B1 or =SUM(A1:A10)).
Functions	Pre-built formulas in Excel that perform specific tasks. Common functions include SUM (adds numbers), AVERAGE (finds the mean), COUNT (counts cells with data), and MAX/MIN (finds highest/lowest values).
Data Types (Text vs. Numbers)	Different categories of information in Excel. Text data includes letters and words (like names or descriptions), while numeric data includes numbers used for calculations. Excel treats these differently—numbers can be calculated; text cannot.
Formatting	Changing the appearance of cells and data without changing the actual content. Examples include making text bold, changing font size, adding color, formatting numbers as currency or percentages, and adjusting cell borders.
Sorting	Arranging data in a specific order—usually alphabetically (A-Z or Z-A) or numerically (smallest to largest or vice versa). Sorting helps organize and find information quickly in a spreadsheet.
Filtering	Temporarily hiding rows that don't meet certain criteria to display only the data you want to see. Filters help you focus on specific information without deleting or changing the original data.
Headers	Text or information placed at the top of each column in a spreadsheet to label what data that column contains (e.g., "Name," "Age," "Sales"). Headers help organize and identify data.
Footers	Information placed at the bottom of a printed spreadsheet or page, such as page numbers, dates, or file names. Footers appear on every printed page and help with document organization.

Created by: user-2045010

"Know" box contains:
Time elapsed:
Retries: