Tuesday, February 20, 2024

How to create any mathematics tables with excel...

 

Generate any tables with excel...

1.       Go to excel sheet, in first cell ‘A1’ enter the number whose table you want to generate, for example I want to generate table of 19, so write ‘19’ in ‘A1’

2.       In cell ‘B1’ write multiplication sign ‘*’

3.       In cell ‘C1’ write ‘1’ [table starts from 1, or the number from where you want to start]

4.       In cell ‘D1’ write ‘=’

5.       In cell ‘E1’ write the answer '19' ie. ‘19*1=19’



6.       In below row as well from cell ‘A2’ to ‘E2’ repeat just update cell ‘C2’ as ‘2’,  and ‘E2’  as ‘38’ ’ because this row is ‘19*2=38’[here we try to educate excel with our data, so that it can generate further data that you need]



7.       And now select both rows you added data for and just drag down till where you want generate the table




8.       Your table is ready, in this way you can generate table of any number



 


How to create any mathematics tables with excel...

  Generate any tables with excel... 1.        Go to excel sheet, in first cell ‘A1’ enter the number whose table you want to generate, for...