Read Excel Tips Such As How To Use ^ Sign For Exponent At BrightHub.com
RSS
 View all Hubs
See what's in...

Microsoft Excel: Use ^ Sign For Exponent

Article by Mr Excel (11,376 pts )
Published on Jun 25, 2008
Problem: You have a room that is 10 feet x 10 feet x 10 feet. What is the volume of the cube?
39 views

See all Microsoft Excel tips

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

Fig. 435

Bright Hub - Science & Technology Articles, Buyer's Guides, How-To Tips and Software Reviews
About Bright Hub | Contact Us | Terms of Use | Privacy Policy | Copyright Policy | ©2008 Bright Hub Inc. All rights reserved. Page copy protected against web site content infringement by Copyscape