Cell Formatting | MCQs

Explanation

Comments can be added to cells using Insert > Comment.

Right-click the cell and then click Insert Comment (or press Shift+F2).

Explanation

CTRL+SHIFT+ & key are used to apply outline border to the selected cell in MS Excel.

Explanation

 In MS Excel, the 'Wrap Text' feature is used to wrap extra-long text into multiple lines so that you can see all text.

ND5-2-2023

Explanation

The current active cell can be identified as being the one that has a darker black border around it.

Explanation

On the Home tab, in the Alignment group, click Wrap Text.

Notes: Data in the cell wraps to fit the column width, so if you change the column width, data wrapping adjusts automatically.

Explanation

Any process of arranging items systemically

Explanation

When there is no data in in the adjacent cells, long text flows into adjacent cells on a worksheet.

Explanation

If we need to remove only the formatting done in a range, we must use From Edit menu choose Clear and then Formats.

Explanation

To adjust a column width to fit its contents in Excel, you can:

Double-click the boundary to the right of the column heading.

This action automatically resizes the column width to match the longest entry in that column.

This ensuring that all data is visible without manually adjusting the width.

Explanation

The formatting and Drawing toolbar is a toolbar in Microsoft Office 2003 and earlier applications, that gives the user the ability to change the formatting of selected text or cell.