EXCEL Introduction Blog ~ Ssbtechcomputer

Ssbtechcomputer

Welcome to the world of technology and computers! Our blog is your one-stop destination for all things related to computers, technology, and computer courses. Whether you're a tech enthusiast, a student looking to enhance your skills, or a professional seeking the latest updates in the industry, we've got you covered.

EXCEL Introduction Blog

 

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-- 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...........
  1. Select the range where you want to make text Invisible(Mr. India).
  2. Go on number group.
  3. Pick the CUSTOM option.
  4. Write three times Semi-Colon(;)
  5. Press Ok.
  6. Now Your Text in Invisible(Mr. India).
For Making the text Visible............
  1. Select the range where you want to make text Visible.
  2. Go on number group.
  3. Pick Any other number format(General)
  4. Press Ok.
  5. 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...............
  1. Click on MS Excel Office Button(In 2007)/File Option(In 2013..)
  2. Go on Excel Option.
  3. Pick the Proofing Option.
  4. Click On AutoCorrect Option.
  5. Use Replace & with Option.
  6. Type any word at the place section & that you want to come automatic write that in With Option.

Important Point for CCC

  1. To move on previous worksheet press Ctrl+PageDown
  2. Default name of Excel file is Book1
  3. The intersction of row and column is called Cell.
  4. Ctrl+End is used to move on last cell of sheet.
  5. Shift+F11 is shortcut to insert New sheet.
  6. There are 3 default sheets in any workbook of excel.
  7. Excel is known as spreadsheet software.
  8. Visual Basic is used to create macros in excel.
  9. The combination of column letter and row number for a cell in excel is called Cell refrence
  10. A function in excel always starts with equal(=) symbole.
  11. F2 is shortcut that is used to edit the data in excel.
  12. Portrait is default page orientation in excel.
  13. Landscape and Portrait are two page orientation in excel.
  14. The output of =64/8/2 will 4.
  15. Chart Wizard (F11) is used to create charts in excel.
  16. Absolute, Relative, Mixed are cell refrenses in excel.
  17. .xls OR .xlsx is extension name of excel.
  18. In excel you can use arithmatic, logical, financial, text function.
  19. Default alignment for Text is Left for Number is Right in excel sheet.
  20. A$4$ represent that this cell is freezed. For this F4 is used and now this will known as Absolute cell refrens.
  21. Spreadsheet is known as Workbook
  22. Countif() formula is used for counts the number of cell with in range that meet a given condition.
  23. Shift+F5 is used for opening Find dialog box while F5 is used for Go to.
  24. Ctrl+F5 has the same work in word and excel.
  25. A1 is address of first cell in excel
  26. When we copy a formlula in excel, absolute cell refrences do not change
  27. Whatsapp Telegram FB Page Twitter Instragram Our Book
Previous
Next Post »