Vlookup In Excel (How to use with example)

What is Vlookup command explain 

Vlookup is very strong command in Excel ,User can use this command in same excel sheet or can link with other 
Here  is an example of a list.  In this case it’s a list of students with student id ,name,telephone number  
Table 1

Usually lists like this have some sort of unique identifier for each item in the sheet.  In this example, the unique identifier is in the “Student_id” column.  Note:  For the VLOOKUP function to work with a list, that list must have a column containing the unique identifier , and that column must be the first column in the table.  Our sample database above satisfies this criterion.

The difficult part of using VLOOKUP is understanding exactly what it’s for.  So let’s see if you can get that clear 

VLOOKUP extract data/information from a database based on a supplied instance of the unique identifier.

Now we need to retrieve name from table A 

open function menu

above box will appears that allows us to find and select any of the functions/command  available in Ms Excel.  To find the one we arelooking for, we could type a search term like “lookup”   The Excel would return us a list of all lookup-related functions in MS Excel.  VLOOKUP is the second one in the list.  Select it an click OK…

 

The Function option will box appears, prompting us for all the options needed in order to complete the VLOOKUP function.  

1. What unique column are you looking up in the database?
2. Where is the excel database.
3. Which piece of information from the table1, link and associated  with the unique identifier, do you wish to have retrieved for you?

The first three arguments are shown in bold, indicating that they are mandatory arguments (the VLOOKUP function is incomplete without them and will not return a valid value).  The fourth option is not bold, meaning that it’s optional:

The first option we need to complete is the Lookup_value argument.  The function needs us to tell it where to find the unique identifier (the item code in this case) that it should be returning the description of.  We must select the item code we entered earlier (in A2).

Click on the selector icon to the right of the first argument:

Vlookup(

Select column that is associated      A2

Now Select Array column from table 2

For further please visit http://www.howtogeek.com/howto/13780/using-vlookup-in-excel/

 

Who is Khalil Shreateh :Facebook hacked with in 15 Second

Khalil is Palestinian Hacker who discovered 

who hacked Facebook CEO Mark Zuckerberg's profile and discovered Major Security Flaw in Facebook

A Palestinian hacker discovered a Major security flaw with Facebook that allows hackers to post to anyone’s Facebook Timeline , to read private messages regardless of whether or not they're friends. The hacker, Khalil Shreateh, proved his point by posting directly to the private Facebook wall of Mark Zuckerberg and also published his private message on pastebin.com . Unfortunately, Shreateh's method may have cost him at least a $1500 reward. 

for method please visit again 

Exam copied from microsoft

Thanks :copied from microsoft.com 

1.	You place the insertion point in the middle of a paragraph and start typing. But the new text deletes existing text. What's the problem and how do you fix it?

A.	Word is in Overtype mode. Press BACKSPACE and retype.

B.	The DELETE key is pressed in. Press DELETE again.

C.	Word is in Overtype mode. Press INSERT to turn it off.

2.	Once you've deleted text, you can't get it back.

A.

True.

B.

False

3.	As you type a paragraph, press ENTER to move from one line to the next.

A.

True

B.

False

4.	The best way to create a heading in a document is to:

A.	Apply a larger font size to it than the body text.

B.	Add bold formatting by clicking the Bold button on the Formatting toolbar.

C.	Apply a heading style.

5.	You create a numbered list as you type by typing 1, adding your text, and pressing ENTER.

A.

True

B.

False

6.	What's a good reason to use a header or footer in your document?

A.	To include the document title and page numbers.

B.	To look impressive.

C.	To add a title to the start of the document

7.	How do you open the Header and Footer toolbar?

A.	On the View menu, click Toolbars, and select Header and Footer from the list of toolbars.

B.	On the View menu, click Header and Footer.

C.	Right–click any toolbar and click Header and Footer.

8.	In order to save an existing document with a different name you need to:

A.	Retype the document and give it a different name

B.	Use the Save as.. command

C.	Copy and paste the original document to a new document and then save

D.	Use Windows Explorer to copy the document to a different location and then rename it

9.	Which keyboard shortcut bolds selected text?

A.

Ctrl+B

B.

Alt+B

C.	File/Format/Bold

D.	None of the above

10.	What would you see while spell checking the phrase "My father was write"?

A.	The word "write" is mispelled

B.

No errors

C.	The verb of the phrase will be highlighted

D.	A blue squiggly underline under the word "write"

11.	Suddenly Word does not display your favorite toolbar. What has happened?

A.	Your program has been infected by a macro virus

B.	This version of Word does not support toolbars

C.	Your toolbar option has been deleted from the menus

D.	Your toolbar has been unchecked under the View/Toolbars menu

12.	Which elements of a Word document can be displayed in color?

A.	Only graphics

B.

Only text

C.	All elements

D.	All elements, but only if you have a color printer

13.	Why the document you created at home displays with a different font at school?

A.	Because you have a different printer at school than at home

B.	Because you have a different monitor at school than at home

C.	Because the font you used at home is not installed on your school computer

D.	Because the version of Windows is different

14.	Which keyboard shortcut centers selected text?

A.

Ctrl+C

B.

Alt+C

C.	There is no keyboard shortcut for this operation

D.

Ctrl+E

15.	How many different documents can you have open at one time?

A.	No more that three

B.

Only one

C.	As many as your computer memory will hold

D.	No more than your Taskbar can display

16.	How many margins are on a page?

A.	Two (header and footer)

B.	Four (top, bottom, right, left)

C.	Two (landscape and Portrait)

D.	Two (top and bottom)

17.	A document in portrait prints:

A.	The same characters per line with the same document in landscape

B.	More characters per line than the same document in landscape

C.	Less characters per line than the same document in landscape

D.	Smaller fonts in order to fit the same amount of characters per line with landscape

18.	In page preview mode:

A.	You can see all pages of your document

B.	You can only see the page you are currently working

C.	You can only see pages that do not contain graphics

D.	You can only see the title page of your document

19.	How can you highlight text without using the mouse?

A.	It is impossible

B.	Use the F5 key

C.	Use the arrow keys while holding down a Ctrl key

D.	Use the arrow keys while holding down a Shift key

Sample and Simple Excel Exam Paper

Question 1 of 33   Go to  1  - Not answered 2  - Not answered 3  - Not answered 4  - Not answered 5  - Not answered 6  - Not answered 7  - Not answered 8  - Not answered 9  - Not answered 10  - Not answered 11  - Not answered 12  - Not answered 13  - Not answered 14  - Not answered 15  - Not answered 16  - Not answered 17  - Not answered 18  - Not answered 19  - Not answered 20  - Not answered 21  - Not answered 22  - Not answered 23  - Not answered 24  - Not answered 25  - Not answered 26  - Not answered 27  - Not answered 28  - Not answered 29  - Not answered 30  - Not answered 31  - Not answered 32  - Not answered 33  - Not answered   What is the name given to the intersection of a row and a column in a spreadsheet?(1 point) Square Cell Cube Block

Use the chart below to answer the following equation: C1+B3=  (1 point) The highlighted region of the picture below is a: (1 point) row label column cell The highlighted region of the picture below is a: (1 point) column cell label row A list of pull-down menus for doing most functions in an application.   Title Bar Menu Bar Toolbar Name Box Formula Bar Column Headings Row Headings Active Cell  (1 point) The cell where data will be entered.   Title Bar Menu Bar Toolbar Name Box Formula Bar Column Headings Row Headings Active Cell  (1 point) A formula in the spreadsheet should always start with (1 point) An equals sign A plus sign A bracket A capital letter An asterisk Use the chart below to answer the following equation: C4/E1=  (1 point)