Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
JulieD
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you count number of characters in a single cell Joe Excel Worksheet Functions 1 February 18th 05 09:08 PM
How do you count number of characters in a single cell Joe Excel Worksheet Functions 1 February 18th 05 08:33 PM
How do you count number of characthers in a single cell? Joe Excel Worksheet Functions 2 February 18th 05 08:06 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
single quote 10-digit number that has leading zeroes & then conca. lorelei739 Excel Worksheet Functions 1 November 5th 04 12:02 AM


All times are GMT +1. The time now is 09:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"