I created a PivotTable and PivotChart on Excel. The next step I need to do is rename the worksheet I created to SummaryData.
double click on the name tab at the bottom of the worksheet it will highlight. Just type the new worksheet name and a carriage return and it will be renamed.
Also, how do you convert a fraction to a decimal?
HOW TO CONVERT A DECIMAL TO A FRACTION
Here’s how to convert .234 to a fraction…
There is not much that can be done to figure out how to write .234 as a fraction, except to literally use what the decimal portion of your number, the .234, means.
Since there are 3 digits in 234, the very last digit is the "1000th" decimal place.
So we can just say that .234 is the same as 234/1000.
We can reduce this fraction to lowest terms by dividing both the numerator and denominator by 2.
Why divide by 2? 2 is the Greatest Common Divisor (GCD)
or Greatest Common Factor (GCF) of the numbers 234 and 1000.
So, this fraction reduced to lowest terms is 117/500.
HOW TO CONVERT A FRACTION TO A DECIMAL:
OK, so there’s a few steps to set up here in order to convert 5/17 into a decimal.
* First off, we’ll interpret the fraction bar to mean "divided by." This means that 5/17 is the same as 5 divided by 17.
* Second, you have requested to see 3 decimal places in your answer, so we’ll write the 5 as 5.000 instead (a 5 with 3 zeros after the decimal point).
* Now, we’ll just do what the fraction bar says: divide 5.000 by 17:
5/17 = .294
This question was on my test and I wanted to know if I got it right. The question was: True or false, an opening or closing parenthesis can be used to indicate multiplication. I guessed and put down false. Which is it, and if it is false, why? Thank you!
true
you can put a variable next to a number to indicate multiplication, such as 5a
it is the same thing as that, except you are using a number instead of a variable
say 5(5) was the multiplication problem
it could be written as 5 x 5 or 5(5).. same thing, it doesnt make a difference,
Explian how you know to use a variable in an addition or subtraction expression?
Give an example.
For example, if you have 10x + 6x it equals 16x.
If you have 10x - 6x it equals 4x.
What you cannot do is add or subtract different variables such as 10x - 4y. That stays 10x - 4y.
I don’t know if that answers your question.
I have some data e-mailed to me on one workbook on 3 different worksheets. This is my first time using Excel so I have no clue what I’m doing. I have 3 columns on each that I need to copy to one new worksheet, but the values aren’t manually entered, they are by formula, so I get a reference error if I just try to copy them. How can I get the data all onto one worksheet?
You have two choices.
1) Copy, then Paste special-> Values. This will copy over the values and remove the formulas (permanently). Paste special can be found on the Edit menu in Excel 2003.
2) Change the formulas on the new w/sheet to reflect the new position of the data. You can often change one cell, then drag it down and across. For instance if your cell says =Sheet1!A1, remove the Sheet1! so it says =A1, then drag the formula down and/or across. But this only works if all your formulas have the same format. Otherwise it’s a tedious manual task.
I am having about 15 people over for lunch this Sunday. I am making two types of soup: Broccoli Cheddar and Jalapeno Corn Chowder and also having bread/biscuits. My husband thinks we should have something else in addition to the soup so I am looking for suggestions as to what would pair good with these soups. The majority of the guests are vegetarians, so please no meat suggestions 
A simple salad would accompany the soup well. try to avoid overloading it with cheese or all that stuff bc you want the salad to be a contrast to the thick soups.
I need to rewrite 6/15 as a fraction with a denominator of 20. So, my problem is:
6/15 == ?/20
Please show me the steps so I can perform this operation on any proper fraction! Thanks.
Find out what you have to do to get from 15 to 20. You multiplied 15 by 1 and 1/3. Do the same for the numerator. So multiply 6 by 1 and 1/3 to get 8. The answer is 8/20.
Hope this helps:)
I am an adult and i was a very slow learner in school and i never got to learn division and only learned a little bit of multiplication. dose anyone have any sites i can go to to learn them online i am a student to become a medical assistant and i want to learn it. please help.
If you did not get this in grade school, you will probably not understand it from an online source. I suggest that you go to the nearest community college that has remedial mathematics courses.
How does geometry influence the lives of biologists and artists? why would knowing and being able to work with geometry make artists’ work more interesting and sometimes easier? Please be serious, and information. Thank you -Erin
Every artist uses geometry weather they know it or not.
Definition:
1. mathematics of shapes: the branch of mathematics that is concerned with the properties and relationships of points, lines, angles, curves, surfaces, and solids
This is the key point to all art! Geometry was started after art its apart of it not the other way around. Just like how math was founded to support science.
i’m not sure how it relates to biologists(since im not one)
say I have a cell formatted to not show decimals but then i copy and paste a number with decimals into the cell. the formatting changes to show what i pasted. I don’t want that. lol I want no decimals. i guess what i need is to somehow lock the formatting.
Which version of Excel are you referring to? Unless you have a really old version, when you paste into a cell, a "paste options" box should appear at the bottom right hand corner of your cell (it looks like a tiny clipboard). If you click the arrow, it will have the options of "Keep source formatting" or "match destination formatting". Apparently you’re wanting ‘match destination formatting’.
If you have Excel 2003 or Excel 2007 and the paste options box is not appearing, then it has been turned off. You can easily turn it back on. If that is your case, and since I don’t know which version of Excel you have in order to give you steps to do so, here is a direct link to Microsoft to turn the paste options box feature back on…this includes both Excel 2003 and Excel 2007:
http://support.microsoft.com/kb/289577