Skip to main content

HOW TO CREATE AN EXCEL SPREADSHEET WITH FORMULAS

HOW TO CREATE AN EXCEL SPREADSHEET WITH FORMULAS?

SPREADSHEET

How to create an excel spreadsheet with formulas

Spreadsheet is a kind of computer program. Its dictionary indicates spreading out or large-sized paper. MicrosoftExcel is the integrated Microsoft Corporation spreadsheet resolution Program. This program is dispersed with the Microsoft Workplace Suite. Excel makes it simple to crunch numbers.Using Microsoft stand out, various calculations can be utilized with mathematics, data, Reasoning. It in some cases called Workbook. There are numerous 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.

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

  • 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

Popular posts from this blog

Double Meaning Jokes for WhatsApp and Facebook IN ENGLISH

Here are some  English version of these adult jokes, Just relax and keep scowling don until you have stomach pain and you ll be force to send these Message to your close friends you can share with your friends and to comment if you want more. HINDI VERSION WILL BE COMING SOON

Top 10 Websites for Watching Bollywood Movies Online for Free in HD

Hike Messenger for Java Phones .JAR File Free full Download

Hike Messenger is all brand-new Instantaneous messaging application much like Whats app and also Facebook messenger that has in fact gotten big charm considering that its launch time with over countless hike joined individuals worldwide. Specifically exactly what Hike messenger provided in the social networking was the absolutely complimentary talk time offers or benefits for each and every new signup and also new recommendations that generated countless individuals and also it was really a wonderful idea from the Walk Developers which assisted a great deal to increase Hike Messenger downloads in such a competitive app market.