answersLogoWhite

0

Do PivotTables require formulas

Updated: 11/11/2022
User Avatar

Wiki User

10y ago

Best Answer

Not necessarily. The data used to create the Pivot Table can be derived from data that has no formulas or from data with formulas. The Pivot Table itself will show data that can be calculated from formulas, but you will not see the formulas if you click on cells in the Pivot Table showing things like totals or averages etc.

User Avatar

Wiki User

10y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Do PivotTables require formulas
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Which is the new Excel feature that cuts your PivotTables into fine data segments?

This feature is called Excel Slicers. See related links.


Why do some chemical formulas require brackets?

Because they involve the application of diarreha onto glass


Does software engineering require math?

You bet it does ... and plenty of it, too. There will be massive formulas to calculate - most software engineering positions require one to know Calculus, too.


Why is it required for students to be excellent in math in order to do physics and chemistry?

Because there are a lot of formulas that require a higher level of math to do them correctly


What are the formulas for finding areas of all figures?

It will require many pages of a text-book to show the area- formulae for all figures.


What are the formulas of different spatial figures?

The answer depends on what characteristic of the spatial figures you want a formula for. Furthermore, it is very likely that you will require a different formula for different shapes.


What is the amount of space inside a three dimesional figure?

It depends. Different objects require different formulas. For a basic cube, it is width times length times height


Where in Excel 2007 is the function categories stored?

On the formulas ribbon.On the formulas ribbon.On the formulas ribbon.On the formulas ribbon.On the formulas ribbon.On the formulas ribbon.On the formulas ribbon.On the formulas ribbon.On the formulas ribbon.On the formulas ribbon.On the formulas ribbon.


What do you use to work out equations on excel?

You use the formulas and functions.You use the formulas and functions.You use the formulas and functions.You use the formulas and functions.You use the formulas and functions.You use the formulas and functions.You use the formulas and functions.You use the formulas and functions.You use the formulas and functions.You use the formulas and functions.You use the formulas and functions.


What are some examples of geometry formulas?

There are different types of geometry formulas such as polygon properties, area formulas, volume formulas, surface area formulas, circle formulas, and perimeter formulas.


Choosing a Career in Biological & Biomedical Sciences?

If you are interested in a career in biological or biomedical sciences, you should brush up on your math and computer skills. Both of these fields require heavy use of intricate computer programs. They also require that you have a highly skilled math background, with emphasis on computing mathematical formulas.


Do you have to use subscript in chemical formulas?

Not every chemical formula requires subscript. For example table salt is NaCl, sodium chloride. No subscript. But most chemical formulae do require subscript, such as water, H2O.