Test: Excel Tips- 1 - Class 6 MCQ

The default value for any series is 1 in Excel.

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.

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

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+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.

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

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

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.

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

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

The Delete key of keyboard is assigned to Clear Contents command in Excel. Clear Contents will clear only the data, will not clear any formats.

Right-click the tab and choose Delete from its shortcut menu in All version of excel.
In Microsoft Excel 2010 onwards Choose Home > Delete > Delete Sheet on the Ribbon, press Alt+HDS
Microsoft Excel 2007 and earlier Press ‘ALT’ + ‘E’, then the ‘L’ key.

In Excel we can Find and Replace within the sheet or workbook.

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

To removes a sheet from workbook select the sheet, then choose Edit > Delete Sheet these options available in excel 2003 and earlier version.
In Microsoft Excel 2007 onward Choose Home > Delete > Delete Sheet on the Ribbon.

Ctrl + H shortcut key is usedto replace a data with another in sheet.

View > Window > Split option can be used to split windows into two.

From Edit menu choose Move or Copy then select (new book) from To Book list and click OK

Comments can be added to cells using Review > Comment.