MS Excel - Transpose Rows And Columns

If you want to flip the rows and columns in a table, follow the steps.

1. Select a table that you want to transpose. 
2. Press Ctrl + C to copy the table.
3. Move the cursor to a cell in a blank part of your worksheet.
4. On the Home tab, click the down arrow below the Paste icon.
5. Click the Transpose. 
6. Output looks like 

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 different entries to produce one continuous entry	=B4&” “&C6
Reference	, (comma)	It combines multiple references into one reference	=SUM(A5,B8:C11,D15)
	: (colon)	Defines the selected range
	space	Evaluates cells that are common in two references	=SUM(A5:A8 A5:D8)
Comparison	>	Greater than	=A5>B5
	<	Less than	=A5<B6
	=	Equates the values and create links between cells	=A5=B7
	>=	Greater than or equal to	=A5>=B5
	<=	Less than or equal to	=A5<=B6
	<>	Not equal to	=A5<>B7

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 of times to repeat text.

Example:

Points to remember:

• Use REPT to fill a cell with a number of instances of a text string.
• If you want to repeat a text value or any characters in it, you can apply the REPT function to do that.
• It repeats the values as many times as specified in the formula.
• If number_times is 0 (zero), REPT returns “” (empty text).
• If number_times is not an integer, it is truncated.
• The result of the REPT function cannot be longer than 32,767 characters, or REPT returns #VALUE!.

Read More

How to import bookmarks from firefox to chrome

When you want import bookmarks from firefox to chrome, try the following steps,

1. Close Mozilla Firefox browsers.
2. Open Google Chrome.
3. Click the Chrome menu   on the browser toolbar.
4. Select Bookmarks.
5. Click Import bookmark and settings.
6. In the “Import bookmarks and settings” dialog that appears, select the application that contains the settings you’d like to import.
7. Click Import.

Note:

• If you already have bookmarks in Google Chrome, the imported bookmarks appear in the “Other bookmarks” folder at the end of the bookmarks bar.

Read More