1 / 13

RAJUK UTTARA MODEL COLLEGE

Learn about spreadsheets and how they are used for calculations. See the advantages of using spreadsheets and the various software options available. Follow a step-by-step guide on using Microsoft Excel. Practice creating a marks sheet and performing calculations.

maximom
Download Presentation

RAJUK UTTARA MODEL COLLEGE

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. RAJUK UTTARA MODEL COLLEGE CLASS: VIII SUBJECT : ICT

  2. CHAPTER: 04 USE OF SPREADSHEET

  3. Using symbols on Bark of trees, on stones etc. First attempt of counting by human being using ….. Abacus Counting approaches of human being More advantages in calculation using… Still problems in big calculation and solved by……….

  4. Concept of spreadsheet • Now software based spreadsheet has replaced the paper based spreadsheet. • Visicalc (invented by apple in late 70s) • Lotus 1-2-3(Text based), • Microsoft Excel, • Open office calc, kspread. Lexicographic meaning is…. A paper big in size and spread

  5. It is a kind of application program used to perform any type of calculation including simple and complex. What is spreadsheet Program ? It is called workbook. worksheet. Rows and columns Cells Cell: The rectangular regions are called cells

  6. COLUMNS(A, B, C, D,…XFD) ROWS(1,2,3,4….1048576) TOTAL COLUMNS=16384 TOTAL ROWS=? Fig. a workbook/spreadsheet

  7. Step-3 Step-2 Step-4 How to Use Spreadsheet Step-1

  8. Microsoft Excel 2007 window Title bar Office button Ribbon Quick access Toolbar Sheet tab Formula bar Status bar

  9. In How to open New Worksheet Click Office button Click new button

  10. Technique of Using New Spreadsheet software Problem: Prepare a marksheet for Kamal Roll:102 who scored 70 in Bangla, 80 in English, 90 in Math, 85 in G.Sc, and 45 in ICT. Also calculate total marks. Solution: Step-1:Open a new worksheet Step-2: Click on A1 cell and Type Name Step3: Click on B1 cell and type Kamal Step-4: Click on A2 cell and type Roll Step-5: Click on B2 cell and type 102 Step-6: Click on A3 cell and type Bangla, on A4 cell type English, on A5 cell type Math, on A6 cell type G.Sc and on A7 cell type ICT

  11. Problem: Prepare a marksheet for Kamal Roll:102 who scored 70 in Bangla, 80 in English, 90 in Math, 85 in G.Sc, and 45 in ICT. Also calculate total marks. Continued from prev. slide Step-7 Click on B3 cell and type 70, on B4 cell type 80, on B5 cell type 90, on B6 cell type 85 and on B7 cell type 45 Step-8: Click on A8 cell and Type Total Step-9: Click on B8 cell and type =sum(B3:B7) and press enter Step-10: So Total 370 will be displayed on B8 cell. We can also type=B3+B4+B5+B6+B7to calculate total marks

  12. Arithmetical function of Spreadsheet program • Summation can be done in two ways: • 1. By pressing auto sum • 2. By writing formula Subtraction • Subtraction process is same as summation , but there is no way of auto subtraction • Example: To subtract cell values of D2 from D3 we have to write =D3-D2 in the destination cell/formula bar

  13. THANK YOU

More Related