MICROSOFT EXCEL
What is Microsoft Excel?
Microsoft Excel is a spreadsheet application developed
by Microsoft that allows users to organize, calculate,
analyze, and present data using rows, columns,
formulas, functions, tables, and charts.
Excel Part Meaning / Definition
The Title Bar is located at the top of the Excel window. It displays the name of the
Title Bar current workbook and the Microsoft Excel application. It also contains the Minimize,
Maximize/Restore, and Close buttons.
A small customizable toolbar located above or below the Ribbon. It provides quick
Quick Access Toolbar access to frequently used commands such as Save, Undo, and Redo, regardless of the
active tab.
The Ribbon is the main command area in Excel. It contains groups of tools and
Ribbon
commands organized into tabs, making it easier to create, edit, and format worksheets.
Tabs are categories on the Ribbon such as Home, Insert, Page Layout, Formulas, Data,
Tabs
Review, and View. Each tab contains related commands and tools for specific tasks.
The Name Box is located to the left of the Formula Bar. It displays the cell reference
Name Box (address) of the currently selected cell, such as A1 or C5. It can also be used to quickly
navigate to a specific cell or named range.
The Formula Bar is used to enter, edit, and view data or formulas in the active cell. Any
Formula Bar
text, number, or formula entered into a cell is displayed here.
Rows are the horizontal lines of cells in a worksheet. They are identified by numbers (1,
Rows
2, 3, 4, ...).
Columns are the vertical lines of cells in a worksheet. They are identified by letters (A,
Columns
B, C, D, ...).
A cell is the intersection of a row and a column. It is the basic unit where data such as
Cell text, numbers, dates, or formulas are entered. Each cell has a unique address (e.g., A1,
B5).
The Active Cell is the currently selected cell where data can be entered or edited. It is
Active Cell
highlighted with a thick border.
A worksheet is a single spreadsheet page within a workbook. It consists of rows,
Worksheet
columns, and cells used to organize and analyze data.
A workbook is an Excel file that contains one or more worksheets. For example,
Workbook
Student_Grades.xlsx is a workbook.
Sheet Tabs are located at the bottom of the workbook. They allow users to switch
Sheet Tabs between different worksheets, rename sheets, add new sheets, or delete existing
ones.
The Status Bar is located at the bottom of the Excel window. It displays information
Status Bar about the current worksheet, such as Ready, Average, Count, Sum, and other
worksheet statistics.
The Zoom Slider is located at the bottom-right corner of Excel. It allows users to zoom
Zoom Slider
in to enlarge the worksheet or zoom out to see more of the worksheet on the screen.
Columns = Letters (A to XFD)
Rows = Numbers (1 to 1,048,576)
Basic Excel Terms
Term Definition
Workbook Entire Excel file
Worksheet One sheet inside the workbook
Cell Intersection of row and column
Cell Reference Address of a cell (A1, B5)
Range Group of cells
Formula User-created calculation
Function Built-in formula
Label Text data
Value Numeric data
Fill Handle Used to copy formulas or data
Excel Formulas and Functions
What is a Formula?
A formula is an equation that performs
calculations using numbers or cell
references. Every formula in Excel must begin
with an equal sign (=).
Mathematical Operators in Excel
What is a Function?
A function is a predefined (built-in) formula in
Excel that performs a specific calculation
automatically.
Common Functions
SUM()
Adds numbers.
=SUM(B2:B10)
AVERAGE()
Computes average.
=AVERAGE(B2:B10)
MAX()
Highest value.
=MAX(B2:B10)
MIN()
Lowest value.
=MIN(B2:B10)
COUNT()
Counts numbers.
=COUNT(B2:B10)