Microsoft Excel mcq questions With Answer | MS Excel || Computer Fundamental

Show Formula bar option by clicking the File (or Office button) > Options > Advanced > Display > Show Formula bar.
In earlier versions of Excel, you could hide the status bar if you wanted more space available for your worksheets. However, that capability was removed starting with Excel 2007.
In earlier versions of Excel, you could hide the tool bar as per requirement. However, that capability was removed starting with Excel 2007 and introduced Ribbon.

When we pressing the ctrl+x in the Microsoft excel sheet it means we cut the content from that cell simply means the cells selected are marked for cutting and the user has need to move the content from one cell to another cell.

To use options from the Paste Special box, click Home > Paste > Paste Special.

Transpose (rotate) data from rows to columns or vice versa. To use options from the Paste Special box, click Home > Paste > Paste Special > Transpose

When there is no data in in the adjacent cells, long text flows into adjacent cells on a worksheet. As soon as data is entered into in the adjacent cells, text will be visible upto cell length in which data is entered, For full visibility of data either we need to increase the length of cell or wrap text in particular cell.

Doctor’s symbol (Big Plus) indicates we that we can make selection to cell.

Small thin plus icon cell pointer indicates that you can fill series.

Mouse Pointer with anchor at the tip cell pointer indicate that you can move the content to other cell.

You can auto fit the width of column by double clicking on column right border on column header.

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.
On the Home tab, in the Alignment group, click Wrap Text.