To create a formula with references highlight the cells you want to use then select an empty cell and enter the formula. Type in a blank cell where you want the remainder to appear click the cell for the number you want to divide type click the cell for the number you want to divide by and then hit enter. Burn to learn focuses on a simple way to solve this problem.
Then press ENTER and Excel instantly calculates and displays the result of the formula.
Now write the range of sum or you can select the range by using the mouse to drag. If you want to add substract multiply or divide or do any basic math operation to a excel matrix. That tells Excel that this cell will contain a formula. These problems and puzzles will put your deductive reasoning ability to the test and reinforce your mathematical skills.