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

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

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.

Explanation

Minimum zooming is 10% and Maximum zooming allowed is 400%.

500% is invalid zoom percentage in Excel

Explanation

The tables' columns are referred to as fields.

Within a record, a field holds a specific piece of data.

columns and rows make up the two-dimensional structure known as a table.

The columns are referred to as fields in more formal computer terminology, while the rows are referred to as records.

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.