That’s why you need to know how to list and describe your skills like an MOS Master. Next, the function returns the searched value in the same row in the index position.Listing MS Office skills on a resume feels a bit like writing you can use a mobile phone:īut if you’re proficient in Microsoft Office, putting “MS Excel” at the top of your resume skills list is not enough. Can you give us the uses of the VLookUp function?Īs the name suggests, the VLookUp does a quick vertical search for a particular value in the first column of the table. The location to which a particular cell is directed is known as the cell reference.ġ0. Elementarily, cell reference is used in order to avoid writing the data again and again for the purpose of calculation. Indeed, cell reference is particularly useful in that it saves some time. Is there any particular use of cell reference in the calculation? All you need to do is type the address of the cell in the name box.ĩ. Can you give us an idea on how one can quickly return to a specified area in the worksheet?īy using a name box, one can easily return to the required area in a worksheet. It’s easier done when you take help of the highlighting.Ĩ. It is chiefly done for the purpose of row- or column-specific task. Basically, they are used to lock a particular row or column. Do you have any idea of freeze panes on MS Excel?įreeze panes are useful tools.
However, one of the chief mantras to get through the interview is to be thoroughly acquainted with your subject.īelow are some of the frequently asked Excel interview questions and answers:ġ. Unsurprisingly, given the well-rooted prejudices about the same, it is hardly a matter of awe to find candidates all huffing and puffing before an interview session. Cracking interviews remains the sore spot in the minds of prospective candidates.