0
What is the difference between a pivot table in Microsoft Excel and a table in Microsoft Word?
Wiki User
∙ 9y ago
They are radically different. A table in Word, just displays your data in a tabular form. A pivot table has a lot of functionality, enabling you to do things like calculations, picking different types of calculations, switching the table layout, changing what pieces of the data that it is based on that you use. Pivot tables are used to analyse data and simply manipulate the results as you do so. Tables in Word can actually do simple calculations, something many people don't even realise, but they can't do the same kinds of things a pivot table can do. Pivot tables are closer in their function to a Crosstab query in Access, than to a table in Word.
Wiki User
∙ 9y ago
Wiki User
∙ 9y agoA Word table is mainly for plain data, usually text. An Excel table usually contains numbers and calculations. While a lot of people don't realise it, numeric calculations can be done in a Word table, though to a far limited extent compared to what can be done in Excel. Rarely are calculations done, as if someone does want to do calculations they would use Excel rather than Word. So Word tables are usually just used for laying out data in a structured manner and Excel tables are used for doing calculations.
Add your answer:
Earn +20 pts
Who invented the pivot calculation formula?
Excel, which is owned by Microsoft
What is data menu in Microsoft Excel?
Data menu is that on that we can sort,filter,subtotals,validation,text to columns,pivot tables and pivot chart report
Has anyone had issues converting macros or pivot tables from Microsoft Excel 2000 to Microsoft xp?
4740830 call 4 gay sex
What are the pivot tables normally used for?
Pivot Tables help you organize and sort data. They are easier to use for summary and analysis than a plain spreadsheet. Pivot Tables are used in Microsoft Excel programs.
Where can one buy a pivot table?
A pivot table is a tool used in data analysis to look at variable data. The easiest way to create a pivot table is to use the pre-made template on Microsoft Excel.
What are the different terms used in Microsoft Excel?
Workbook, Worksheets, sheet, rows, columns, pivot, formula, filter And many more.
What can people do using Microsoft Excel?
Microsoft Excel is a spreadsheet program used to make charts containing information. You can make calculations. use graphing tools, and pivot tables. On this program you can enter, analyze, and present data in a organized way.
How to create Pivot Table in Excel?
Create a PivotTable to analyze worksheet data Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web More... You on hurry! Watch this video A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. PivotTables work a little bit differently depending on what platform you are using to run Excel.
Can you get a sprite on to pivot by Microsoft Word?
No. You Can get sprites for pivot in www.zoidz.org only.
What cannot exist in Excel without an associated Pivot Table?
A pivot chart.A pivot chart.A pivot chart.A pivot chart.A pivot chart.A pivot chart.A pivot chart.A pivot chart.A pivot chart.A pivot chart.A pivot chart.
What is a powerful tool for summarizing in a table in Excel?
A pivot table.A pivot table.A pivot table.A pivot table.A pivot table.A pivot table.A pivot table.A pivot table.A pivot table.A pivot table.A pivot table.
What is Microsoft Excel and other commonly used term in Excel?
Workbook Worksheet Vlookup Index Pivot Conditional formatting Table Sort Filter Cells Rows Columns are most common terms used in MS Excel Regards, Sarfaraz Ahmed http://findsarfaraz.blogspot.com
