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.