Computer Software Operations

In standard editors like vi/vim, the 's' key substitutes the character under the cursor with new text, allowing single-character replacement. 'S' replaces the whole line, 'r' replaces without entering insert mode, and 'C' changes to the end of the line.

In vi editor, the } key moves the cursor forward to the end of the current paragraph. { moves to beginning of paragraph, | moves to specific column, $ moves to end of line.

In vi editor, the 'i' command inserts text to the left of (before) the cursor position. 'a' appends text to the right, 's' substitutes current character, 'S' substitutes entire line.

In vi/vim editors, the % key moves the cursor between matching delimiters - pressing % on a parenthesis, bracket, or brace will jump to its closing or opening counterpart. This is useful for navigating code and structured text.

In Unix shell readline and Emacs-style editing, Esc+B (or Alt+B) moves the cursor backward by one word. Ctrl+A moves to the start of the line, Ctrl+E moves to the end, while Ctrl+B and Ctrl+F move by single characters.

In Microsoft Word and many other applications, the F7 key is the standard shortcut for checking spelling and grammar. This function key launches the spelling and grammar checker tool. F3, F5, and F10 have different functions in various applications (F5 is commonly 'refresh' or 'go to').

In Windows, holding the ALT key and typing 0160 on the numeric keypad generates a non-breaking space (NBSP). This character looks like a space but prevents an automatic line break at its position in text processing.

In Windows Vista, the Alt+Tab key combination does access Windows Aero, displaying the 3D flip view of open windows. This is a correct statement.

Ctrl + Arrow Key is the correct Excel shortcut to jump to the next occupied cell in the direction of the arrow pressed. This works horizontally (left/right arrows), vertically (up/down arrows), and can be used sequentially for diagonal movement. Ctrl+A selects all, Ctrl+V is paste, and Ctrl+Page Up/Down switches between worksheets.

In Microsoft Excel, Ctrl+Page Up moves to the previous worksheet and Ctrl+Page Down moves to the next worksheet in a workbook. This is a standard keyboard shortcut that works consistently across Excel versions. The other options are incorrect - Ctrl+A selects all, Ctrl+V is paste, and Ctrl+Arrow keys move within the current sheet.

In Excel, pressing F4 in the formula bar or cell adds the dollar sign ($) to create absolute references (e.g., A1 becomes $A$1). This locks the cell reference so it doesn't change when copied. F2 is for editing, Ctrl+F4 closes the workbook, and Ctrl+F3 opens the Name Manager.

In Excel, F4 repeats the last action (like a duplicate command), and Ctrl+D copies the content from the cell directly above to fill down. Both are valid keyboard shortcuts for duplicating actions or content. F2 is for editing, and Ctrl+F3 opens the Name Manager.

F7 is the standard keyboard shortcut in Microsoft Word and many word processors to check spelling and grammar. This function reviews the document for errors and suggests corrections, making it an essential tool for document editing.