● Pivot Table is an interactive way to quickly summarize large amounts of data. It is used to summarize, sort, reorganize, and group. It allows us to extract the significance from a large, detailed data set. ● VLOOKUP: It is a function that makes Excel search for a certain value in a column, to return…...