Microsoft Excel | MCQs

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.