EXCEL Introduction Blog

on

 

W W W . S S B T E C H C O M P U T E R . B L O G S P O T . C O M


MS Excel

MS Excel Window


Some Important points In excel--->
  • Excel is a software that is used for making database using functions, Formule.
  • When you are using a formula than you have to start formula with =(Equal) sign.
  • RANGE-- Range is a area that you want to include in your formula. When you select a range than Colon(:) sign print between the cell address. 
  • ARRAY-- Array is also a type of range.
  • LOOKUP_VALUE--That value which you want to use in your function.

EXCEL CELL ERROR

  1. #NAME?
  2. #VALUE!
  3. #REF!
  4. #DIV/0!
  5. ########
  6. #NULL
  7. #NUM

CELL

A cell is area in sheet where we write anything. When horizontal & vertical lines intersect each other, the made part is known as Cell.
Ex-C11,B6,BN8 etc.

ACTIVE CELL-- A cell where you are inputting the data/value. 

Cells are classified in three types-----------
  1. Relative Cells
  2. Absolute Cells
  3. Mixed Cell
RELATIVE CELL-- A relative reference in Excel is a cell address without the $ sign in the row and column coordinates, like A1. When a formula with relative cell references in copied to another cell, the reference changes based on a relative position of rows and columns. By default, all references in Excel are relative.

ABOSULTE CELL--There is a shortcut for placing absolute cell references in your formulas! When you are typing your formula, after you type a cell reference - press the F4 key. Excel automatically makes the cell reference absolute! By continuing to press F4, Excel will cycle through all of the absolute reference possibilities.

MIXED CELL--
Mixed reference in Excel means only part of the reference is fixed, either the row or the column, and the other part is relative. Unlike absolute references, only one $ (dollar sign) is applied, either in front of the column or row number.


SOME IMPORTANT & USEFULL FORMULE

SOME IMPORTANT & USEFULL SHORTCUTS


HOW TO MAKE TEXT MR. INDIA(UNVISIBLE) IN EXCEL SHEET...........

  • Select the range where you want to make text Invisible(Mr. India).
  • Go on number group.
  • Pick the CUSTOM option.
  • Write three times Semi-Colon(;)
  • Press Ok.

Now Your Text in Invisible(Mr. India).

For Making the text Visible............

  • Select the range where you want to make text Visible.
  • Go on number group.
  • Pick Any other number format(Gernal)
  • Press Ok.

Now Your Text in Visible.


HOW TO MAKE TEXT SHORTCUT IN EXCEL SHEET...........

If you are working in a Firm/Organization than this option is very useful for you. At working time there are so many word that you have to write multiple times. In this working our lot of time goes waste. We can make a autotext that will write automatic by press some key............
LOOK HOW...............

  • Click on MS Excel Office Button(In 2007)/File Option(In 2013..)
  • Go on Excel Option.
  • Pick the Proofing Option.
  • Click On AutoCorrect Option.
  • Use Replace & with Option.
  • Type any word at the place section & that you want to come automatic write that in With Option.











WhatsappTelegramFB PageTwitterInstragramOur Book

Comments

Post a Comment