220711130044_Priya_Bag_MS_Excel_Internal_Assessment(1)[1].pptx

220711130044 Priya Bag MS Excel

1. Thank You

3. MICROSOFT EXCEL

* A spreadsheet application developed by Microsoft for
Microsoft Windows and Mac OS. - Microsoft Office Excel is a
powerful tool used to create and format spreadsheets.

* Spreadsheets allow information to be organized in rows and
tables and analyzed with automatic mathematics.

Spreadsheets are commonly be used to perform many

4. HOW TO LAUNCH MS EXCEL

To launch Microsoft Excel

* go to Start

* Search for All Programs
* Select Microsoft Office

* Click on Microsoft Excel, and a blank spreadsheet will open.

5. FORMAT EXTENSION FOR MS EXCEL

* Excel Workbook .xlsx

* Excel Macro-enabled Workbook .xlsm
* Excel Binary Workbook .xlsb

* Excel Macro-enabled Template .xltm

* Excel Add-in .xlam

6. MS EXCEL WINDOW

Quick Access Toolbar

Microsoft Office Button > Mini., Max. Close

Ribbon

Formula Bar
Select all button
Active Cea
Name box = z Vertical Scroll Box

Status Bar
Horizontal Scroll Box

Worksheets 1 Zoom Sider

View Options

7. Set Sont

BouGoutaecaa

va an
ne % eeo m

8. UNDERSTANDING THE SPREADSHEETS |

* A spreadsheet is a sheet which is spread in such a way that it
divides itself into the various horizontal row and vertical columns. It

is also called a worksheet.

* A worksheet consists of cells that are organized into columns and

rows;

* a worksheet is always stored in a workbook. Rows are numbered

from 1 to onwards and columns are numbered from A to onwards.

9. 3 BASIC FEATURES OF A WORKSHEET

* Rows — it refers to the horizontal cells which can contain

information.

* Columns — It refers to the vertical cells which can also contain

information.

* Cell — cells are the basic rectangular building blocks of a
spreadsheet. It is the intersection of a row with a column. Each cell

is identified with its position.

11. MS EXCEL FEATURES

* Auto fill: Excel feature that allows you to automatically copy cells
and fill them down or across a series of cells.

* Borders: Lines you may format around your cells or range of cells
to enhance the readability and/ or appearance of your
spreadsheet.

* Cell: A cell is the intersection of a row and a column. A cell can

contain a label, a numeric value, or a formula.

12. TERMS FOR MS EXCEL

* Absolute Cell Reference: formula refers to a specific cell location. Do change
when you copy and paste or fill them down or over. They are created by
adding a $ sign in front of each character in the cell address. For example,
$B$4 will always refer to cell B4.

* Active Cell: contains the insertion point and is identified by a dark border
around the cell. Its address (location) is shown in the formula bar. Any action

you perform is performed on the active cell,

* Arithmetic Operators: The characters used to calculate numbers within a
formula. Addition (+), B4, U2. A relative cell references changes when copied

and pasted to a new cell or is filled down a series of rows or across columns.

Wil // Il

13. COMPONENTS OF CHART IN EXCEL |

* Plot area: The area where Excel plots your data, including the
axes and all markers that represent data points.

* Gridlines: Optional lines extending from the tick marks across the
plot area, thus making it easier to view the data values
represented by the tick marks.

* Chart text: A label or title that you add to the chart.

* Legend: A key that identifies patterns, colors, or symbols
associated with the markers of a chart data series.