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.

Comments

Popular posts from this blog

Introduction to Algorithms and Algorithmic Notation With Examples

Topic: Introduction to Algorithm and Algorithmic Notation With Examples What is an Algorithm? The step by step procedure to solve a particular problem is called an Algorithm .  A Good Programmer always writes algorithms before developing programs. Algorithmic Notation with example algorithms  Advantages of  writing an Algorithm The process of solving a problem becomes simpler and easier with the help of  algorithm. There are less chance of errors in the program, if we design algorithms before writing our programs in any programming language. We can convert an algorithm into a program of any programming language. It is not dependent on any programming language. Therefore it is easy to understand for anyone even without programming knowledge. What is the Relationship between an Algorithm and a Program Sponsored Links An algorithm is the sequenc of steps to perform a task, whereas a program is the set of statements to perfor...

Define Data and Information With Examples

DATA Data is the collection of raw facts and figures. Actually data is unprocessed, that is why data is called collection of raw facts and figures. Define Data and Information with Examples We collect data from different resources. After collection, data is entered into computer for processing. Data may be collection of words, numbers, pictures,  or sounds etc. Examples of Data 1) Student Data on Admission Forms When students get admission in a college. They fill admission form. This form  contains raw facts (data of student) like name, father’s name, address of student, obtained marks, photo graph etc. 2)    Data of Citizens During census, data of all citizens is collected. The staff will go house to house and collect data about citizens like number of persons living in a home, either they are literate or illiterate, number of children, data of each child, cast, religion, Computerized national Identity Card number, address, how many rooms and...

Explain Different Types of Software

Topic:  Different Types of Software with Examples Types of Software Different Types of Software with Examples There are two  main types of software  -  system software and application software . Let us discuss these types of software in detail with examples of each. System Software System software is a set of programs used to implement certain functions in a computer system. System software  controls the overall operations and components of a computer system. We can say that system software is the base on which application programs are executed. System software provides an interface between user and computer. Users use this interface to interact with the computer and perform different jobs on computer. Operating systems like Windows, Linux and Unix are the main example of system software . Similarly device drivers software are also examples of system software. Examples of system software Examples of system software are as follows: •...