# Creating and deleting themes

Join for an in-depth discussion in this video Creating and deleting themes, part of Excel 2008 for Mac Essential Training.

Resume Transcript Auto-Scroll
8h 25m
376,478

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

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