answersLogoWhite

0

📱

Microsoft Excel

Excel is a spreadsheet application developed and distributed by Microsoft Corporation for computers using the Microsoft Windows and Mac OS X operating systems. It features graphing tools, chart wizards, calculations, formatting options, and pivot tables.

9,788 Questions

How do you make a line chart with Excel 2007?

Select the values that you want to chart. Then on the ribbon go to the Insert tab and you can choose a line chart from there to create it.

What is the prefix of query?

query is term generaly means to find something which if a person wants

Where do you use bar charts?

If you were talking about bar graphs,Then you would use them when you were graphing stuff.Like how much things like 97% Oceans 3% Fresh Water. You would put those things in a bar. I'm sorry if I am saying the wrong thing!

How do you do a statistical analysis on excel?

* http://www.leansigmamart.com Starting with understanding the DMAIC method, with out this you are never going to have successful results. I recently discovered this site dedicated to answering all the Lean Six Sigma / process improvement needs and questions. They offer a FREE very complete software system that will walk you through the entire DMAIC methodology. It has a training video at every possible step including example data, video demonstration, voice guided instructions, templates for every step, and a phone contact to even help you. Oh and did i say FREE? In that site they also have a forum for Q. & A. beside a live chat room. Do you use minitab? How about a complete section on how to use it with videos and links to their home page. They have so much more I cant list, just go there and see. I spend countless hours looking for answers as you did here. I found a source with accurate information and gives you what you are really looking for, plus a way to drive your projects with a mentor.

What are data series?

A data series is a collection of data, most likely numbers, that you would use to graph or solve an equation.

How do you make a dot plot on Excel?

It's called an X-Y scatter plot. The procedure is different depending on which version you have. Basically, you highlight all of the cells containing, the data; click on 'Insert' then click the icon that looks like a 'dot plot' and it should have the word 'scatter' underneath it.

How do you add the total or a column full of numbers without using a calculator?

Since you put this question in the Excel category, I will answer relative to what you can do with Excel. The quick way is to highlight the column of numbers and click on the Auto-Sum button.

What are 3 examples of data being sorted in descending and ascending order?

Any data that is keyed to a numeric or text field may be sorted in ascending or descending order.

Data that is keyed to a date may be sorted in chronological order (ascending with oldest first) or reverse-chronological order (descending order with newest first).

Data that is keyed to a price may be sorted with most-expensive first (descending order) or least-expensive first (ascending order).

Data that is keyed to a weight may be sorted in ascending or descending order of weight.

And so on.

How do you calculate treynor ratio in Excel?

calculate the effective return (mean return minus the risk free rate) divided by the beta.

the excel spreadsheet in the related link has an example.

What is a chart tool on Excel?

It allows you to make charts or graphs. You will find it in the Charts section of the Insert Ribbon in Excel 2007.

The chart to use for displaying trends over a period of time is a what kind of a chart?

A line chart would be the best chart to do that. However, it could also be done with a bar or column chart. You can also add trendlines to them to help show a trend.

Is B1 correct?

In Excel, B1 is a cell address where column B and row 1 meet.

What was number 1 in the charts on the 19th January 2007?

The number 1 on the U.S. charts on the 19th January 2007 was Beyonce's 'Irreplaceable'. The number 1 on the U.K. charts on the 19th January 2007 was Leona Lewis's 'A Moment Like This'.

What is e called if used in a maths problem?

Assuming it is not a variable, e is also known as Euler's Constant.

Wait a minute, Euler's Constant is something different. e is known as Euler's number (which is about 2.718...) or sometimes known as the base of the natural logarithm. Most maths people and examiners should know what 'e' is though, so you can use it in formulae safely. It's called Euler's number to prevent people getting confused with Euler's Constant. Euler's Constant however is 0.5772... (it's actually called the Euler-Mascheroni constant) which is signified by a backward 'r'. I mean no disrespect towards to previous answerer. Hope I helped

Which chart type would be the best candidate to spot trends and extrapolate information based on research data?

A scatter chart would be the best candidate to spot trends and extrapolate information based on research data.

Is it okay to use nepotism to get a job?

Ah nepotism, it's always around but so often denied. It's my personal opinon that as long as you excell at your position without tapping into that friend/family aspect of it, it's not a horrible thing. It's the ones that don't do their job, and others are always taking the fall because of it, that I think most people can't stand.