Spreadsheet software MCQ - Practice Questions with Answers

A Pivot Table is a data-analysis feature used in Microsoft Excel to summarise, group, filter and rearrange large sets of spreadsheet data. Microsoft Word is mainly a word-processing programme, so it is used for documents rather than pivot-based numerical summaries. Microsoft Access is a database management tool, where data can be stored and queried, but the standard Pivot Table feature is associated with Excel. Microsoft PowerPoint is used for presentations, slides and visual communication, not for spreadsheet data analysis. Therefore, the software connected with Pivot Tables is Microsoft Excel.