Skip navigation

Adding video

Adding video: Excel 2008 for Mac Essential Training
Adding video: Excel 2008 for Mac Essential Training

Join for an in-depth discussion in this video Adding video, part of Excel 2008 for Mac Essential Training.

Resume Transcript Auto-Scroll
Skill Level Beginner
8h 25m
Duration
375,066
Views
Show More Show Less

Q: How does one generate an average using cells in columns that are not consecutive i.e. a7,c7,e7...?

A: To get an average of non-contiguous cells, you can either select them individually, or type them in manually.  Here are the steps involved:
1. Click in the cell where you want the average to appear
2. Start the function by typing: =average(
3. Now, either type the cells addresses (ie A7,C7,E7) or select each cell by clicking them while holding the Command key.
4. Close off the function with closing round bracket: ) and press Return key
You should see the answer in the cell where you entered the function.  Checking the formula bar, your finished "formula" will look something like this:
=average(A7,C7,E7)

Skills covered in this course
Business Spreadsheets Excel for Mac

Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Start Your Free Trial Now

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now