Have you ever wondered how to calculate the volume of a geometric figure using Excel? the truth, the form and the method with which this task is carried out is simple and quite dynamic, if you use the appropriate steps within the Excel spreadsheets quickly.
This shows that Excel has multiple functions for solving equations and financial operations , for learning and understanding various complex situations. Likewise, if there are difficulties in understanding how the volume of a geometric figure is calculated, here you will find everything you need.
What is a cube or hexahedron?
It is known as a geometric figure which is combined by three dimensions, whose faces are proportionate and which, furthermore, can be classified as a parallelepiped, since all of its faces are square and parallel two by two.
How can you calculate the volume of the cube on a spreadsheet?
Now, a spreadsheet is often useful simply to make a list or pivot tables with ease , but likewise, a Word page can do it with the same accuracy, however, Excel offers us much more.
But the real heart of the sheet calculation is the same calculation as it is programmed to do math operations in small or large amounts immediately.
Having this order of ideas, in a spreadsheet you can write these three types of things to generate to make an order of the data and start the calculation operations which are;
- Words, texts
- Numbers (172507)
- Formulas (= 4/5 )
The third type is the one used to perform the calculation operation for the volume of the cube, starting with this sign “= 1” in this way Excel, knows that it will start mathematical operations.
Using the calculator to write formulas
It is common to write formulas in Excel, with numbers to perform a task and it is essential to be able to master this, in order to start the calculation of the geometric volume .
These figures will be taken as an example “927 out of 2.8-1.005”; now pick any cell “A3″ and write the following in this cell; = 927 / (2,8-1,005) in the bar above the worksheet that appears in rectangular.
Press the button on the keyboard ” INTRO or ENTER ” in the selected cell to do this operation and the result will be immediately displayed.
In the case that it is a cell in which you want to write the numeric commands or text, in the rectangular window at the top of the sheet, it will show as a mirror what you have written.
Also, through the careful and proper use of parentheses, you can write complex formula lines such as; = ((1726-104) / (2.3 * 0.9) -1) / (28 ^ 2-1.005 / 0.7).
In turn, if you start a formula line with the signs; =, + or – but you do not want Excel to consider it as a formula, proceed with the apostrophe “(‘)” this will remain invisible and will not be reflected in the cell.
In this way, Excel uses periods or commas for decimals depending on the setting you make in Windows when entering decimals. It is a good idea to use the point on the numeric keyboard that Excel interprets as a semicolon depending on the system setting in question.
Bearing in mind that the asterisk sign (*) is the multiplier sign in the spreadsheet and the caret is (^) is used to indicate to the spreadsheet that it is a power. Once this is explained step by step, you can perform the volume calculation, having Excel open, you will do the following 4 steps:
- In a new spreadsheet you will click on cell “A1” in the upper left hand corner of the window.
- Select the type “side” in the cell and proceed to press “Enter” to go down to cell “A2.”
- Now type “Volume Cube” in cell “A2”, then press the right arrow key to move to cell “B2” and place the following; “= B1 ^ 3” without quotes.
- Left click on cell “B1” above cell “B2” enter the length of the cube and cell “B2” will show the result.