Search This Blog

Search Engine

Custom Search

20100701

10 Types of Excel file

Types of Excel file


  1. Excel 2
  2. Excel 3
  3. Excel 4
  4. Excel 5
  5. Excel 95
  6. Excel 97
  7. Excel 2000
  8. Excel 2002
  9. Excel 2003
  10. Excel 2007


DIFFERENCE IN THE LAST ROWS

  1. Last cell in Excel 2007 workbook is XFD 1048576
  2. Last cell in Excel 2003 workbook is IV 65536


-----------------------------------------------

How to unhide Developer tab in Excel 2007?

How to unhide Developer tab in Excel 2007?



Go to File ;
Then Go to Excel Options
Then Select Personalise
Place a check mark next to Show Developer tab in the Ribbon.
Click OK.
-----------------------------------------------


ANOTHER METHOD IN ANOTHER MICROSOFT VERSION



Go to File
Go to Excel Options
Click on POPULAR
The first Header on right side of POPULRA will be
 "Top options for working with Excel"
In that,
Click on 3rd option
"Show Developor Tab in the Ribbon"

How to copy the file which is password protected in excel?

-----------------------------------
How to copy the file which is password protected in excel?


  1. The file can be opened
  2. But can not be copied
  3. Hence cannot be pasted
  4. So save this file as text thru the "Save as" button.
  5. Please note password protected files can not be saved as web page but still these files can be
  6. saved as text
  7. Then select all text - copy it & paste it in new excel file
  8. The copy function in password protected file does not work but the paste function works.
  9. Take paste function for all sheet that is password protected.
  10. Means select the sheet & press paste function button
  11. Dump this button on the new excel file where text from text file is pasted


You will get same to same excel sheet without any changes in row or column or content with full formatting ie. borders, bold text etc.

How to activate Numbers given on JKL & UIO buttons on keyboard in Lenovo?

How to activate Numbers given on JKL & UIO buttons on keyboard in Lenovo

Press Fn button then press F7 button. F7 button has NmLk switch given in blue

By pressing Fn & F7 the Fn & NmLk gets pressed & JKL & UIO are deactivated instead 123 & 456 gets

typed everytime you press these buttons.

Again to return to JKL & UIO typings means alphabets to be typed by pressing this keys again

press Fn & then F7. By this again alphabets can be typed instead of nos.

Fn is the function button on left down corner of the keyboard
----------------------------------------------------------------

How to insert a tick box in excel & place remarks column in accordance with the ticks or blanks in the check box?

How to insert a tick box in excel & place remarks column in accordance with the ticks or blanks in the check box?

Check font awesome

Photo Source - Font Awesome by Dave Gandy - http://fortawesome.github.com/Font-Awesome [CC BY-SA 3.0], via Wikimedia Commons


Go to Developer tab
Go to Control & click INSERT
In Form click Check Box
Right click on Check box
Then click on properties
Assign a cell value
If you tick the check box the linked cell value gets converted into True
If you untick the check box the linked cell value gets converted into False
This way based on True & False derivatives you can give If then functions to get desired statements in front of the check box based on whether you tick or untick those boxes

INCOME TAX PROCESS - On Net

-----------------------------------------------------------
INCOME TAX PROCESS - On Net

Go to Income Tax Dept. Site
Register yourself with help of your PAN No.
A Form - Download it - ITR File
Fill Soft form
Convert into XML
Log in password
Upload on that site
Confirmation will be recd.
A PDF Document in soft will be recd.
Print
Sign
Put it in envelope
Put address
Send to Banglore

Duly signed ITR-V should be sent to address as below : -
Income Tax Department -
CPC,
Post Bag No - 1,
Electronic City Post Office,
Bengaluru - 560 010,
Karnatatak

How to send?
By ordinary post or Speed post only

Within how many days?
Within 120 days from the date of transmitting data electronically

At no other Income tax dept. other than this, the form accepted.

The confirmation of receipt of this FORM ITR-V at ITD-CPC will be sent to email address client.cadbnehere@gmail.com
----------------------------

How to get the Top 5 & Bottom 5 values in a table?

How to get the Top 5 & Bottom 5 values in a table

To get Top 5 values from a given column
Use formula
=LARGE(C4:C81,1) to find 1st highest value which can also be obtained from Max formula
=LARGE(C4:C81,2) to find 2nd highest value
=LARGE(C4:C81,3) to find 3rd highest value
=LARGE(C4:C81,4) to find 4th highest value
=LARGE(C4:C81,5) to find 5th highest value
where C4:c8 is the range from where top 5 values are to be selected

Similarly to find bottom 5 values from a given column
Use formula
=SMALL(C4:C81,1) to find 1st lowest value which can also be obtained from Max formula
=SMALL(C4:C81,2) to find 2nd lowest value
=SMALL(C4:C81,3) to find 3rd lowest value
=SMALL(C4:C81,4) to find 4th lowest value
=SMALL(C4:C81,5) to find 5th lowest value
where C4:c8 is the range from where bottom 5 values are to be selected

---------------------------