To find the cube root of a number in Excel, you need to use a formula like this: =<first cell with number>^(1/3). Let’s say the number if given in the A1 cell.

The easiest way to guarantee you select enough cells is to select the number of cells equal to the range difference. In the example, subtracting 8951 from 11859 results in a range of 2,908 numbers.

How to subtract in Excel using cell references You don't have to subtract numbers in a single cell; you can also set up a formula that will subtract the values stored in multiple cells.

Whether you prefer Excel, Numbers, or Google Docs, here's what you, the savvy spreadsheet user, should know how to do.

To find the square root of a number in Excel, we use ‘ (1/2)’ as the exponent. So, if we have the number in cell ‘B2’ then, B2^ (1/2) gives square root of a number available in cell B2.

Excel's MOD function doesn't have to be used to return a value—it can also be used to determine which cells should be formatted through conditional formatting.