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
What type of charts can be used to express data?
you can use a pie chart, a graph chart, or a graph chart. Hope i helped!
Which function adds all the numbers in a range without having to write a formula?
If you mean Excel, you always need a formula; there is no way around that. As a shortcut to adding numbers individually, you can use the SUM() function. Within the parentheses, you can write a range, for example:
=SUM(A1:A4)
This is a function but it is still also a formula. You may have confused the two things. All functions in use are in formulas and you can have formulas that have no functions.
The average function is determined by dividing sum function by what function?
The average of a set of numbers is equal to the sum of those numbers divided by the number of numbers.
So, one might say that the average function is equal to the sum function divided by the count function.
What function compare the numbers in the specified range and then return with the largest number?
Maximum.
It is an individual value within a chart, like on a line chart. The lines on the chart link the actual points that represent the values. Other types of charts have individual values so they can be referred to as points.
It is an individual value within a chart, like on a line chart. The lines on the chart link the actual points that represent the values. Other types of charts have individual values so they can be referred to as points.
It is an individual value within a chart, like on a line chart. The lines on the chart link the actual points that represent the values. Other types of charts have individual values so they can be referred to as points.
It is an individual value within a chart, like on a line chart. The lines on the chart link the actual points that represent the values. Other types of charts have individual values so they can be referred to as points.
It is an individual value within a chart, like on a line chart. The lines on the chart link the actual points that represent the values. Other types of charts have individual values so they can be referred to as points.
It is an individual value within a chart, like on a line chart. The lines on the chart link the actual points that represent the values. Other types of charts have individual values so they can be referred to as points.
It is an individual value within a chart, like on a line chart. The lines on the chart link the actual points that represent the values. Other types of charts have individual values so they can be referred to as points.
It is an individual value within a chart, like on a line chart. The lines on the chart link the actual points that represent the values. Other types of charts have individual values so they can be referred to as points.
It is an individual value within a chart, like on a line chart. The lines on the chart link the actual points that represent the values. Other types of charts have individual values so they can be referred to as points.
It is an individual value within a chart, like on a line chart. The lines on the chart link the actual points that represent the values. Other types of charts have individual values so they can be referred to as points.
It is an individual value within a chart, like on a line chart. The lines on the chart link the actual points that represent the values. Other types of charts have individual values so they can be referred to as points.
How many decimal digits can be used with the fixed or currency format?
What information does a line chart compare?
It allows you to visualize and compare trends of data over intervals of time.
How do you change column A default to a numeric number?
In Excel all columns default numeric characters to numbers.
You've described a single number. If you want it to appear in E15,
then put this formula in E15:
= SUM(E1:E10) - SUM(D1:D10)
UPDATE: I tried that, but it only gave the total addition of both of those colums. I asked my co-worker, who gave me this solution: =SUM(D11:E11). That gives the difference between the two combined. Don't know why I didn't think of it like that...lol
Thank you for all of your assistance.
Why is the function in excel that finds the remainders of two numbers called MOD?
It is the short for MODULUS DIVISION which is an operation of division that aims to get the ramainder rather than the whole number.
Explanation of if you give everyone a slice of your pie you will still have more than enough?
it means u have enough pie to give everyone a second piece.
Three particular items to look for on a chart or graph are?
Description (title) of the chart so that you know what the chart is intended to display;
Labels for categories (or independent variable), with scale, if appropriate; and
Values for dependent variable with scale.
9 - (5 x 6/-2) = 9 -(-15) = 9 + 15 = 24
How do you get a random number generator on Microsoft Excel?
"=rand()" in a cell gives a random number between 0 and 1. Every time the sheet is recalculated (F9 key) a new random number is generated.
How are sever cases of subdural hematomas treated?
In more severe cases, surgical intervention is necessary. The surgeon will open the skull in a procedure known as a craniotomy and remove the blood clot to release the pressure on the brain.
How do you calculate number of days between two dates?
Put the two dates into separate cells. Say you put the earlier one in cell A1 and the later one in cell A2. Then in cell A3 you could put the formula:
=A2-A1
This will initially give you a date. Then you would format the cell as a number, using the Format menu and the Cells option and the Number option. Alternatively you could click on the comma icon on the formatting toolbar. The number that is displayed will be the difference in days between the two dates.
Another way to do it is with the Datedif Function.
=DATEDIF(Date1, Date2, Interval)
Where:
Date1 is the first date.
Date2 is the second date.
Interval is the interval type to return.
If Date1 is later than Date2, DATEDIF will return a #NUM! error. If either Date1 or Date2 is not a valid date, DATEDIF will return a #VALUE error. The Interval value should be one of "d", "m", "y", "ym", "yd" or "md". These will give you the result in days, months, years, months excluding years, days excluding years and days excluding years and months.
For the earlier example you could do it like this:
=DATEDIF(A1,A2,"d")
bitmap. seriously. it's a bitmap
There are many ways to do this, including writing a custom macro. The easiest way is to use an IF statement.
- In Column A enter your wins and losses (1 or 0). Start with A2. For this example, continue to A17.
- In B2 enter the formula to count consecutive wins: =IF(A2=1,A2+B1,0)
- Copy the formula from B2 down to B17.
- If you like, you can hide column B, so people will not see your calculations.
- In A18 enter the formula to select the maximum number of consecutive wins: ="Longest Winning Streak is "&MAX(B2:B17)&"."
If a pie has 8 slices and you eat 1 fourth of the pie how many slices did you eat?
dose it really matter ?
Yes. For many types of data, using bar charts is very useful. If you want to compare related categories of figures, or maybe total sales for different months or a myriad of other types of things, then a bar chart is very useful. All types of charts have their uses. Bar charts are amongst the most common type of charts you will see.
