Computer Software Operations

Ctrl + + (plus sign) inserts a new row in Excel. The plus symbol visually represents adding something, making this shortcut intuitive for insertion operations.

Ctrl + - (minus sign) deletes the selected row in Excel. The minus symbol represents removing or subtracting, making this shortcut easy to remember for deletion operations.

Shift + F2 opens or edits the comment attached to the selected cell in Excel. F2 alone edits the cell content, while adding Shift modifies the action to edit the comment instead.

Ctrl + 9 hides the selected row(s) in Excel. The number 9 is used for hiding rows, while 0 is used for hiding columns. To unhide, use Ctrl + Shift + 9.

'Alt+Control+Delete' refers to the keyboard task manager command. In the context of Tamil films, 'Enthiran' (2010) starring Rajinikanth features Chitti, a robot who can be controlled or deleted. The other options are also Tamil films with 'rajan' endings but 'Enthiran' is the sci-fi film about artificial intelligence.

In Excel, the MAX function returns the largest value in a range of numbers. AVERAGE calculates the mean, COUNT counts cells, and MINIMUM returns the smallest value.

Ctrl+End is the standard keyboard shortcut to jump to the end of a document. The End key alone moves to the end of the current line. Home key goes to line start. Auto Summarize is not a navigation feature.

Backup creates duplicate copies of data to protect against accidental deletion, hardware failure, or corruption. While backups don't directly prevent viruses or confidentiality breaches, they ensure you can restore your data if something goes wrong.

The question claims CTRL + 3 is the shortcut for italics. However, in Microsoft Office applications and most text editors, the standard shortcut for italics is CTRL + I. Different applications may have different shortcuts, and CTRL + 3 might be specific to a particular program version. The other options (CTRL + 1, 2, 6) are not standard formatting shortcuts.

SHIFT + INSERT is a legacy keyboard shortcut for pasting text that dates back to the DOS era and is still supported in Windows applications. The more common modern shortcut is CTRL + V. Options B (CTRL + X) is for cutting, not pasting. Options A and C (SHIFT + DOWN/UP ARROW) are for extending selection, not pasting.

In Microsoft Excel, pressing F11 instantly creates a default chart using the data in the selected range and places it on a separate chart sheet. This is a quick way to visualize data. F12 opens the Save As dialog, F10 activates the menu bar, and F9 recalculates formulas in workbooks set to manual calculation.

In Microsoft Excel, when working with multiple sheets including chart sheets, CTRL + PAGE DOWN moves to the next sheet to the right, while CTRL + PAGE UP moves to the previous sheet to the left. Both shortcuts work for navigating between chart sheets and regular worksheets. Option D (SHIFT + UP ARROW) extends selection within a cell, not between sheets.

The HOME key moves the cursor to the beginning of the current line or field in most applications, including text editors, spreadsheets, and form fields. This is a universal navigation key. The END key moves to the end. CTRL + 2 or CTRL + 3 are not standard navigation shortcuts in common applications.

SHIFT + HOME extends the selection from the current cursor position to the beginning of the line or field. This works in text editors, spreadsheets, and many other applications. SHIFT + END would extend to the end. SHIFT + INSERT is for pasting, and CTRL + 3 is not a standard selection shortcut.

In Microsoft Word and Office applications, CTRL + 2 applies bold formatting to selected text. This is a numbered formatting shortcut where CTRL + 1 is typically normal, CTRL + 2 is bold, and CTRL + 3 is italics. The standard shortcut across most applications is CTRL + B for bold, but numbered shortcuts exist in Office applications.