Basic Excel Formulas Add, Subtract, Divide, Multiply

1. To add = cell1+cell 2 and press enter 2. To substract =cell1-cell2 3. To Divide =cell1/cell2 4. Multiply =Cell1*cell2

How to Use the IF Function in Excel?

1. Open excel.
2. Apply formula
3. =IF(logical_test,[value_if_true], [value_if_false])

How to Print Part of an Excel Spreadsheet?

Method 1: 1. Open excel. 2. Select the print area. 3. Click on file. 4. Click on print. 5. Select print selection. 6. Click on print. Method 2: 1. Select print area. 2. Click on page layout. 3. Click on print area. 4. Set print area. 5. Click on file. 6. Click on print. 7. Select print active sheets. 8. Click on print.

How to Add a Calculator to Microsoft Excel 2016?

1. Open microsoft excel. 2. Click on customise quick access tool bar. 3. Click on more command. 4. Select command not in the ribbon. 5. Click on calculator. 6. Click on add. 7. Click on ok.

How to Add Grid Lines to Your Excel Spreadsheet?

1. Open excel sheet. 2. Select sheet 1, 2 or 3. 3. Click on view. 4. Select show grid lines to show it.

How to Calculate Time on Excel Spreadsheet?

1. Click on file. 2. Click on new. 3. Search time sheet. 4. Select time sheet. 5. Click on create. 6. Enter details. 7. Click on file. 8. Click on save as. 9. Select location. 10. Enter file name. 11. Click on save.

How to Use the Lookup Function in Excel?

1. Open microsoft excel. 2. Fill details. 3. Select e1. 4. Click on data. 5. Click on data validation. 6. Select list. 7. Click on source. 8. Select a1 to a15. 9. Click on ok. 10. Click on f1. 11. Click on fx 12. Click on lookup and reference. 13. Click on lookup. 14. Click on ok. 15. Enter look up value,lookup vector,result vector. 16. Click on ok. Select value in e1 you can see value in f1.

How to Calculate an Interest Payment Using Microsoft Excel?

1. Open Microsoft excel. 2. Type principal,interest,period and payment. 3. Type principal amount. 4. Interest rate for each period. 5. Type period in B3 cell. 6. In B4 cell type formula =IPMT(B2, 1, B3, B1) and press enter.

How to Create an Image from a Excel Spreadsheet?

1. Select the part you want to create as image. 2. In the home Click on copy. 3. Click on copy as picture. 4. Click on ok. 5. Open where you want to paste picture. 6. Right click and click on paste.