Skip to main content

Use of Power and Sqrt Function in Excel Worksheet

Today, we will discuss the use of POWER( ) function and SQRT( ) function in Microsoft Excel Worksheets. We will prepare  a worksheet to practically learn the use of Power () function and Sqrt() function
as shown in the following figure:
use of POWER( ) function and SQRT( ) function in Microsoft Excel Worksheets
Use of POWER( ) function and SQRT( ) function in Microsoft Excel Worksheets

The Use of POWER( ) function in MS Excel Worksheet

POWER function may be used to raise a number to a certain power. For example, to calculate number 2 raise to the power of 3, we will type the power function as:
    =POWER(2,3)
which will return the result 8. If the number is in cell B3, we will type the power function as follows:
  =POWER(B2,3)

Steps To Create an Excel Worksheet To Demonstrate Use of Power() and Sqrt() Function

1. Start Microsoft Excel with a new blank workbook.
2. Type the data as shown below in the first worksheet.
3. Perform formatting in Excel worksheet as shown in the following figure.
4. Type data in Column A and Column B of worksheet.
5. In cell C3 of column C , we will type a formula using Power() function to calculate Square of given number.
6. Type = in cell with reference C3.
7. Type POWER(B3,2) and press Enter.
8. Since we have entered number 4 in B3 cell so Power(B3,2) will return 16 in cell C3.
  
The Use of POWER( ) function in MS Excel Worksheet
The Use of POWER( ) function in MS Excel Workshee

The Use of SQRT( ) function in MS Excel Worksheet

The Excel function SQRT is used to calculate the square root of any number given as its argument.
For example, if you use wish to calculate square root of 4, you will type SQRT function as follows:
  =SQRT(4)   
which will give 2 as a result.
9.   In cell D3 of column D , we will type a formula using Power() function to calculate Cube of given number.
10. Type = in cell with reference D3.
11. Type POWER(B3,3) and press Enter.
12. Since we have entered number 4 in B3 cell so Power(B3,3) will return 64 in cell D3.
The Use of SQRT( ) function in MS Excel Worksheet
The Use of SQRT( ) function in MS Excel Worksheet
13. In cell with reference E3  , we will type a formula using Sqrt() function to calculate Square root of given number.
14. Type = in cell with reference E3.
15. Type SQRT(B3) and press Enter.
16. Since we have entered number 4 in B3 cell so SQRT(B3) will return 2 in cell E3.

We have completed the task of creating a worksheet in MS Excel using Power function and SQRT() function.
Labels:

Comments

Post a Comment

Popular posts from this blog

Uses Of Computer In Education Field

Computer can be used in education in the following ways:  Computers In Teaching and Learning Process ( Computer Aided Learning - CAL ) Computers are being used actively in educational institutes to improve the learning process. Teachers can use audio video aids through computer to prepare lesson plans. They can use Microsoft Power Point to prepare electronic presentations about their lectures. These electronic presentations will be displayed on multimedia projectors in class rooms. This will be interesting and easy to learn for students. Multimedia presentations are easy to deliver for teachers too, These presentations save a lot of effort and time. Moreover multimedia presentations are interesting to view and hear sound and visual  effects. Computers will be helpful for:                        Instructing the students using PowerPoint slides, Word documents or Web pages and using hyperlinks for be...
1 comment
Read more

Types Of e-Commerce

Types/Categories/Modes of e-commerce. There are three main types of e-commerce as follows: 1) Business To Consumer (B2C) B2C ecommerce consists of selling goods and services to individual consumers. In this type, consumers or customers can visit the website and purchase goods online. The website will have a StoreFront. This storefront will show product details, pictures and a shopping cart. Shopping cart is used to collect items to purchase. Advantages of B2C e-commerce B2C e-commerce has the following advantages: * Shopping can be faster and more convenient. * Offerings and prices can change instantaneously. * Broadband telecommunications will enhance the buying experience. 2) Business To Business (B2B) B2B e-commerce takes place between two businesses. One business provides services to other business. Examples of B2B include: Online Advertisement, recruiting, sales, marketing, technical support and training. For eample, some companies provide online purchasing...
5 comments
Read more

Explain Different Types Of Computer Networks - LAN, MAN, WAN

Explain different types of computer networks:(LAN,WAN,MAN) Today, we will discuss the main types of computer networks on the basis of the maximum distance covered where they can be accessed and operate. The main types of computer networks are: LAN, WAN, MAN Explain different types of computer networks 1.    LAN - Local-Area Network 2.    WAN - Wide-Area Network 3.    MAN - Metropolitan-Area Network 1)LAN (Local Area Network) What is LAN or Local Area Network LAN stands for Local Area Network . It covers a small area. Most LANs are used to connect computers in a single building or group of near buildings. A network contained within a relatively small area, such as a classroom, school, or single building, is commonly referred to as a local area network. Hundreds or thousands of computers may be connected through LAN . LANs are used in office buildings, college or university campus etc. Local Area Networks can t...
Post a Comment
Read more