Ms Excel — Part 1 MCQs with Explanations

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.

To join some cells and place the content at the middle of the joined cell in MS Excel, you need to use the "Merge and Center" feature. This can be done by selecting the cells you want to merge, then going to the Format Cells dialog box. Within this dialog box, you'll find the option to Merge and Center . By choosing this option, the selected cells will be merged into one and the content will be placed at the middle of the merged cell. This ensures a visually appealing layout for your data.

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.

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.

Data sheet can not be a sheet in workbook.

A cell can be edited through Press the F2 key or Click the formula bar or Double click the cell.

You can merge the main document with data source in Excel. In mail merge operation, Word is usually Client

Manual calculation mode means that Excel will only recalculate all open workbooks when we request it by pressing F9. It allows to choose whether we want to update formulas in worksheets or entire workbook.

Use a Custom list to sort or fill in a user-defined order. Excel provides day-of-the-week and month-of-the year built-in lists, but we can also create your own custom list. For Excel 2010 and later , click File > Options > Advanced > General > Edit Custom Lists. For Excel 2007 , click the Microsoft Office Button Office button > Excel Options > Popular >Top options for working with Excel > Edit Custom Lists.

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.

In Excel 2016, 2013, 2010, 2007, click on View > Show > Gridlines For Excel 2003 and Earlier: Navigate to Tools > Options or Click Gridline tool on Forms toolbar.

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.

The default value for any series is 1 in Excel.

Transpose (rotate) data from rows to columns or vice versa. To use options from the Paste Special box, click Home > Paste > Paste Special > Transpose Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK

Ctrl+D fills the cell beneath with the contents of the selected cell in a column. To fill more than one cell, select the source cell and press Ctrl+Shift+Down to select all cells. Then press Ctrl+D to fill them with the contents of the original cell.

Ctrl+R fills the row cell to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Right arrow to select multiple cells. Then press Ctrl+R to fill them with the contents of the original cell.

Click the Fill button in the Editing group, and then click Across Worksheet a command only appears when we have multiple worksheets selected.

Time series type is not valid for Fill Series dialog box in excel.

We can paste formula, value, formats, comments, validation using Paste Special command.

Paste Special allows Divide operation while you paste to new cell.

Deletes selected cells through Edit > Delete command was available in Excel 2003 and earlier versions.

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.