MS Excel - Transpose Rows And Columns

If you want to flip the rows and columns in a table, follow the steps. Select a table that you want to transpose.  Press Ctrl + C to copy the table. Move the cursor to a cell in a blank part of your worksheet. On the Home tab, click the down arrow below the Paste icon. Click...

Read More

MS Excel : Excel Operators along with their Function and Examples

Excel Operators along with their Function and Examples Type Operator Description Example Arithmetic + Adds the values =A2+B2+D2  -  Performs subtraction  = A2 – B2  /  Performs Division  =A5/D7  *  Multiplies the values  =B5*D8 % Divides the value by 100 =D9%  ^  Exponentiation  =B5^5  Single Text  &  Connects...

Read More

MS Excel : Order of Operator Precedence in Excel

Order of Operator Precedence in Excel Operator Description Precedence - Negation 1 % Percentage 2 ^ Exponentiation 3 * and / Multiplication and Division 4 + and - Addition and Subtraction 5 & Ampersand/ Concatenation operator 6 =, <, >, <=, >=, <> Comparison Operators 7 ...

Read More

MS Excel – Formula : Repeat Characters

Description: Repeats text a given number of times. Syntex: = REPT(text, number_times) The REPT function syntax has the following arguments: Text    Required. The text you want to repeat. Number_times    Required. A positive number specifying the number...

Read More

How to import bookmarks from firefox to chrome

When you want import bookmarks from firefox to chrome, try the following steps, Close Mozilla Firefox browsers. Open Google Chrome. Click the Chrome menu   on the browser toolbar. Select Bookmarks. Click Import bookmark and settings. In the “Import bookmarks and settings” dialog that appears, select...

Read More