after watch video 04 we will understand a lot about tab Formula on ms-excel 2016. this video show detail of using on tab formula so page setup...
In Tab Formula is also i explain by detail in each content so
- Function Library is show all function in excel by group so
- Insert Function for insert another formula to calculate value
- Auto Sum for calculate value by automatic
- Recent Use for present function that we had use on last time
- Financial Use for calculate or format value that relate to financial.
- Date Time function is a blog function for calculate or format value that relate to date time and ect.
- Define Name is a group to late we manage on work sheet so column, row or cell and let we control on value and formula that we had use it so:
- Manage Name for manage name of cell that put to cell.
- Define Name for define a name to anyone of column that we want to define,
- User Formula late we call formula on excel to calculate value.
- Formula Audition is a group for present or check formula that use on work sheet.
- Trace Precedents is show arrow that indicate with cells effect the value of the currently select cells.
- Trace Dependents is show arrow that indicate with cells are affected by value of the currently select cells.
- Remove Arrow for remove arrow that created on Trace Precedents and Trace Dependents.
- Show Formula we use this tool to show all formula in work sheet
- Calculation is a group that collect tools that relate to calculate value.
- Calculate Option for Allow we choose on choice in all of option is also has
- Automatic
- Automatic except for data table
- Manual
- Calculate Now for Calculate formula when we choose Manual option
- Calculate Sheet for Calculate value on sheet