ms- excel spread sheet program component of ms-office suite performs calculations, maintaining...
TRANSCRIPT
![Page 1: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/1.jpg)
MS- Excel
• Spread sheet Program• Component of MS-Office suite• Performs Calculations, Maintaining Databases
and Summary Reports• Graphs
![Page 2: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/2.jpg)
Spreadsheet
• It is a Grid that organizes data into columns and rows
• Spreadsheet make it easy to display information
• We can insert formulas to work with the data• Eg Auto Sum• Information can be sorted as well as filtered
![Page 3: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/3.jpg)
Spreadsheet
• Each value is stored in a cell
![Page 4: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/4.jpg)
Uses of Spreadsheet
• A businessman can store Journals entries, Legder etc
• Balance Sheet
![Page 5: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/5.jpg)
MS-Excel
• CREATE A SPREADSHEET CONTAING DATA OF 10 STUDENTS IN 5 SUBJECTS
• WRITE STUDENT NAMES COLUMN-WISE• MARKS ROW WISE
![Page 6: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/6.jpg)
Microsoft Excel Window
• Worksheet is divided into multiple cells• Cell is an intersection of a row and a column• Each cell has a unique name and a cell address• 256 columns represented by labels A,B…• 65536 rows represented by numbers 1,2…
![Page 7: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/7.jpg)
256 Columns
![Page 8: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/8.jpg)
65536 Rows
![Page 9: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/9.jpg)
Active Cell
• Data is always entered in an active cell i.e a cell with thick border when we click with mouse pointer
• By default A1 is active cell
![Page 10: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/10.jpg)
Cell Address
![Page 11: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/11.jpg)
Workbook
• Default file name is book1
![Page 12: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/12.jpg)
Using Formula
![Page 13: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/13.jpg)
![Page 14: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/14.jpg)
![Page 15: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/15.jpg)
![Page 16: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/16.jpg)
![Page 17: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/17.jpg)
![Page 18: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/18.jpg)
Worksheets
![Page 19: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/19.jpg)
Functions• Max()• Min()• Date()• Count()• CountIf()• Sqrt()• SumIf()• Mode()• Median()• Mean()
![Page 20: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/20.jpg)
Max()
• Returns the largest Value from the numbers provided
• =max(cell,cell,cell)
![Page 21: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/21.jpg)
Min()
• Returns the smallest Value from the numbers provided
• =min(cell,cell,cell)
![Page 22: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/22.jpg)
Date()
• Date• Date(year,month,day)• =date(2003,10,23)
![Page 23: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/23.jpg)
Count()
• Returns the number of cells that contain numbers
• =count(cell:cell)
![Page 24: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/24.jpg)
CountIf()
• Returns the number of cells in a range that meets a given criteria
• =countIf(range,criteria)• =countif(cell:cell, criteria)• =countif(a1:a5, b1)• =Countif(a1:a5, “>=200”)
![Page 25: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/25.jpg)
Sqrt()
• Returns the square root of a number• =sqrt(cell)• Sqrt(number)
![Page 26: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/26.jpg)
SumIf()
• Adds all numbers in a range of cells, based on a given criteria
• =sumif(range, “criteria” sum_range)• =sumif(a2:a6, “>=200”, c2:c6)• Values in the range c2:c6 will be added if the
criteria is met
![Page 27: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/27.jpg)
Median()
• Half numbers have values greater and half have values less than the median
• =median(cell:cell)
![Page 28: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/28.jpg)
Mode()
• Most frequently occuring or repetitive value• =mode(cell:cell)
![Page 29: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/29.jpg)
Average()
• Returns the Average• =average(cell:cell)
![Page 30: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/30.jpg)
![Page 31: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/31.jpg)
![Page 32: MS- Excel Spread sheet Program Component of MS-Office suite Performs Calculations, Maintaining Databases and Summary Reports Graphs](https://reader035.vdocuments.us/reader035/viewer/2022062511/551bbbca550346c3588b4712/html5/thumbnails/32.jpg)
• Count• Min• Max• Average• Sum