Computer Software Operations

The CUT DISPLAY command in TSO/ISPF allows you to view and edit the clipboard contents after using the CUT command. This is the standard mainframe command for clipboard access.

In mainframe environments (particularly CICS or similar transaction processing systems), Shift + Esc is commonly used to navigate from one application to another. This key combination allows users to switch between different active applications or screens within the mainframe session. Navigation shortcuts can vary by specific mainframe interface and installation, but Shift + Esc is a standard key binding for application switching in many mainframe environments.

In mainframe environments, Shift + Esc is the standard key combination to navigate from one application to another. This is a system-level navigation command that allows switching between different active applications or screens.

The AutoSum button (Σ symbol) on the Excel standard toolbar provides quick access to common functions: Sum, Average, Count, Min, and Max. When clicked, it automatically suggests the most appropriate function (usually Sum) based on the selected data. The other options (Insert, AutoFill, Paste) are different toolbar buttons with unrelated functions.

CTRL+; (semicolon) is the Excel keyboard shortcut to insert the current date into a cell. CTRL+SHIFT+: (colon) inserts the current time instead. These shortcuts allow rapid date/time entry without typing.

Shift+F2 is the keyboard shortcut to edit comments in Excel spreadsheet applications. This allows users to quickly add or modify cell comments without using the mouse. The other key combinations listed are not the standard shortcuts for this function.

Alt+Down Arrow opens a drop-down list in Excel, allowing users to select from available options for that cell. This shortcut is particularly useful for data validation lists and autocomplete suggestions. The other combinations are not the standard shortcut for this action.

Ctrl++ (Control plus) is the keyboard shortcut to insert a new cell in Excel, shifting existing cells to make space. This is a common shortcut for inserting cells, rows, or columns. The Shift variants and other combinations listed are not the standard shortcuts for this function.

Shift+F11 is the keyboard shortcut to insert a new worksheet in Excel. This quickly adds a blank sheet to the workbook without navigating through menus or the ribbon interface. Options A and C use different function keys for unrelated tasks, and F19 is not a standard function key.

Ctrl+K is the universal keyboard shortcut for inserting hyperlinks across Microsoft Office applications including Excel. This shortcut opens the Insert Hyperlink dialog box to create links to web pages, files, or other locations. Options A, B, and C are shortcuts for other functions (replace, display formatting, and field calculation).

Trace Precedents is an Excel auditing tool that draws arrows from precedent cells to the selected cell. The keyboard shortcut is Ctrl+[ (Control+[), which selects all direct precedent cells. Options A, B, and D are incorrect - they do not correspond to Trace Precedents.

Ctrl+1 is the standard Excel shortcut to open the Format Cells dialog. This shortcut provides quick access to all cell formatting options.

In Excel, Ctrl+Shift+` (backtick/grave accent) applies the General number format to selected cells. This format displays numbers without specific formatting like decimal places or currency symbols. The shortcut uses the key to the left of the number 1 on standard keyboards.

Ctrl+Shift+4 applies the Currency format with two decimal places in Excel. This shortcut adds the currency symbol and ensures exactly two decimal places are displayed. The choice makes sense because the $ symbol appears on the same key as the number 4.

Ctrl+Shift+- (minus sign) removes all borders from selected cells in Excel. This is a quick way to clear cell borders without accessing the format menu. Note that Ctrl+Shift+7 does the opposite - it applies an outline border.