when creating a calculated column in a pivottable, where does the calculated field appear?

Answers

Answer 1

Answer:

A calculated field will appear in the field list window, but will not take up space in the source data. In the example shown, a calculated field called "Unit Price" has been created with a formula that divides Sales by Quantity. The pivot table displays the calculated unit price for each product in the source data.

Explanation:

Answer 2

The PivotTable Field List contains calculated fields. Items from other fields that have been calculated display as items.

What are calculated fields?

Calculated fields are defined as the fields whose values are determined by other fields' values and perhaps external sources. Data from other fields can be calculated using calculated fields. Calculating the sum of two fields is a simple example, but more complicated calculations, such averaging values from multiple tables or even gaining access to external data, are theoretically feasible.

PivotTable Field List is defined as the Areas part of the Field List allows you to organize the fields wherever you like. It features a field section where you select the fields you wish to display in your PivotTable. Using a pivot table is an interactive method for quickly summarizing enormous amounts of data.

Thus, the PivotTable Field List contains calculated fields. Items from other fields that have been calculated display as items.

To learn more about calculated fields, refer to the link below:

https://brainly.com/question/13668122

#SPJ2


Related Questions

Where do you think the atoms for plant growth come from?

Answers

Answer:

the mass of a tree is primary carbon

Explanation:

the the carbon comes from carbon dioxide during photosynthesis

Answer:

Plants get all the carbon, hydrogen, and oxygen they need from carbon dioxide and water, which they use to build carbohydrates during photosynthesis. To build other kinds of molecules they also need elements like nitrogen, phosphorous, and sulfur. Plants get these as well as other elements from the soil.

Explanation:

A 2.37 g sample of a substance suspected of being pure gold is warmed to 71.8 ∘C and submerged into 15.9 g of water initially at 24.3 ∘C. The final temperature of the mixture is 27.0 ∘C.

Answers

Answer:

specific heat capacity of the unknown is 629.66 J/kg C

Explanation:

As we know that gold is heated to 72.3 degree C and mixed with water at 24.8 degree C

Now the final temperature of the mixture is 26 degree C

here we can say that heat given by the gold = heat absorbed by the water

So we will have

Q_{in} = Q_{out}Q

in

=Q

out

2.62 s (72.3 - 24.8) = 15.6 (4186) (26 - 24.8)2.62s(72.3−24.8)=15.6(4186)(26−24.8)

so we will have

s = 629.66 J/kg Cs=629.66J/kgC

so specific heat capacity of the unknown is 629.66 J/kg C

A sample of gaseous arsine (AsH3) in a 460 mL flask at 332 Torr and 223 K, is heated to 437 K, at which temperature arsine decom- poses to solid arsenic and hydrogen gas. The flask is then cooled to 273 K, at which tem- perature the pressure in the flask is 488 Torr. What percentage of arsine molecules have de- composed?
Answer in units of %.

Answers

Answer:

28/95 = 29.,5 % of Arsine decomposed

Explanation:A sample of gaseous arsine (AsH3) in a 460 mL flask at 332 Torr and 223 K, is heated to 437 K, at which temperature arsine decom- poses to solid arsenic and hydrogen gas. The flask is then cooled to 273 K, at which tem- perature the pressure in the flask is 488 Torr. What percentage of arsine molecules have de- composed?

Answer in units of %.

initial pressure 332 Torr initial volume 0.46 L initial temperature 223K

final pressure 488 Torr final volume 0.46 L final 273 K

Torr is 1/760 atm 332 torr = 0.437 atm 488 Torr =0.642 atm

PV = nRT so n=RT/PV

INITIAL n= 0.082 X 223/(0.437)(0.46) = 91 moles

final n= 0.082 X 273 / (.437)(488) = 105 moles

2AsH3----------> 2As + 3H2

x moles of Arsine decomposed to make 1.5 moles of H2

the final number of moles was

(91 -X)+ 1.5 X = 105 moles

91 + 0.5 X = 105

0.5 X = 14

X =28

CHECK

if 28 moles of Arsine , then the container would have

91 --28 + 1.5(28) = 91 +14 =105 check

so 28/95 = 29.,5 % of Arsine decomposed

Your answer

(quit)

polyalchemVirtuoso

Answer:

Explanation:

ADD YOUR ANSWER

Ask maryhobbs about this question...

New questions in Chemistry

in what area of the united states do the fewest people live​

Read each step. Then put the steps in order from first to last. Write 1 for the first step, 2 for the second step and so on. 1. Fossils fuels are burn…

When unbalanced forces act on an object that is in motion, the object can: A. change speed, direction, or both. B. only change direction. C. only s…

What is the missing letter in H,J,K,L,M,N,O,P.? And what is the opposite of HATE.? And what is the opposite of ME.? Think about it -,-​

what type of reaction is Fe(NO3)3 + 3LiOH = Fe(OH)3 + 3LiNO3

Please answer this quickly. the answers that you find online are not correct. I will mark brainliest if you get it right. NO SPAM!!!!For the reaction …

cuantos gramos de soluto son necesario para preparar 50 ml de Ca(NO3)2 al 4% (w/v)

Calculate the moles of O in 0.182 mole C6H14O. Calculate the number of H atoms in 0.182 mole C6H14O. Calculate the number of C atoms in 0.182 mole C…

When a sulfur atom and an oxygen atom bond to produce substance C, electrons are? a. delocalised b. shared c. transferred​

What is oxidation state?​

LOAD MORE

Previous

Next

Ask

Complete combustion of 6.4g of compound K produced 8.8 g of carbon dioxide and 7.2 g of water. Calculate the empirical formula of K. ​

Answers

Lh (x1)78.009+1= 0.0000567

Why can’t you split an element in half?

Answers

Answer:

It depends on the atom, or more specifically, on the size of its nucleus. There is a competition between the electrical repulsion of the protons (that drives the nucleus apart) and the attraction of the protons and neutrons (due to chromodynamics). For nuclei above a certain size, the repulsion tends to win

Explanation:

hope this helps

Define valence electrons.

Answers

Answer:

Electrons on the outermost shell of an atom. They are responsible for the chemical properties of an atom.

What is the missing letter in H,J,K,L,M,N,O,P.? And what is the opposite of HATE.? And what is the opposite of ME.?

Think about it -,-​

Answers

Answer:

The letter I

Explanation:

H, I, J, K, L, M, N, O, P

Answer:

Ahhhhhhhhhhhhhhh. Me too. I really needed to hear that today.

Explanation:

thanks for that.

in hydrogen iodide __________________ are the most important intermolecular forces.

Answers

Answer:

dipole-dipole forces

Explanation:

The important intermolecular force in hydrogen iodide HI is dipole- dipole forces. This force is arising due to the partial charge separation and permanent dipole moment.

What is dipole-dipole force?

There are various intermolecular forces which binds two atoms chemically to form a compound. Ionic bonding, covalent bonding, dipole -dipole force, hydrogen bonding, Van der Waals force etc are some of them.

Dipoles are opposite charges separated by a small distance. Dipole -dipole force is generated between the atoms when they have partial charge separation and this creates a permanent dipole moment.

Hydrogen is an electropositive atom and iodine is slightly electronegative. This difference in electronegativities leads to the bonded electrons more attracted towards iodine result in partial charge separation and dipole-dipole force.

To find more on dipole-dipole forces, refer here:

https://brainly.com/question/14195217

#SPJ2

A container holds 2.0 liters of a gas at 5.0 atmospheres of pressure. If both the temperature and the amount of gas are kept constant while the volume is doubled, what is the new pressure of the gas A 0.5 L B 1.0L C 4.0 L D 8.OL​

Answers

The new (final) pressure of the sample of gas is equal to 2.5 Liters.

Given the following data:

Initial volume = 2.0 LitersFinal volume = 4.0 LitersInitial pressure = 5.0 atm.

Note: The initial volume was doubled.

To determine the new (final) pressure of the sample of gas, we would apply Boyle's law:

Mathematically, Boyle's law is given by the formula;

[tex]PV = k\\\\P_1V_1 = P_2V_2[/tex]

Where;

[tex]P_1[/tex] is the initial pressure.[tex]P_2[/tex] is the new (final) pressure.[tex]V_1[/tex] is the initial volume.[tex]V_2[/tex] is the final volume.

Making [tex]P_2[/tex] the subject of formula, we have:

[tex]P_2 =\frac{P_1V_1}{V_2}[/tex]

Substituting the given parameters into the formula, we have;

[tex]P_2 = \frac{5.0 \times 2.0}{4.0} \\\\P_2 = \frac{10}{4.0}[/tex]

New volume = 2.5 Liters

Find more information: https://brainly.com/question/1437490

Calculate the simplest formula of the compounds formed in the

following reactions:
Please just check if I’m correct or wrong

a) 2.3 g of sodium reacting with 8.0 g of bromine

Na=23
Br=80

My answer:
NaBr

Answers

I'm sorry I'm not sure of my answer so I am not gonna give you the answe

Which statements are true about light waves? (Select all that apply.)

Light waves are sun waves.

Light waves are frequency waves.

Light waves are electromagnetic waves.

Light waves are transverse waves.

PLEASE SELECT MORE THAN ONE

WILL MARK BRAINLY :D✌️

Answers

Answer:

only transverse and electromagnetic waves

Explanation:

Light waves are electromagnetic waves.Electromagnetic waves or EM waves exist waves that are created as a consequence of vibrations between an electric field and a magnetic field.

What are electromagnetic waves?

In physics, electromagnetic radiation (EMR) consists of waves of the electromagnetic (EM) field, propagating via space, and having electromagnetic radiant energy. It contains radio waves, microwaves, infrared, (visible) light, ultraviolet, X-rays, and gamma rays. All of these waves form parts of the electromagnetic spectrum.

Light waves are electromagnetic waves.Electromagnetic waves or EM waves exist waves that are created as a consequence of vibrations between an electric field and a magnetic field.

Learn more about electromagnetic waves refer to:

https://brainly.com/question/26960785

#SPJ2

Hg2(NO3)2 + Na2CO3 = NaNO3 + HgCO3 balance this

Answers

Answer:

Hg(NO3)2 + Na2CO3 --> 2NaNO3 + HgCO3

How many moles are present in 1.39 grams of carbon?

Answers

Answer:

0.116 moles

Explanation:

To go from grams to moles, you take the given mass (1.39g) and divide it by the molar mass (which is about 12 grams for Carbon). This gives you the moles. I have attached my work below.

Hope this helps! :^)

how many outer boundaries does a animal cell have

Answers

Answer:

The plasma membrane.

Explanation:

membrane, in biology, the thin layer that forms the outer boundary of a living cell or of an internal cell compartment. The outer boundary is the plasma membrane, and the compartments enclosed by internal membranes are called organelles.

Of the four gases co2, h2o, n2, and o2, which are greenhouse gases?.

Answers

Answer:

h20, 02, and c02

Explanation:

Cr(NO3)3(aq) +CuCl2(aq)

Answers

[tex]2\text{Cr(NO}_3\text{)}_3} + 3\text{CuCl}_2 \longrightarrow 2\text{CrCl}_3 + 3\text{Cu(NO}_3\text{)}_2[/tex]

What was the main reason why Alfred Wegener's theory about the movement of the continents was dismissed in 1912?

His theory explained the Earth was expanding as the plates moved

He didn't know about plate tectonics to explain how the plates moved

His map of the ocean floor did not support his theory

His theory was the first to observe the continents fit together

Answers

Answer:

His map of the ocean floor did not support his theory

Explanation:

Alfred Wegner was a great scientistHe observed the plate tectonics of earth and described it in a theory.It was dismissed after viewing his ocean floor

Answer:

He didn't know about plate tectonics to explain how the plates moved

Explanation:

Wegener believed the continents had pushed through the ocean floor. However, he did not have a satisfactory explanation for how this happened. There was no known source of energy large enough to move continents through the sea floor. Also, although scientists had data about the interior of Earth from earthquakes, there were no clues in Earth's crust to show that the continents had broken through the sea floor. Given this lack of evidence to explain the mechanism of continental drift, scientists did not accept this idea.

Which describes an element?

A.They cannot be broken down any further.
B.They can combine with other elements to form atoms.
C.They were all discovered at the same time.
D.They were created in the Earth’s core.

Answers

Answer:

I think it's D one. Because all others are wrong

Answer: They can combine with other elements to form atoms.

Explanation:

What will be the product or products if zinc (Zn) reacts with hydrochloric acid (HCl)?.

Answers

The products of the reaction are Zinc chloride (ZnCl₂) and Hydrogen gas (H₂)

From the question,

We are to determine the product or products when zinc (Zn) reacts with hydrochloric acid (HCl)

To determine the product or products, we will write the chemical equation for the reaction.

The balanced chemical equation for the reaction is

Zn + 2HCl → ZnCl₂ + H₂

Hence, the products of the reaction are Zinc chloride (ZnCl₂) and Hydrogen gas (H₂)

Learn more here: https://brainly.com/question/17716543

which pair of elements would most likely form a covalent bond

Answers

Answer:

Nonmetals and nonmetals tend to form covalent bonds.

or

P and S

Explanation:

What is the amount, in mol, of 15g of carbonate ions, C03^2-​

Answers

24 electrons.............

What is the IUPAC name for NH3? ammonia mononitrogen hydride mononitrogen trihydride nitrogen trihydride.

Answers

The IUPAC name for NH3 is Ammonia  

 

The IUPAC name is also known as (International Union of Pure and Applied Chemistry) and it is a standardized system by chemical scientists for naming chemical compounds.

The IUPAC name for NH3 is Ammonia. Ammonia is a colorless gas with a stifling odor that is an exceedingly unpleasant pungent smell. It dissociates quickly in water to generate ammonium hydroxide, which can irritate and burn the skin.

It serves an agricultural purpose such as fertilizer.It is also used for the production of plastics, textiles, insecticides, etc.

Learn more about the IUPAC naming system here:

https://brainly.com/question/23036094?referrer=searchResults

If each mole contains 6.023 x 10^23 atoms of magnesium. How many magnesium atoms reacted in your reaction? 400 mg of Magnesium were used.

Answers

Answer:

0.1× Avogadro's numbers

10×10^22

Explanation:

convert given mass to moles

then multiply by Avogadro's number

what is the function of the digestive system? why is it important to the body?

Answers

The digestive system is made up of the gastrointestinal tract—also called the GI tract or digestive tract—and the liver, pancreas, and gallbladder. The GI tract is a series of hollow organs joined in a long, twisting tube from the mouth to the anus. The hollow organs that make up the GI tract are the mouth, esophagus, stomach, small intestine, large intestine, and anus. The liver, pancreas, and gallbladder are the solid organs of the digestive system.

The small intestine has three parts. The first part is called the duodenum. The jejunum is in the middle and the ileum is at the end. The large intestine includes the appendix, cecum, colon, and rectum. The appendix is a finger-shaped pouch attached to the cecum. The cecum is the first part of the large intestine. The colon is next. The rectum is the end of the large intestine.

Digestion is important because your body needs nutrients from food and drink to work properly and stay healthy. Proteins, fats, carbohydrates, vitamins NIH external link, minerals NIH external link, and water are nutrients. Your digestive system breaks nutrients into parts small enough for your body to absorb and use for energy, growth, and cell repair.

Proteins break into amino acidsFats break into fatty acids and glycerolCarbohydrates break into simple sugars

Each part of your digestive system helps to move food and liquid through your GI tract, break food and liquid into smaller parts, or both. Once foods are broken into small enough parts, your body can absorb and move the nutrients to where they are needed. Your large intestine absorbs water, and the waste products of digestion become stool. Nerves and hormones help control the digestive process.

asap help for brainlst
List the 7 diatomic elements in the periodic table.

Question 5 options:

All alkaline earth metals- Be, Mg, Ca, Sr, Ba,Ra.


All elements in the periodic table are diatoms.


H2, N2, O2,F2, Cl2, Br2, I2


All group 16 elements-O, S, Se, Te, Po.

Answers

Answer:

Group 2A (or IIA) of the periodic table are the alkaline earth metals:  beryllium (Be), magnesium (Mg), calcium (Ca), strontium (Sr), barium (Ba), and radium (Ra).  They are harder and less reactive than the alkali metals of Group 1A.  The name comes from the fact that the oxides of these metals produced basic solutions when dissolved in water, and they remained solids at the temperatures available to the ancient alchemists.  Like the Group 1A elements, the alkaline earth metals are too reactive to be found in nature in their elemental form.

The alkaline earth metals have two valence electrons in their highest-energy orbitals (ns2). They are smaller than the alkali metals of the same period, and therefore have higher ionization energies.  In most cases, the alkaline earth metals are ionized to form a 2+ charge.

The alkaline earth metals have much higher melting points than the alkali metals: beryllium melts at 1287ºC, magnesium at 649ºC, calcium at 839ºC, strontium at 768ºC, barium at 727ºC, and radium at 700ºC.  They are harder metals than the Group 1A elements, but are soft and lightweight compared to many of the transition metals.

Salts of the Group 2A metals are less soluble in water than those of Group 1A because of the higher charge densities on the 2+ cations; nevertheless, many Group 2A salts are at least moderately soluble.   Some Group 2A salts bond strongly to water molecules, and crystallize as hydrates; among these are Epsom salt, MgSO4·7H2O, and gypsum, CaSO4·2H2O.

Explanation:

Answer:

H2, N2, O2, F2, Cl2, Br2, I2

Explanation:

The 7 diatomic elements in the periodic table are Hydrogen, Nitrogen, Oxygen, Fluorine, Chlorine, Bromine and Iodine.

The diagram shows fertilization, the union of sperm cell and egg cell.



The traits of the offspring of the fertilized egg are coded onto
A
lipids in the offspring's cell membranes.

B
enzymes in the offspring's ribosomes.

C
genes in the offspring's chromosomes.

D
water in the offspring's mitochondrion.

Answers

The answer is C
You can start off by using process of elimination, we know that it is not D, and it is not A. This narrows it down to B and C, where we can see that C is the obvious answer, the genes in the chromosomes!

Why are reforestation and reclamation important to environmental health?


Answers

Answer:

Reforestation can be used to undo and rectify the effects of deforestation and improve the quality of human life by absorbing pollution and dust from the air, rebuilding natural habitats and ecosystems,reducing global warming via biosequestration of atmospheric carbon dioxide, and harvesting for resources, particularly.

Explanation:

What does it mean when an element turns into an ion?.

Answers

Answer:

When a neutral atom gains one or more electrons, the number of electrons increases while the number of protons in the nucleus remains the same. The result is that the atom becomes an anion—an ion with a net negative charge.

Explanation:

What is the wave length of an electromagnetic radiation ,having a frequency of 5.2 x 10^12 Hz? Note: c= 3.00 x 10^8 m/s

Answers

Answer:

[tex] \huge{5.77 \times {10}^{ - 5} m}[/tex]

Explanation:

The wavelength of a wave can be found by using the formula

[tex]\lambda = \frac{c}{f} \\[/tex]

where

c is the speed of the wave

f is the frequency

From the question we have

[tex] \lambda = \frac{3 \times {10}^{8} }{5.2 \times {10}^{ 12} } \\ \\ \\ \\ \large{ = 5.77 \times {10}^{ - 5} m}[/tex]

Hope this helps you

An electrochemical cell operates because the electrodes in the two half-cells differ in their electrical potential. A metal electrode composed of ______ reducing agent will have a greater electrical potential to push electrons toward the electrode composed of a ______ reducing agent.

Answers

A metal electrode composed of  strong reducing agent will have a greater

electrical potential to push electrons toward the electrode composed of a

weak reducing agent.

Strong reducing agents are compounds which donates or loses electrons

with a corresponding increase in the oxidation state. Weak reducing agents

can also be referred to as oxidizing agents and they accept the electrons

from the strong reducing agents which results in a reduction in the oxidation

state.

The strong reducing agent has a greater electric potential which aids the

electrons being pushed towards the electrodes with a weak reducing agent.

Read more on https://brainly.com/question/7484765

Other Questions
What is the unit rate of km per hour in the example below?You can walk 7/10 km in 1/4 hours. Which statements describe the principles of design?1. Dominance determines the order in which viewers notice the design aspects. 2. On the other hand, if you are using similar kinds of lines and geometric shapes instead of different organic shapes, you are adhering to the gradation principle. 3. The principle of contrast describes differences in pattern, color, shape, size, and texture. 4. Balance is another design principle that refers to a comparative relationship between the design items.5. All designs must conform to the balance principle.6. The principle of unity encompasses all the design principles.(THERE ARE MULTIPLE ANSWERS) Help with that please increase 400 in the ratio 3:5 Determine the value of x. Round to the tenths place. 30/4 65/x One of the MOST prominent aspects of formal operational thought is the ability to: Group of answer choices reject adult thoughts and values. think in terms of possibilities. take another person's point of view. use creative impulse as a problem-solving skill. As a result of mitosis, each of the two new cells produced from the parent cell during cytokinesis. What is 3/1,000 as a decimal On the way to her babysitting job, Mary rode her bike for the first mile. She stopped at a traffic light and waited a few minutes for the traffic light to turn green. She then walked her bike across the street and up a short steep hill. Finally, she rode the bike at a constant speed for one more mile. If Mary created a graph of her time and distance, which statement describes the part of her graph that would show no change in distance?A.Mary used her bike to ride the first mile.B.Mary stopped and waited for the traffic light to turn green.C.ary walked her bike across the avenue and up a short hill.D.Mary rode her bike at a constant speed for one mile. x^2 + y^2 = z^2 A) The square of the sum of the first number and second number is the square of the third numberB) The sum of the square of the first number and the square of the second number is the square of the third numberpls need help with this.. 1a form of government in which the political power rests with a single leaderChooseA. VoteB. Autocraticcountry.C. DemocraticD. CitizenE. Presidential Democracythe political power rests with the nation'sF. Parliamentary Democracy will give brainliest You have three gases in a mixture where P1= 100 kPa, P2 = 50 kPa, and P3 = 75kPa. What is the total pressure of the gas mixture?A. 225 kPaB. 25 kPaC. 75 kPaD. None of the above Graph the function below, to estimate the practical domain of the function.=0.0150912++6A. 071.5B. 071.5 The burning of fossil fuels contributes to the addition of greenhouse gases to the atmosphere. These gases trap thermal energy in the Earths atmosphere. Which of the following would be the most reasonable changes that could result from an increase in the burning of fossil fuels? select the appropriate historical/musical periodoptions:1. Romantic2. Modern/20th century3. Baroque4. Classical In The Red Badge of Courage, the lieutenant says, If I had ten thousands wild cats like you I could tear th stomach outa this war in lessn a week! Who is he referring to in this quote?A. Jim ConklinB. HenryC. WilsonD. The tattered soldier What is the equation of the line that passes through points (10,6) and (2,2) ? Which sentence uses a comma correctly to set off a introductory phrase? O A. My best subjects are, math, music and spelling. O B. To begin, my aunt is making me babysit my cousins that day. O C. For example, I always turn in my homework on time and study for tests. O D. "Leave me alone!" he said, slamming the door. The cost of a blue balloon is 4 times the cost of a yellow balloon. Rashmi spent 910 in buying both blue and yellow balloons, find the cost of a blue balloon?