Microsoft Excel | MCQs

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

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.