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

Explain Main Difference Between System Software and Application Software

Topic: Explain Main Difference Between System Software and Application Software            Differentiate between system software and application software Before , explaining the main differences between application software and system software, let us know the definitions of Application software and System software with examples. What is System Software: System software is a set of programs to control all components of computer and to manage overall operations of computer system. Differences between System software and application software System software is used as a base to install and run all application software. Examples of system software include: Operating Systems, like Microsoft Windows, DOS, Unix and Linux Device Drivers like Device driver software of a Printer (found on CD normally provided with the printer) Utility Programs like AVAST anti virus, Disk Scanners and File Viewers etc. What is Applicat...
10 comments
Read more

HTML Table Tag Basics

Tables Tables are very important to show data in the form of rows and columns. Tables make data more readable and easy to understand. A table consists of rows, columns and cells. HTML Tags To Make A Table As we know that there are basically three elements in a table, that is, rows, columns and cells. So, there are the following basic tags to create a table in an HTML web page: <TABLE> tag <TR> tag <TD> tag <TH> tag   <TABLE> Tag <Table> tag is used to specify the start of a table. It also specifies some attributes of the table like ALIGN and BORDER attributes etc. Example 1: <Table>                    => Table without a border. Example 2: <Table border="1">     => Table with a border of width 1. Example 3: <Table align="left" border="2">  => A left aligned Table with a border of width 2. ...
Post a Comment
Read more

Types Of Headings In HTML

HTML Hedings Headings in HTML are used to display Titles, Sub-Titles of Sub-Sub-Titles for your web page text. There are six types of headings in HTML. H1 is the largest heading and H6 is the smallest heading. <H1> is opening tag whereas </H1> is the closing tag for the largest heading. The text between <h1> and </h1> will be displayed as the main Title in your web page. Following are the six tags used for six types of headings in HTML. <H1> ... </H1> <H2> ... </H2> <H3> ... </H3> <H4> ... </H4> <H5> ... </H5> <H6> ... </H6> The H1 heading is used for main titles. Actually H1 heading will show the text in largest font size. H2 headings is used for Sub-Titles. H2 displays text in smaller font size than H1, H3 displays text of font size smaller than H1 and H2, and so on. H1 is for largest heading in a text page and H6 is for smallest heading.   Importance Of Headings in SEO H...
Post a Comment
Read more