Featured

How to create an excel spreadsheet with formulas

How to create an excel spreadsheet with formulas?

Spreadsheet

Spreadsheet is a kind of computer program. Its dictionary means spreading or large-sized paper. Microsoft Excel is the built-in Microsoft Corporation spreadsheet resolution Program. This program is distributed with the Microsoft Office Suite. Excel makes it easy to crunch numbers.Using Microsoft excel, different calculations can be used with mathematics,statistics,Logic. It sometimes called Workbook. There are many rows and columns of Worksheets.

 

How to Open spreadsheet Application

  • Click the Start button
  • You got a “All Programs” Button
  • Click There And you Also Got a “Microsoft Office 2013”
  • Click “Microsoft Excel 2013” in the list that appears.

 

Create spreadsheet files and enter numbers,Text and symbols into cells according to information requirements:

The following picture is shown with a spreadsheets document number,text etc.

How to create an excel spreadsheet with formulas

                                                                                                                   Microsoft Excel screen

Enter simple formulas and functions using cell referencing where required:

 

Adding numbers with formula:

create a workbook below as an example to add the formula to the axes,and to extract the F2 cell’s added from of data in B2 to E2 range

How to create an excel spreadsheet with formulas

 

 

 

  • To keep the cell pointer in the F2 cell
  • =Sum(B2:E2) type this and click Enter so come out F2 result

Another Formula For Adding Numbers:

  • To keep the cell pointer in the F2 cell
  • =B2+C2+D2+E2 Type this and click Enter so come out F2 result

Next step out of result in other cells:

  • To keep the cell pointer in the F2 cell then copy click from Edit Menu
  • Hi-light the F4 from F3
  • Then past click from Edit Menu

 

Formula of Subtraction:

For example below for doing subtraction in excel create a workbook below and subtraction the data in the D2 cells from the cell of the C2 cell to extract the results out of the E2 cell,

How to create an excel spreadsheet with formulas

 

 

 

 

  • To keep the cell pointer on E2 cells
  • =C2-D2 type this and click enter then come out result in E2 cells

Next step out of result in other cells

  • To keep the cell pointer in the E2 cell then copy click from Edit Menu
  • Hi-light the E5 from E3
  • Then past click from Edit Menu

 

Formula of multiply

To multiply all the numbers in column A by cell D2, add $ symbols to the cell reference like this: $D$2, which you can see in the example below,

How to create an excel spreadsheet with formulas

 

 

 

 

 

  • To keep the cell pointer on D2
  • =B2*C2 type this and click Enter then come out result in D2 cells

Next step out of result in other cells

  • To keep the cell pointer in the D2 cell then copy click from Edit Menu
  • Hi-light the D6 from D3
  • Then past click from Edit Menu.

 

Formula of Divide

Need data entry in a sheet like this following,

How to create an excel spreadsheet with formulas

  • Type =C2+D2+E2+F2 in cells G and press Enter
  • You will get total score
  • To keep cell pointer on H2 cell then type G2/4 and press Enter
  • So Result will come out
Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

Most Popular

To Top