POWER Function in Excel

By

In this blog post we will learn to about POWER function in excel.

Whenever we want to return value of a number raised to its power then we can use POWER function which is readily available in excel.

What is POWER of a number?

In mathematics, POWER of a number means how many times a number we want to use in multiplication.

For example, 5^2 (5 to the power of 2) means 5 is used twice in multiplication (5x5 = 25).

2^3 (2 to the power of 3) means 2 is used three times in multiplication (2x2x2 = 8).

Where to find POWER function on Excel Screen:

POWER function can be found under “Math & Trig” function category under “Formulas” tab and under “Function Library” group as shown in below image:


Once we click on “Math & Trig” function category, we can see list of various Math & Trig functions available in excel. POWER function is highlighted in blue in below image.


Once we click on POWER option as highlighted above, we will get the function argument dialog box as shown in below image.


Syntax of POWER Function:

The Syntax of POWER function is as below:

=POWER(number, power)



Arguments of POWER Function:

POWER function takes two arguments, and both are mandatory.

number: This is base number, and it can be any real number. (i.e., which number we want to use in multiplication).

power: This is exponent to which base number is raised (i.e., how many times we want to use above number in multiplication).


Example of POWER Function:

We have listed few random numbers in column A and column B. The numbers from column A are base numbers and numbers from column B are exponents. With the help of these two columns, we will learn to use POWER function.


For this select a cell where we want to apply POWER function. In this case we have selected cell C2.


Apply POWER function in selected cell C2 as shown in below image.



Once we press enter button on our keyboard then we can see the output of POWER function.



To find the output in remaining cells just copy and paste the POWER function in remaining cells. We see the output as shown in below image.


In this way we can use POWER function in excel.
Microsoft Certified Excel Expert, Enthusiastic to teach excel tricks and basic excel concepts which will help to save time and efforts in our daily office work.

Comments

Post a Comment

Related Topics..

Fill Up, Down, Right & Left in Excel

By
Image
Excel has many great tricks which can help us to save our time while working on big data. In this blog post we are going to see one of those tricks where we can fill the data to the upwards of the selected cells, to the downwards of the selected cells, to the right of the selected cells and to the left of the selected cells. There are many situations where we may need to copy the data from selected cell to the upward, downward, left and right cells. But how can we do so?? In excel we can do so with the help of “Fill” command. This command we can found in: Home Tab --> Editing Group --> Fill Command. Let’s take an example. We have inserted a text “Tejraj” in a cell “D5”. Now we will see how to fill this text from cell D5 to Up, Down, Right & Left. Fill Down: 1. Let’s assume that we have to fill the data from cells D5 to D10. For this, select the Cell Range D5:D10. Keep in mind that the data from 1st cell of the selected Cell Range will fill down in entire selection. 2. Select ...
Read more

Restrict Cells to Accept Only Decimal Values Using Data Validation

By
Image
In this blog post we will learn to restrict the cells to accept only decimal values with the help of “Data Validation” functionality in excel. For example, we want to ask user to enter only decimal values which are less than 5.00 in cell. If user enters any other value which is greater than 5.00 then the cell should not accept it. For this we will use “Data Validation” functionality in excel. “Data Validation” can be found in “Data” tab under “Data Tools” group. Now let’s see how we can use this “Data Validation” command to restrict cell to accept only decimal values: 1. Select the cells in which we wish to restrict the decimal values. In this case we want to restrict decimal values in cell “B1”. 2. Click on Data Validation command under “Data Tools” group which will appear 03 further options and out of these 03 options again select “Data Validation”. 3. Once we click on “Data Validation” command, one dialog box named as “Data Validation” will appear on screen. 4. Under this dialog box...
Read more

Select all cells highlighted with specific color at a time

By
Image
Many times we apply colors to cells in excel sheet which will help us to identify important cells just by looking at the data. But what if we use multiple colors to highlight data and later on want to select all the cells which are highlighted with specific color only???  YouTube Video: For example, we have listed some values in excel sheet and highlighted few cells with red color and few cells with yellow color. Now, we want to select all cells which are highlighted with only yellow color at a time. But how????  Don't worry... We will provide you a fantastic solution for this!! Follow below steps:  1. Select entire data. 2. Press Ctrl + F. "Find and Replace" window will appear. 3. Click on Options button. 4. "Find and Replace" window will expand with some additional options. Click on Format button. 5. "Find Format" window will appear. Click on Fill tab and select yellow color. You will s...
Read more

Fill Series in Excel: Examples

By
Image
In our previous post " Fill Series in Excel " we have seen all the details about " Fill Series " options. Let us see the examples of each option in this blog post. Fill Series: Linear Trend In this section we will see how we can fill series with linear trend using fill series. Suppose, we want to fill series 1, 2, 3…. upto 20 in a column.  1. Enter value 1 in any cell and select this cell. Go to “Home Tab” then select “Editing Group” then select “Fill Command” then select “Series option” and Input the values as mentioned below in Series Dialog Box:      a. Series in: Column      b. Type: Linear      c. Step Value: 1      d. Stop Value: 20 2. Once you click on “OK” button then you will see a desired series on your screen. Fill Series: Growth Trend In this section we will see how we can fill series with Growth Trend using fill series. Suppose, we want to fill series for which the series pattern will be like: 2, 4, 8…. upto 2...
Read more

Conditional Formatting: Highlighting Entire Row in Excel

By
Image
In this blog post we will learn how to highlight entire row with the help of Conditional Formatting in excel. For this we have prepared a dummy data of 04 team members working on different tasks. We have also provided status for each task whether it is “Open” or “Closed”. We will now learn how we can highlight the entire row based on the provided status. We will highlight the entire row in green color if the status is “Closed”. Let’s follow the below steps and you will be able to highlight the entire row based on our specific criteria. 1. Select all the cells in which we wish to highlight the entire row based on specific criteria. Please Note: While selecting the cells we must exclude the header row. 2. Now, we have to click on the “Conditional Formatting” option which we can find in Styles Group under Home Tab as shown in below image. 3. Once we click on the “Conditional Formatting” option, we can see the further options will appear on our screen. We have to Click on “New Rule” ...
Read more

Inserting Image into Shapes in Excel

By
Image
We have already learned about Inserting Shapes as well as Inserting Images in excel. Now, in this blog post we will learn about inserting images in shapes in excel. We will learn to insert an image (which is logo of our website “ Excel Tricks with Tejraj ”) into various shapes. First we will insert the shape in excel and then we will insert the logo into inserted shape. Insert Image in Oval Shape: First, click on “Insert” tab and then click on “Shapes” command. Once we click on “Shapes” command, we can see various shapes available in excel. Out of these, you can select any shape as per your choice. In this case, we want to select the “Oval” shape. If you are not aware about the names of these shapes, then you can just place the mouse cursor on any shape which will automatically show the name of that shape. Once we click on the “Oval” shape, the shape of mouse cursor will change from doctor symbol to plus symbol. As soon as the mouse cursor symbol changes to plus symbol, we can draw ...
Read more

How to Remove Duplicate Entries from Multiple Columns in Excel

By
Image
In our last blog post, we have learned to remove duplicates entries in excel . In this blog post, we will go little advanced to remove the duplicate entries from multiple columns. Removing Duplicates Entries from 02 Columns: We will learn to remove duplicate entries from the data as shown in below image. The entries which are duplicate in both the “Fruits” column and “Price/Kg” column are highlighted with different colors. To remove duplicate entries in these 02 columns, follow the steps provided below: 1. Select the data from which we want to remove the duplicates. 2. Go to “Data” tab and under “Data Tools” we can find command named as “Remove Duplicates” as highlighted in below image. 3. Once we click on “Remove Duplicate” command, one dialog box with same name “Remove Duplicate” will appear on our excel screen. 4. If we check the checkbox for “My Data has headers” then the header row from our selection will be excluded automatically and under “Columns” section we will see the name o...
Read more

Adjusting Row Height & Column Width in Excel

By
Image
In this blog post we will see how we can adjust Row Height and Column Width of cells in excel sheet. The options to adjust Row Height and Column Width in excel are available in Home Tab under cells group. Once we go to Cells group, click on “Format” command and then under Cell Size we can find all the options to adjust Row Height and Column Width. Let’s learn more about this with real time example. We have a dummy data of marks obtained by five students with us. But the data is not well organized. The Row Height and Column Width of cells which contain this dummy data is not equal which giving an ugly look to our data. So let’s adjust Row Height and Column Width for these cells so that our data will look more attractive. Row Height: Select all the cells for which we want to adjust Row Height. Select "Row Height" option under “Format” command as shown in below image. Row Height dialog box will appear on screen. Here we can enter the value to adjust Row Height. We have provided ...
Read more

Data Bars in Conditional Formatting

By
Image
In continuation to series of posts on Conditional Formatting, we will learn how to use Data Bars in Conditional Formatting through this post. Conditional Formatting command can be found in Styles group under Home tab as shown in below image. Click on the Conditional Formatting option and select “Data Bars” option from the list of appeared options. We can now see all the “Data Bar” options available in excel. These “Data Bar” options are categorized into two groups.  1. Solid Fill 2. Gradient Fill: There are six different “Data Bar” colors available in each group. These colors are listed below: 1. Blue Data Bar 2. Green Data Bar 3. Red Data Bar 4. Orange Data Bar 5. Light Blue Data Bar 6. Purple Data Bar Each group with their respective colors are shown in below image: Solid Fill: Gradient Fill: Now we will see how we can apply these “Data Bars” on our data. For this we have created dummy data of few employees and Incentive received by them. Example with Gradient Fill: 1. Select all...
Read more

Fill Series in Excel

By
Image
In our previous post “ Fill Up, Down, Right & Left in Excel ”, we have seen fill up, fill down, fill right and fill left commands in excel. Now, in this post we will see “Fill Series” command in excel. The basic difference between “ fill up, fill down, fill right and fill left commands ” and “Fill Series” command in excel is that: “fill up, fill down, fill right and fill left commands” fills the data as it is. It is similar to copy the data from one cell to selected cells. But “Fill Series” command help us to fill the data in series. It means it helps us to fill the data in certain pattern. Also we can customize the series in which we want to fill the data with the help of options available in this command. Select “Home Tab” then select “Editing Group” then select “Fill Command” (Image is given below for your reference) Once we click on “Fill” command, various fill options will display on our screen. Select “Series” option from it. Once we click on “Series” option then we will ge...
Read more