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

AutoFormat option in excel is a unique way of formatting data quickly, the first step is we need to select the entire data we need to format and then the second step we need to click on auto-format from the QAT and third step we need to choose the format from the different options.

On the Home tab, in the Font group, click the arrow next to Borders Button, and then click No Border Button.
--OR--
Click Home > the Borders arrow > Erase Border, and then select the cells with the border you want to erase.

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.

There is no option to set page border in Excel.

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.

We can check the conditions against Cell value or Formula when applying conditional formatting.

In Conditional Formatting we cannot set condition to look for Bold and apply Italics on them.

The width of a row and be specified manually or fit automatically is invalid statement.

Formula palette is used to create and edit formula.
It is also possible to type a function directly into a cell, however, as there are over 300 functions built into Microsoft Excel, some of which are quite complex, Excel provides the Formula Palette to simplify the process.

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