Most Questions Which is asked by the interviewer in Excel Job
- Top 10 Questions Answers of Excel Interview
- What is V-lookup and H-Lookup?
- What is Pivot Table?
- What is Macro?
- What is MIS? Do you Know How to Create it?
- What is the Countif?
- What is Sumif?
- What are the Shortcuts of Frequently use functions like , Filter, Auto-fill Formula & etc.
- What is use of IF condition
- Do You know Sort and Filter?
- For Answers of all these questions Read complete Blog please Scroll Down
- What is V-lookup and H-Lookup?
- V-Lookup - Vertical Lookup - this is the function from Lookup family, Look for the values in the leftmost column of the table and return the same row value the column number you specify, by default table must be sorted in ascending order -
V-Lookup (short for 'vertical' lookup) is a built-in Excel function that is designed to work with data that is organised into columns. For a specified value, the function finds (or 'looks up') the value in one column of data, and returns the corresponding value from another column.
Suppose in Above you want to check Result according seat no so Seat No column must be @ left Side and it is there, Now the
Obtain answer in following manner. you should type
|Enter Seat no||1001|
|Name||=VLOOKUP(1001,SELECT ABOVE TABLE,2,0) ANSWER =Rajesh|
|Result||=VLOOKUP(1001,SELECT ABOVE TABLE,3,0) ANSWER =Pass|
H-Lookup (short for 'Horizontal' lookup) is a built-in Excel function that is designed to work with data that is organised into rows. For a specified value, the function finds (or 'looks up') the value in one row of data, and returns the corresponding value from another row.
What is Pivot Table?
A pivot table is a table that is use to get the summarize record of selected table, It is Developed in EXCEL 5.0 in 1993 the idea of pivot table comes from lotus developer Pito Salas and then Microsoft invent this same into excel in 1993 is made by applying an operation such as sorting, averaging, or summing to data in the first table, typically including grouping of the data.
A trivial example is a column of numbers as the first table, and the column average as a pivot table with only one row and column. A slightly less trivial example is a table with columns sex and height, each row giving the sex and height of a person, and a pivot table made from it with the same two columns but only two rows, with "male" and "female" in the sex column and the average height of each sex in the height column.
A third more complex and more typical example adds another dimension to the pivot table: a data table has columns month, salesman, product, and sales, each row giving the total sales of some product by some salesman in a certain month, and a pivot table made from it has a first column salesman of salesmen names and the remaining column names are product names and contain the total sales by that salesman of that product over all months.
New Things Upgrading After every Version of Excel
Now a Days pivot table has slicer and time line link available in it. with the help of this we can easily filters and show reports of MIS .Pivot tables are not created automatically. For example, in Microsoft Excel one must first select the entire data in the original table and then go to the Insert tab and select "Pivot Table" (or "Pivot Chart"). The user then has the option of either inserting the pivot table into an existing sheet or creating a new sheet to house the pivot table. A pivot table field list is provided to the user which lists all the column headers present in the data. For instance, if a table represents sales data of a company, it might include Date of sale, Sales person, Item sold, Color of item, Units sold, Per unit price, and Total price. This makes the data more readily accessible.
Click on Insert - Left Most Corner of Ribbon - Find Pivot Table Option - click then Dialog box will appear which shows you - Data to be select then, Where you want to place your report.
What is Macro?
Macro it is automation task in excel Developed in Excel 1993 - Excel 5.0 Version
In Microsoft Word and other programs, a macro is a saved sequence of command s or keyboard strokes that can be stored and then recalled with a single command or keyboard stroke.
Let’s not get too much in detail at this point. For now, in simple language, Macro is very popular software available with the most of the windows applications. Many of the windows applications provide inbuilt Macro programming. For example: Excel, Word etc. Here in this blog you will be learning this how to use it in Microsoft Excel.
It allows you to perform multiple operations just by clicking a simple button or changing a cell value or opening a workbook etc. It enables you to work in a smart and efficient way. In terms of productivity, it is very productive as it reduces lots of manual work and gets the things done very fast especially things which you are doing it repeatedly.
View - Macro - Macro Recording
So, is it a programming language?
Yes it is
For now, Yes, it is very similar to Visual Basic. You don’t need to know much about the history of this language at this point of time. If you are interested and want to know history of this Language you can read this article. It is a video, where I have discussed about the history of this Language.
So now, I will directly jump to my original topic, where, I am going to teach you two Important features of this Tool, which, you as a beginner, will like it the most
Wait for next update of this post...