Collegedunia Operations Analyst Interview Questions, Process, and Tips

Alt + Down Arrow

• Press Alt key and Down Arrow key simultaneously

• Shortcut key is used to open the filter drop-down menu for pivot tables

• Can be used to quickly filter data in pivot tables

Syntax for copying data from one table to another in SQL

• Use INSERT INTO statement with SELECT subquery

• Specify the source table and columns in SELECT subquery

• Specify the destination table and columns in INSERT INTO statement

Vlookup searches for a value in the first column of a table and returns a corresponding value in the same row. Index match uses the index function to find a value in a table and match function to return a corresponding value in the same row.

• Vlookup only works from left to right, while Index match can work in any direction.

• Index match is more flexible and efficient for large datasets.

• Index match can handle errors better...read more

The shortcut key for pivot table is Alt + D + P.

• Press Alt key and then press D and P keys in sequence to create a pivot table.

• This shortcut works in Microsoft Excel.

• Pivot tables are used to summarize and analyze large amounts of data.