0
The area on the status bar displays common calculations such as sum or average for selected numbers in the worksheet?
Wiki User
∙ 11y ago
There is not a specific name for that area, but it is sometimes referred to as the Autocalculate area. It appears towards the right end of the status bar. If you select a number of cells with values you will see the Sum of them in that part of the Status bar. It is possible to change what it shows to something other than the Sum, such as the Average or the Count. In the latest versions of Excel it can show several things at once, rather than just one statistic at a time.
Wiki User
∙ 12y ago
Wiki User
∙ 11y agoautofunction
Add your answer:
Earn +20 pts
When will AutoCalculate will quickly add selected cells?
When worksheet cells are selected, a message displays on the status bar in the AutoCalculate box. AutoCalculate is not a substitute for writing worksheet formulas or functions. However, it is handy for making quick, temporary calculations that are not recorded on the worksheet. AutoCalculate can average, count, sum, and find the minimum or maximum number in a group of numbers. The default calculation is SUM. To use AutoCalculate, click and drag across the values you want to calculate. The sum of the values will display automatically on the status bar. To make a different type of calculation (for example, an average), right-click the AutoCalculate box on the status bar to display its shortcut menu. Choose the appropriate type of calculation.
simple calculations?
in simple calculations we use + - × ÷ in computer like sum average min and max
How does the worksheet help the teacher?
it makes an average in your grade
What separates more than one cell in Excel?
On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)
What is the difference of finding average from raw data and from frequency distribution?
Finding the average from the raw data requires a lot more calculations. By using frequency distributions you reduce the number of calculations.
The AVERAGE function displays the lowest value in a range?
No. The MIN function displays the lowest value in a range. The AVERAGE function gets the arithmetic mean of a set of values. It totals them up and divides by the amount of numbers.
What displays information about selected data including the number of cells?
As you select cells, the number of rows and columns being selected is shown in the Name box. Once you have finished selecting, the address of the active cell or of the range will show with those cells selected. On the status bar you will see the total of any values in the cells. This can be a quick way to see what the total of values in cells are, without using a formula. It is also possible to see other things, like the average.
What is the percentage of flesh in the average human body?
The percentage of flesh in the average human body according to my calculations should be 35,74429%
What is the calculations for average speed?
Average speed = (distance traveled during some time) divided by (length of time to travel that distance)
Why are titers averaged before doing the calculations?
An average is more sure than an individual result.
How to calcualte average?
i think t means complex calculations like averaging the results o
In addition to average temperatures and average rainfall climate includes .................... and .............................?
The question isn't very specific as it does not state a location of the average rainfall climate. This is also very clearly copied straight from a worksheet.
