Skip to main content

Posts

Showing posts with the label Use of Power function in Excel

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 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