Math Student Help

Excel: Is it possible to create a pivot table using source data from more than one worksheet at once?
I cannot find the Wizard on Excel 2007- Was that removed?

Yes you can create pivot using multiple Worksheets. But this function is not as flexible as you create pivot table using single sheet.
Sturcture of all the tables must remain same to take the advantage of this feature.
use keyboard short keys to aproach if you are using 2007 version otherwise the multiple table merging option may not be visile to you.

Press Alt + D followed by P

Select third option "Multiple Consolidation Ranges"
Click Next
Select "Select a Single Page Field for me"
Click Next

Now Select First range and Click on ADD
Add
and Select & Add as many ranges you want to consolidate.

Click Next/Finish

Now a Pivot is created using default fields.
Remeber Only First column values will be treated as row label
and First Column Values will be treated as Columns.

you can drag Column values before and after only column values and can change the way of calculation for the column labels.

As I have already stated you that this is not much flexible function but still very useful. you can experience it yourself while using it.

http://xlxpart.blogspot.com

What does the collectors addition come with that the regular 60 dollar game doesn’t?

when u get tired of it you can sell it for twice as more

I have homework and i have to change a fraction to a ratio. My mom says it already is a ratio but my teacher said a ratio is like 3:1. Even easier what is 5/24 as a ratio.

**It would be 5:24**

I have a brand new TI-nspire and i don’t know how to enter fractions on it. I use to have just a crappy cheap one, but since i am gonna start Calculus I upgraded. Please note that it does not have the a b/c button.

you can enter them in with ( )
if you have 5/6 you just put it in (5/6)
that way it divided it and it becomes a fraction but doesn’t affect anything else

you can use additon, subtraction, division, and multiplication as many times as you want but you can only use the numbers once.
you have to use 8,8,3,3 all but only once

like…
8*8*3*3

could it be 8 * 8 / 3 +3?
8 * 8 / 3 +3 = 64 / 3 +3= 21,3 +3 = 24,3

It’s 8th grade algebra, and I have a terrible time concentrating, let alone studying…..

P.S I’m actually supposed to be studying now.

* You can do study cards.
* Read the problem over & over again, until you learn it.
* Look at ur notes, and make ur own problems and solve it.
* Spend plenty of time studying.
* Go to a quiet place, with no distractions.
* Ask for someone to quiz u.

Hope i helped:)

How do i calculate percentages with decimals?
alright how do you calculate a 1,000 with like state tax rate 6.75 percent this is a pain in the *** i hate math how much is it i forgot you move decimal

Sometimes it’s easier to start by finding 1% of whatever it is.

1% of $1,000 = $10
6.75% of $1,000 = 6.75 x $10 = $67.50

Add this to the original amount:
$1,000 + $67.50 = $1,067.50

––––––––––––––––––

I’m studying for my GED and I’ve been doing SO well, until I came across canceling and multiplying fractions. I am so lost. I need help. I DON’T get it. One problem I am stuck on is 9/14 times 10/11. Can someone describe to me in FULL detail how to do this? Thanks!

Its one of the easiest things to do…you just multiply straight across… top number * top number and bottom number * bottom number.

so in your example of 9/14 times 10/11 (9*10 = 90) and (14*11 = 154) and you end up with 90/154. However the hard part is that 90/154 can be reduced.

Fractions that need to be reduced is like saying I have 2/4 of a cup of water instead of saying 1/2. This is the hardest part. Finding which number will fit into both the top and bottom number. 6/9 can be reduced to 2/3 by dividing both the top and bottom numbers by 3. But the trick is everything must divide equally without leftovers.

There are a few tricks to help you out. Take the 6/9. use the smallest number (6) and figure out what you can multiply together to get 6. There’s 1×6 and 2×3. 6 doesn’t divide equally into 9 and neither does 2. But 3 does. 6 divided by 3 = 2 and 9 divided by 3 = 3 and you end up with 2/3. This is called reduced by 3 because 3 was the only number that divided equally into both the top and bottom number.

Going back to your problem of 9/14 times 10/11 = 90/154. 90/154 can only be reduced by 2 leaving you with 45/77. I know it’s confusing, but I hope this helps. Good luck on the GED.

My little brother came up to me and asked for help in his math homework. His problem is $100.00 - 55.99 the answer is 44.01 but he wanted to explain why. How can I explain regrouping with multiple zeros’ to him instead of just saying, " That’s the way it is?" My little brother is in third grade.

have him do 23 minus 7 with crackers.

use small goldfish for the ones, and saltines for the tens.

So he gets 2 saltines and 3 fish. As soon as you tell him the saltine is worth 10 fish - he will see that he can borrow by "trading it in" to you - so he can subtract 7 from his grouping.

He should then be able to see why you have to borrow from each spot. look up more on place value if you want to find some other activities for his level.

I am sophomore in high school and right now I am taking algebra 2. I am confused between what math class I should take. collage algebra or pre calculus. Any suggestions would help!
tell us your grade in alg. 2 and if its a high B or A, then I suggest going to pre-calc. however if you suck at alg. 2 and have a low grade, DEFINATELY go with college algebra cause college alg. is SIGNIFICANTLY easier than pre-calc.