Microsoft Excel: Use ^ Sign For Exponent

Problem: You have a room that is 10 feet x 10 feet x 10 feet. What is 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 ten to the third power. In Excel, the carat symbol (also known as “the little hat”, or “the symbol when you press Shift 6”) is used to calculate exponents. In cell B2, enter 10; in cell B3, enter the formula =B2^3. The result will be 1000 cubic feet of volume in the room, as shown in Fig. 435.

Summary: Use a carat to calculate exponents.

See all Microsoft Excel tips

Images