The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training courses london - Excel Formulas

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

microsoft excel training courses london - Excel Formulas

Resolved · Low Priority · Version Standard

ReplyWed 22 Nov 2006, 09:40Delegate Yvette said...

Excel Formulas

1) What is the formula entry to get and average of a column of figures

2) What is the formula entry to get the highest number to appear from a column of figures

3) What is the formula entry to get the lowest number to appear from a column of figures

Thanks in advance

For upcoming training course dates see: Pricing & availability

ReplyWed 22 Nov 2006, 10:11Trainer Orok said...

RE: Excel Formulas

Hi Yvette,

In response to yur query,

In each example, first place your cursor where you want the result of your calculation to be displayed.

1) The formula to get the Average of a column of figures is =AVERAGE(A1:A10)
Where A1: A10 represents a column of cells containing the figures that an average is required for.

2) The formula to get the Highest number in a column of figures is =MAX(A1:A10)
Where A1: A10 represents acolumn of cells containing the figures that highest is required for.

3) The formula to get the Lowest number in a column of figures is =MIN(A1:A10)
Where A1: A10 represents a column of cells containing the figures that lowest is required for.

Hope this helps

Excel articles

· A Hidden Gem In Excel - Formula Auditing
· How To Ensure You Always Make A Complete Data Recovery
· Make More of your Money with Excel 2007
· How To Use Conditional Formatting In Excel
· How to start using Excel 2007 Functions

Excel tip:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

View all Excel hints and tips

Are there free MSP exercise manuals available?

» Forum post: Project exercises

If you want to add a row to an Excel spreadsheet, these are the simple steps you should take:

With your mouse, right click on the row header below where you want the new row to be added. Then, click Insert.

Follow exactly the same steps if you want ...

» Tip: Adding Rows or Columns

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions