microsoft excel training courses london - excel formulas

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

• Home
• Courses
• Promotions
• Schedule
• Formats
• Our Clients

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

# microsoft excel training courses london - Excel Formulas

Resolved · Low Priority · Version Standard

Yvette has attended:

### 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

### 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

Training courses

Training information:

 Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions What does 'Resolved' mean? Any suggestions, questions or comments? Please post in the Improve the forum thread.

### Jumping Across the Excel Screen

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Alt+PgDn and Alt+PgUp is the equivalent across the spreadsheet.

View all Excel hints and tips