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.
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.