Using Tab Formula

0

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
  1. Insert Function for insert another formula to calculate value
  2. Auto Sum for calculate value by automatic
  3. Recent Use for present function that we had use on last time
  4. Financial Use for calculate or format value that relate to financial.
  5. 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:
  1. Manage Name for manage name of cell that put to cell.
  2. Define Name for define a name to anyone of column that we want to define,
  3. 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.
    1. Trace Precedents is show arrow that indicate with cells effect the value of the currently select cells.
    2. Trace Dependents is show arrow that indicate with cells are affected by value of the currently select cells.
    3. Remove Arrow for remove arrow that created on Trace Precedents and Trace Dependents.
    4. 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.
  1. Calculate Option for Allow we choose on choice in all of option is also has
    1. Automatic
    2. Automatic except for data table
    3. Manual
  2. Calculate Now for Calculate formula when we choose Manual option
  3. Calculate Sheet for Calculate value on sheet
Author Image

About myshare
Soratemplates is a blogger resources site is a provider of high quality blogger template with premium looking layout and robust design