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.

Explanation

Ctrl + H shortcut key is used to replace a data with another in sheet.

Explanation

Deletes selected cells through Edit > Delete command was available in Excel 2003 and earlier versions.

Explanation

To remove the content of selected cells we must issue Clear Contents command.

Clear Contents will clear only the data, will not clear any formats.

Explanation

Click the Fill button in the Editing group, and then click Across Worksheet a command only appears when we have multiple worksheets selected.

Explanation

Microsoft Excel can wrap text so it appears on multiple lines in a cell.

We can format the cell so the text wraps automatically, or enter a manual line break.

Explanation

The default value for any series is 1 in Excel.

Explanation

When you press F9 or click Calc Sheet on the Calculation tab on the Tools/Options menu.

Calculation also occurs every time that you save the file if you have the checkbox "Recalculate workbook before saving" checked under File > Options > Formulas.