Excel Interface

The Excel interface includes Ribbon, Name Box, Formula Bar, Worksheet, etc.

Cell

Intersection of row and column is called a cell. Each cell has a unique address.

Row

A horizontal line used to store data. Excel has 10,48,576 rows.

Column

A vertical line used to store data. Excel has 16,384 columns.

Worksheet

Area of rows and columns used to enter data.

Workbook

A file that contains multiple worksheets.

Cell Reference

Combination of row and column (Example: A1).

Active Cell

Currently selected cell.

Worksheet Tab

Tabs at bottom to switch sheets.

Formula

Used for calculations. Always starts with = sign.

Formula Bar

Used to enter data or formula.

Filter

Used to display selected data only.

Autofill

Used to copy data automatically.

AutoSum

Quickly add numbers using shortcut Alt + =.

Pivot Table

Used to summarize large data.

Mark as Complete ✅