Blocks of Info

The Object of this block : After working done in any MS office file, we can save it as read only, so in future nobody can change it. In MS office , A Option Call "Mark as Final" will convert file normal file into Read-only file. How to Convert Normal MS Excel Workbook into  Read-only Workbook Using " Mark as Final". 1. On the File tab, 2. Click Prepare > Mark as Final. 3. Click Ok. Now, This Excel Workbook is Read Only and  No one can Change it. If, You Require to Convert Read-only Workbook into Normal Workbook (i.e. Editable Workbook) Follow Above Three Step Again.    Grow The info.

Object of this Block:  understanding of Vlookup and Hlookup data analysis function  of Excel . Useful term : Hear, H stands for Horizontal V stands for vertical At, What Point of Data Analysis Vlookup and Hlookup will help us? Mr. B having two table of data with one similar column. both table having following data: Table 1. Column Name Row No. A B C 1 Country Capital National Language 2 India Delhi Hindi 3 Japan Tokyo Japanese 4 UK London English 5 Italy Rome Italian 6 France Paris French Table 2. Column Name Row No. A B 1 Country National Language 2 India 3 Japan 4 UK 5 Italy 6 France Requirement of Mr.B: Now, Mr.B wants to f...