What are pivot tables and also mention its use?

devquora
devquora

Posted On: Feb 22, 2018

 

It is a table or kind of tool and it allows a quick summarization of data in large quantity. It performs functions like sorting, counting, total or average of the data that are saved in the spreadsheet and it displays the result in another spreadsheet. It saves a lot of time. It is one of the most helpful too and also allows to link external data sources to Excel sheet.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Microsoft Excel Interview Questions

    What is Microsoft Excel?

    Microsoft Excel is commonly known as an electronic spreadsheet application, which facilitates the users to store, organ..

    Microsoft Excel Interview Questions

    Explain the spreadsheet.

    Spreadsheets are similar to a paper ledger sheet. It has rows and columns and has their insertion named cells...

    Microsoft Excel Interview Questions

    What do you mean by ribbon?

     The topmost area on the Microsoft Excel that contains menu and other toolbar items are known as ribbon. CTRL+ F1 key..