1. To add
= cell1+cell 2 and press enter
2. To substract
=cell1-cell2
3. To Divide
=cell1/cell2
4. Multiply
=Cell1*cell2
Showing posts with label microsoft excel. Show all posts
Showing posts with label microsoft excel. Show all posts
Thursday, 28 March 2019
Monday, 18 March 2019
How to Create a Currency Converter With Microsoft Excel?
1. Open excel.
2. Write euro, dollar and rate.
3. Make column of euro and dollar.
4. Write 1 to 10 in dollar column.
5. Enter formula in euro column.
Thursday, 14 March 2019
How to Make Tables Using Microsoft Excel?
1. Open your excel file.
2. Select cells to make table.
3. Click on insert.
4. Click on table.
5. Click on ok.
6. Select style.
7. In design you can select or unselect options.
8. Click on small arrow to filter data.
9. Filter data
Thursday, 27 December 2018
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.
Monday, 24 December 2018
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.
Wednesday, 19 December 2018
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.
Subscribe to:
Posts (Atom)