Scribd
Upload
204 views12 pages

Unit 3 Introduction To Ms-Excel

The document discusses spreadsheets and their business applications in MS Excel. Some key points: 1) MS Excel is a useful tool for calculations like payroll, accounting, and loan repayment schedules. It allows listing elements and entering direct values or formulas. 2) Excel has built-in functions like financial and IF functions that can perform complex calculations with formulas. 3) Formulas can use absolute cell references so contents don't change when copied. The document provides an overview of spreadsheets and their functionality in Excel for business and financial applications.

Uploaded by

Komal Nandan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
204 views12 pages

Unit 3 Introduction To Ms-Excel

The document discusses spreadsheets and their business applications in MS Excel. Some key points: 1) MS Excel is a useful tool for calculations like payroll, accounting, and loan repayment schedules. It allows listing elements and entering direct values or formulas. 2) Excel has built-in functions like financial and IF functions that can perform complex calculations with formulas. 3) Formulas can use absolute cell references so contents don't change when copied. The document provides an overview of spreadsheets and their functionality in Excel for business and financial applications.

Uploaded by

Komal Nandan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 12

Unit 3

Spreadsheet and its Business Applications

Presented by :
Ms. Sushmita Chakraborty
Assistant Professor
Department of MCA
Patna Women’s College
 MS-Excel is an easy and useful tool for various
calculations carried out on spreadsheets. Some of
the examples are Payroll Calculation, Fixed Asset
Accounting, and Loan Repayment Schedule.
 The first step in using spreadsheet is to list out the
elements of the application. For each element, it is
determined whether a direct value is to be entered
or else it is to be computed using a formula.
 Excel has a rich library of various built-in functions
including financial functions, which can be directly
used to carry out various (otherwise complex)
calculations. A formula may use one or more such
functions.
 In these applications, some of the formulae use
absolute address. The absolute address is used for
those cells whose content should not change while
the formula containing such cells is copied to other
cells.
 If-function is also used in these applications. If-
function is used to implement different action
corresponding to different conditions.
 The function PMT is used to compute the loan
repayment schedule.
An arrangement of cells in columns and rows
used to organize, analyze, calculate, and report
information, usually in numerical form

What is a Workbook ?

A File which contains one or more spreadsheets


is called as workbook. It consists of Sheet1
through Sheetn where n is a number. Each
worksheet is independent of the other.
Rows, columns and cells
 Horizontal rows are labelled 1, 2, 3, 4, … and
vertical columns are labelled A, B, C, D, …
 The intersection of a row and a column is called
a cell.
 The cell at the intersection of column A and row
1 is referred to as A1.
 The highlighted rectangle on the screen is called
the cell pointer and the cell containing the cell
pointer is called the active cell.
 Note that Excel 97-2003 contains 256 columns
labelled A, B, C, …, AA, AB, …, AZ, …, BA, BB, BC,
…, BZ, CA, CB, CC, …, CZ, …. and it contains 65
536 rows labelled from 1 to 65 536
Version Rows Columns Cells Sheets
Excel 2019 1,048,576 16,384 XFD 17,179,869,1 *
16.0.6742.2048 84

Excel 2016 1,048,576 16,384 XFD 17,179,869,1 *


84

Excel 2013 1,048,576 16,384 XFD 17,179,869,1 *


84

Excel 2007 1,048,576 16,384 XFD 17,179,869,1 *


84

Excel 2003 and 65,536 256 16,777,216 *


earlier
Standard toolbar
The Standard toolbar provides easy access to frequently used
functions such as save, cut, copy, paste, etc.

Formatting toolbar
The Formatting toolbar provides easy access to commands such
as bold, italics, font, alignment of text, etc.
Two of the data types that can be entered into the
individual cells of the worksheet are:
 Text (labels) - used to make a worksheet more
readable by identifying rows and columns.
 Numbers (values) - the numeric characters 0, 1, 2,
3, 4, 5, 6, 7, 8 and 9 are used to write numbers in
the cells. The numbers can also begin with a + or –
symbol.
The points won by David and Peter in table-tennis
match are shown in the table below.

On your spreadsheet, enter this data as follows:


 To key in David, move the cell pointer to B1 and type David. Then
press Enter.
 To key in Peter, move the cell pointer to C1 and type Peter. Then
press Enter.
 To key in 15, move the cell pointer to B2 and type 15. Then press Enter.
 To key in 21, move the cell pointer to B3 and type 21. Then press Enter.
 Similarly, we can enter the remaining data.
• To erase a mistake made while keying in data, use
the Backspace key.
• To replace data already entered with other data, move the
cell pointer to the cell and type the new data. Then
press Enter. The new data will be displayed in the cell.

Erasing the contents of a cell


To erase the contents of a cell, move the cell pointer to the
cell concerned and press the Delete key. Note that if data is
deleted accidentally, the last item deleted can be recovered
by pressing Ctrl + Z or by clicking the Undo button.

You might also like