Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am working on an assignment for school and I am being asked to calculate
the average, maximum and minimum of a single number. It says to use the autocalculate button. I am having difficulty with this task. Any assistance would be appreciated. Thank you, Crystal |
#2
![]() |
|||
|
|||
![]()
The average, maximum and minimum of a single number would be the number
itself. -- Vasant "Crystal7760" wrote in message ... I am working on an assignment for school and I am being asked to calculate the average, maximum and minimum of a single number. It says to use the autocalculate button. I am having difficulty with this task. Any assistance would be appreciated. Thank you, Crystal |
#3
![]() |
|||
|
|||
![]()
Hi Crystal
very odd question as the average, maximum and minimum of a single number is the number itself !?!? taking a guess as to what the question is really about - in ver 2002 and above the Autosum icon (looks sort of like an E) has a drop down arrow next to it, where you can choose from a number of different functions - in version 2000 and prior this functionality isn't here and you only can use the E for summing figures however, there is also an autocalculate function which lives on the bottom right of the screen ... down on the status bar - but this only works if you select 2 numbers ... try this, select any two numbers on your worksheet and have a look at the bottom right of the screen you should see the word SUM and a value, now right mouse click on this and you have Average, Min, Max amongst other things. Hope this helps Cheers JulieD "Crystal7760" wrote in message ... I am working on an assignment for school and I am being asked to calculate the average, maximum and minimum of a single number. It says to use the autocalculate button. I am having difficulty with this task. Any assistance would be appreciated. Thank you, Crystal |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you count number of characters in a single cell | Excel Worksheet Functions | |||
How do you count number of characters in a single cell | Excel Worksheet Functions | |||
How do you count number of characthers in a single cell? | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
single quote 10-digit number that has leading zeroes & then conca. | Excel Worksheet Functions |