Latest Episodes of Dramas - Latest Politics Shows - Latest Politics Discussions
Latest Columns


________________________________________________

Results 1 to 3 of 3
Discuss How to Make a Spreadsheet in Excel in Student Korner forum, in The Technology Basement category.
      
   
  1. #1
    A_Sayn's Avatar
    A_Sayn is offline Banned
    Edit>
     
    Join Date
    Apr 2006
    Location
    ghar main
    Posts
    18,302
    Blog Entries
    57
    Quoted
    0 Post(s)

    How to Make a Spreadsheet in Excel

    A spreadsheet is a great tool for adding the total cost of a series of items. This article explains how to make a basic spreadsheet in Microsoft Excel, using a simple expense report as an example.

    Open Excel

    Notice there are rows and columns.




    • Each column has a capital letter on the top to show what column it is.
    • Each row has a number to the immediate left of the first column, to show what row it is.
    • Each cell is identified by a unique address consisting of the column letter followed by the row number. For example, the address of the cell in the first column, first row is A1. The address of the cell in the second column, third row is B3.
    • If you click a cell, the cell address appears just above column A.

    Click cell A1 and type: Item.



    Click cell B1 and type: Cost.



    Click cell A2 and type: Printing.




    Click in cell B2 and type 80.00



    After you click outside of cell B2, 80 will show in cell B2.




    Click cell A3 and type: Postage.




    Click cell B3 and type: 75.55.





    After you click outside of cell B3, 75.55 will show in cell B3.




    Click cell A4 and type: Envelopes.





    Click cell B4 and type: 6.00.




    Click cell A5 and type: Total



    Click cell B5 and type: =SUM(B2:B4).




    Click in another cell. A total of 161.55 will show in cell B5.



    SUM(B2:B4) is a formula. Formulas are used to perform math functions in Excel. It is essential to put equals sign (=) just before a formula, so that Excel knows that it is a formula.

    Click Save.






    › See More: How to Make a Spreadsheet in Excel

    0 Not allowed!

  2. #2
    AnGeL Ey3s's Avatar
    AnGeL Ey3s is offline *~DeAtH~*
    Edit>
     
    Join Date
    Jun 2008
    Location
    germany
    Posts
    7,627
    Quoted
    0 Post(s)

    Re: How to Make a Spreadsheet in Excel

    ahaan thank you 4 sharing

    0 Not allowed!

  3. #3
    nabhia's Avatar
    nabhia is offline Genius Member
    Edit>
     
    Join Date
    May 2009
    Posts
    2,201
    Quoted
    0 Post(s)

    Re: How to Make a Spreadsheet in Excel

    Nice.........................

    0 Not allowed!
    Signature picture removed it was contradictory on some threads.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •