Explanation

In 2003 and earlier versions - From Format Cells dialog box click on Merge Cells check box

In 2007 and subsequent versions - Merge & Center icon on the Home ribbon.

Explanation

In Excel we can Find and Replace within the sheet or workbook.

Explanation

There is no option to set page border in Excel.

Explanation

Mouse Pointer with anchor at the tip cell pointer indicate that you can move the content to other cell.

Explanation

Small thin plus icon MS Excel solution image cell pointer indicates that you can fill series.

Explanation

An apostrophe before a cell value forces Excel to interpret the value as text.

This is mostly useful for values that look like a number or date.

Explanation

Microsoft Excel is Microsoft's general-purpose spreadsheet program for Windows, used for data analysis and display.

It is commonly used in a business environment since it is part of the Microsoft Office package.

Explanation

To select an entire column in MS-EXCEL, Click the column heading letter or press CTRL + Space Bar key.

Explanation

The term workspace refers to all the open workbooks and their exact screen position and window sizes.

Explanation

An array formula is a formula that can perform multiple calculations on one or more of the items in an array.

We can think of an array as a row of values, a column of values, or a combination of rows and columns of values.

Array formulas can return either multiple results or a single result.