In Excel 2013, I teach the format of the fourth formal calculation that I want to master in Excel!
I want to master it for using Excel.In particular, the fourth computing is highly versatile, and the usage scene is wide.First, let's learn the format of the four areas.
■ Automated calculations and create materials quickly
Excel is a "spreadsheet software" and has a substantial calculation function.Utilizing the calculation function provided by Excel, you can create materials quickly and accurately.However, it is necessary to learn "formula" to use the calculation function.This time, we introduce the most basic format format and enter symbols among the formulas.At the same time, check "Auto SUM" that allows you to add multiple items with one touch.Use two functions to automate simple calculations like the four areas.
■ Calculate by entering mathematical formulas instead of numerical values
↑ Enter the numerical value in “quantity” and “unit price” and enter the formula in the “amount”.
↑ When the input of the formula is confirmed, the number “2000” of the calculation result is displayed.
■ One -shot calculation using auto SUM
↑ Select the “Home” tab and click the “σ” icon in the “edit” item to use the auto SUM.
↑ Select the cell in the small column and select an icon to display the calculation range of the formula.
↑ When confirmed, a numerical value in which the specified range is added is displayed.
■ Connect cells and cells by symbol to build mathematical formulas ・ Mestige four arithmetic operations
When using a formula in Excel, it is described according to the prescribed format.The basics are "equal".All formulas always start with equal.In the case of four arithmetic calculations, the desired cell should be connected with a plus or negative symbol.The characters to be entered are not a problem in full -width or half -width.
↑ A table used for this fourth formal calculation.By entering the formula in the cell of column E, the answer to the calculation is displayed.Learn the rules of input.
STEP1 Master the formula of the formula with the addition formula
↑ First, enter “=＂ (equal)).If the display type of the cell is "standard", it is treated as a formula by entering "=".
↑ Continue to “=”, specify the cell you want to use in the calculation.Select the desired cell for the cursor key or click with the mouse.
↑ After selecting the cell, enter “ +＂ (plus)).In Excel, the symbols such as " +＂ are collectively called the operator.
↑ Specify the cell to be used for the calculation again.The formula is now complete.
↑。 The “2500”, which is the answer to the mathematical formula entered on the cell, is displayed.
Step2 Learn the operators corresponding to the fourth form of calculation
If you want to subtract, enter “＂ (minus) in the operator.
↑ The number “1500” after calculation is displayed.The formula formula is completed.
↑ In the case of multiplication, enter “ *＂ (asterisk) as an operator).
↑ In the case of one division, calculate using “/＂ (slash)).
STEP03 Repeated and combined calculations are OK
↑ The mathematical formula can be repeated multiple times or combined with four areas.The photo is a formula that combines multiplication and addition.
↑ The calculation result of “2000 + 500 × 2” is displayed.The calculation order is the same order as the normal four, and the formula is the same.
■ Quickly check the average value and maximum value
Auto SUM has a menu in addition to the "total" that adds numbers.The average value of the entered number is determined, the "maximum value" that displays the highest or low value in the input numerical value within the specified range, the number of cells entering data is aggregated.The number of numbers is available.
↑ ↑ ↑ ある ある ある ある ある ある ある ある ある ある ある ある ある ある ある ある ある あるIn addition to "total", "average value" and "number of numbers" can be selected.“Average” is a menu that displays the average value of the specified range.The number of cells entered within the specified range is calculated in the number of numbers.
As mentioned above, we have delivered the four formal calculations of the formula in Excel.Please use it for practice."Excel Dojo -Secret Society Extension" is being popularly serialized in the Weekly ASCII magazine.Please check it out and enjoy Midori's great struggle!
