VLOOKUP stands for Vertical Lookup. It is a function that makes Excel search for a certain value in a column (the so called table array), in order to return a value from a different column in the same row.

How do you explain VLOOKUP in interview?

7:2812:16How to Pass Excel Test for Job Interview: VLOOKUP - YouTubeYouTube

How do you explain pivot table in interview?

A pivot table is a program tool that allows you to reorganize and summarize selected columns and rows of data in a spreadsheet or database table to obtain a desired report. A pivot table doesnt actually change the spreadsheet or database itself.

What are the 3 types of data in Excel?

You enter three types of data in cells: labels, values, and formulas. Labels (text) are descriptive pieces of information, such as names, months, or other identifying statistics, and they usually include alphabetic characters. Values (numbers) are generally raw numbers or dates.

What are the features of pivot table?

The seven unique featuresTotaling values.Hierarchical grouping by rows and columns.Persisting node states on dynamic updates.Displaying no data items.Conditionally formatting values with color and text styles.Linking with relevant page URLs.Interactive sorting by value columns.Jul 2, 2019

How do I do a pivot table?

Manually create a PivotTableClick a cell in the source data or table range.Go to Insert > PivotTable. Excel will display the Create PivotTable dialog with your range or table name selected. In the Choose where you want the PivotTable report to be placed section, select New Worksheet, or Existing Worksheet.More items