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.

Explanation

 main document can merge with data source in Excel.

In mail merge operation, Word is usually Client

Explanation

Name Box refers to an input box directly to the left of the formula bar.

The Name Box normally displays the address of the "active cell" on the worksheet.

You can also use the name box to quickly create a named range.

Explanation

On the bottom left of the worksheet we find the Sheet Tab Scroll Buttons to move to the First sheet, Previous sheet, Next sheet, and Last sheet.

They are followed by the tabs for the worksheets in our workbook and the Insert Worksheet button or tab, depending on the version of Excel we are using.

Explanation

To go to previous cell we use Go To function Ctrl + G.

Explanation

A conditional format changes the appearance of cells on the basis of conditions that you specify.

If the conditions are true, the cell range is formatted; if the conditions are false, the cell range is not formatted.