Computer Software Operations

CTRL+SHIFT+" copies the VALUE only (not formula) from the cell above into the active cell. This is different from CTRL+' which copies the formula. The quotation mark distinction helps: SHIFT+' = " for values, ' alone for formulas.

CTRL+' copies the FORMULA (not just value) from the cell above into the active cell. This preserves relative references that adjust to the new position. Contrast with CTRL+SHIFT+" which copies only the static value.

SHIFT+F2 edits the comment in the active cell (or creates one if none exists). F2 alone edits the cell contents, while SHIFT+F2 specifically targets the comment. This is consistent across Excel versions.

CTRL+DELETE deletes all characters from the cursor position to the end of the line in Excel's edit mode. This is a standard text editing shortcut that works in Excel cell editing, Word, and many other applications. SHIFT+DELETE is usually cut, not delete to end.

ALT+' (apostrophe) opens the Style dialog box in Excel, where you can apply, create, or modify cell styles. The apostrophe key is used because it's related to formatting and styles. This is different from the Format Cells dialog (CTRL+1).

In Excel, pressing CTRL+1 is the keyboard shortcut to open the Format Cells dialog box, which allows you to format the appearance of cells including fonts, borders, number formats, and alignment. The other options (CTRL+2, CTRL+3, CTRL+4) do not perform this function.

In Excel, CTRL+SHIFT+# applies the Date format showing day, month, and year (e.g., dd-mm-yyyy or similar depending on regional settings). This is the standard shortcut for date formatting. The other options are for different formats: CTRL+SHIFT+@ is time, CTRL+SHIFT+$ is currency, CTRL+SHIFT+! is number format with two decimals.

CTRL-C sends the SIGINT (interrupt) signal, which is the universal standard for terminating or interrupting running programs in Unix-like systems and terminal emulators. CTRL-E typically moves to end of line, CTRL-D indicates EOF, and CTRL-I is a horizontal tab.

In vi editor, S substitutes the entire line - it deletes the line and enters insert mode. C substitutes from cursor to end of line, A appends text after the cursor, and O opens a new line above the current one.

In vi, ) moves the cursor to the beginning of the next sentence, and ( moves to the beginning of the previous sentence. The { and } keys move by paragraphs, not sentences, so they are incorrect for sentence navigation.

The Focus() method is used to set input focus to a specific TextBox control when the page loads, making it active and ready for user input. AutoPostBack causes form submission, Submit submits the entire form, and Selected is a property for list-type controls.

ALT+N is the standard keyboard shortcut in Quality Center/ALM to create a new defect. This shortcut opens the defect form with blank fields for entering defect details. CTRL+N is typically used for new folders or test cases, while SHIFT+N and CTRL+SHIFT+N are not standard defect creation shortcuts in QC.

ALT+N is the keyboard shortcut in Quality Center/ALM for creating a new defect. This opens the defect entry form where users can fill in defect details like severity, description, and steps to reproduce. The other key combinations serve different purposes or are not standard shortcuts.

Alt+F11 is the universal shortcut to open the Visual Basic Editor across Microsoft Office applications including Word. Option A correctly describes this shortcut (Function 11 = F11). The other options use incorrect key combinations.