This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Use the ^ Sign for Exponents
Problem: I have a room that is 10 feet x 10 feet x 10 feet. How do I find the volume of the cube?
Strategy: The formula for volume is width x length x height. In this case, it is 10 x 10 x 10, or 103. In Excel, the caret symbol (also known as “the little hat," or “the symbol when you press Shift 6") is used to indicate exponents. Here’s how you use it to find the volume of your room:
1. In cell B2, enter 10.
2. In cell B3, enter the formula =B2^3.
The result will be 1,000 cubic feet of volume in the room.