Microsoft Excel Fundamentals Flashcard Set

Vocabulary flashcards reviewing core topics in Microsoft Excel including interface components, spreadsheet operations, cell references, functions, multi-sheet linking, and chart types.

Bar Chart

A chart type used to compare values between different categories.

Pie Chart

A chart type used to show how different categories make up a whole or percentage share.

Line Chart

A chart type used to show changes or trends over a period of time.

Chart Title

A chart element that tells the reader what the chart is about.

Data Labels

Chart elements that display actual values or percentages.

Cross-sheet Reference

A reference format such as $\text{SheetName!CellReference}$ that allows users to use data from one worksheet in another worksheet.

3-D Reference

A range reference across consecutive worksheets, such as $=SUM(January:March!B2)$.

Formula

A user-created expression used to calculate values in Excel, always beginning with an equal sign ($=$).

Function

A predefined formula in Excel that performs calculations using specific values called arguments.

SUM Function

A function that adds numbers together using the syntax $=SUM(\text{number1}, \text{number2}, \dots)$.

AVERAGE Function

A function that calculates the mean value of numbers using the syntax $=AVERAGE(\text{range})$.

IF Function

A logical function that checks whether a condition is true or false using the syntax $=IF(\text{logical\_test}, \text{value\_if\_true}, \text{value\_if\_false})$.

COUNTIF Function

A logical function that counts cells meeting a specific condition using the syntax $=COUNTIF(\text{range}, \text{criteria})$.

AutoFill

An Excel feature that quickly copies patterns or formulas by dragging the fill handle.

Row

A horizontal line in a worksheet identified by numbers ($1, 2, 3\dots$).

Column

A vertical line in a worksheet identified by letters ($A, B, C\dots$).

Cell

The intersection of a row and a column in a worksheet where data is stored.

Active Cell

The currently selected cell in a worksheet, characterized by a highlighted border and readiness for data entry.

Referenced Cell

A cell used inside a formula, such as $A1$ and $B1$ in $=A1+B1$.

Merged Cell

A single cell created by combining multiple cells together, such as merging $A1:C1$ for a title.

Relative Cell Reference

A cell reference that changes automatically when copied to another position.

Absolute Cell Reference

A cell reference that remains fixed when copied, denoted with dollar signs such as $\$A\$2$.

Wrap Text

A formatting tool that allows long text to fit inside a single cell.

Title Bar

An interface element located at the top of the screen that displays the workbook name, application title, and window controls.

Quick Access Toolbar

A toolbar containing frequently used commands such as Save, Undo, and Redo.

Ribbon

An interface element containing tabs and groups of commands organized for navigation.

Name Box

An interface element that displays the address of the active cell.

Formula Bar

An interface element that displays and allows users to edit data or formulas entered into cells.

Worksheet Area

The main workspace in Microsoft Excel consisting of intersecting rows and columns.

Sheet Tabs

Tabs located at the bottom of the worksheet area used to switch between different worksheets.

.xlsx

The standard file format for Microsoft Excel workbooks.