HOW TO CREATE AN EXCEL SPREADSHEET WITH FORMULAS?
SPREADSHEET
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,
- 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,
- 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,
- 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