[FREE EBOOK]Insider's Guide to Microsoft Excel 2013 by Brian West - KING OF EXCEL

# [FREE EBOOK]Insider's Guide to Microsoft Excel 2013 by Brian West

Author:Brian West [West, Brian]
Language: eng
Format: epub
Publisher: EVBA.INFO
Published: 2019-11-05T07:00:00+00:00
In the image below, I have put red and green boxes around the two buttons that deal with decimal places. The left button (with the red box) will increase the number of decimal places by 1, each time it is pressed. So, if I were to press it now, 17.00 would become 17.000… Mathematically, it’s still the same to Excel. Pressing the right button will decrease by 1. Since I pressed the red button once, I can press the green one three times to get my numbers to have 0 decimal places.
Functions vs Formulas
Ok everybody. Until now, I have showed you how to enter your formulas manually. This was necessary so you could see how they work and so you could understand what was going on in a formula… I showed you how you could type the equal sign = and then add, subtract, multiply and divide
We have already used some very basic formulas. For example, we used the formula
= D5 + D6 + D7 + D8 + D9 +D10 + D11 + D12 + D13 + D14 + D15
This added the values in all of the cells from D5 through D15… We wrote this formula ourselves…
#evba #etipfree #eama #kingexcel