Today’s post is another extension of our series on flash cards. Since we made our multiplication flash cards last, the division flash cards were easy to make by reversing the multiplication answers:
We basically need double the flash cards since 20 divided by 5 and 20 divided by 4 are two different problems, whereas 4×5 and 5×4 are effectively the same.
Download the printable division flash cards spreadsheet here:
Today we’ll build a dedicated division spreadsheet, where we set parameters for the problems and print an unlimited number of different division worksheets.
The inputs we’ll allow the user to enter are the maximum dividend (number to be divided) size, the maximum divisor, and whether or not we want to have the answers be able to have remainders.
So if the user selects yes or “y” for the remainder, the problem is relatively simple – we’ll have a random number for the answer between (1,100) for the dividend, and then a random number between (1,10) for the divisor.
If the user selects “n”, we’ll have a random number between (1,10) for the divisor, and then a random number between 1 and the max dividend/current divisor for the answer, then we’ll multiply the answer by the divisor to get the dividend.
Here’s how it looks like in full:
You can download the printable Microsoft Excel file here:
“Investment bankers – they make a lot of money, but when you consider how many hours they work, it’s basically minimum wage” – Quora user
This will be a simple spreadsheet to either prove or disprove that statement. The only logic we’ll employ here is the power of division. Continue reading “Calculate how much an investment banker makes per hour”
Today is March 14. 3.14. Pi Day! Google spreadsheet offers a function that will return the value of pi to 14 decimal points. In a Google spreadsheet template, type = PI() and the output is 3.14159265358979. In Excel the same function = PI() returns the value of pi to 9 decimal points. Continue reading “Happy Pi Day”
How many cubic feet of sand can a pyramid hold? Did you know that it is exactly 1/3 of the volume of a rectangular prism with the same height, base, and width as the pyramid? Let’s use spreadsheets to confirm this and calculate the volume of other geometric solids.
There are many ways to skin a cat, so the saying goes. In spreadsheets, there are multiple ways to achieve the same result when performing an operation – such as addition, division, equal to, etc. 
See below to view our 3-minute video tutorial and reference chart. Continue reading “Spreadsheet Operators Tutorial”
Know the rules of the order of operations? A central concept in pre-algebra/algebra, these rules clarify which actions in any algebraic expression should be performed first. Let’s review what the rules are and why they are important. Then, you can test your knowledge with a spreadsheet quiz! Continue reading “Take the ‘Order of Operations’ Spreadsheet Quiz!”
What do sunflowers, shells, honeybees, the Parthenon, and human arm length measurements have in common? All reflect a remarkable pattern of numbers. Now just where does this intriguing sequence of numbers come about? Let’s discover the Fibonacci sequence and the Golden Ratio and how we can use spreadsheets to calculate them! Continue reading “Fibonacci and the Golden Ratio in Spreadsheets”
Ever heard of the philosopher and mathematician, Pythagoras of the 6th century BC? Perhaps you’ve come across one his most famous theorems during your geometry class. The Pythagorean Theorem states that in a right triangle, the sum of the legs squared is equal to the hypotenuse squared.
