Computer Software Operations

CTRL + 0 is the Excel keyboard shortcut to hide selected columns. This shortcut immediately hides the column(s) containing the active cell or selection. The shortcut is specific to column hiding, not row hiding.

CTRL + 9 is the Excel keyboard shortcut to hide selected rows. This works similarly to CTRL + 0 for columns, but applies to horizontal rows instead. The numeric keypad 9 (or regular 9) serves as the row-hiding counterpart.

CTRL + 1 opens the Format Cells dialog box in Excel, providing access to all formatting options (number formats, alignment, fonts, borders, fills, protection). This is the primary shortcut for accessing cell formatting features.

CTRL + SHIFT + # applies the default date format (dd-mmm-yy or similar) showing day, month, and year. The pound/number symbol key is used for date formatting. This is a quick way to apply standard date formatting to selected cells.

CTRL + SHIFT + % applies percentage format with no decimal places in Excel. This is a built-in keyboard shortcut for quick percentage formatting. The other options either don't exist or perform different functions.

In Excel, the keyboard shortcut CTRL + SHIFT + ) unhides columns that have been hidden. This shortcut works on the selected columns, making them visible again. The corresponding shortcut for unhiding rows is CTRL + SHIFT + (.

In Excel, the keyboard shortcut CTRL + SHIFT + ( unhides rows that have been hidden. This shortcut works on the selected rows, making them visible again. The corresponding shortcut for unhiding columns is CTRL + SHIFT + ).

In Excel, the keyboard shortcut CTRL + SHIFT + & applies an outline border around the selected cells. This adds a border to the outer edge of the cell range. The shortcut to remove borders is CTRL + SHIFT + _.

In Excel, the keyboard shortcut CTRL + SHIFT + _ removes the outline border from the selected cells. This removes borders from the outer edge of the cell range. The shortcut to add borders is CTRL + SHIFT + &.

In Excel, the keyboard shortcut SHIFT + F11 inserts a new worksheet into the current workbook. This creates a blank sheet at the end of the existing sheets. The shortcut CTRL + N creates an entirely new workbook file, not a worksheet.

The transaction code SMARTFORMS is used in SAP to design and maintain Smart Forms. SE71 is the transaction code for SAPscript form design, SO10 is for standard texts, and SE72 is for SAPscript styles, making them incorrect distractors.

The SPLIT string function was NOT available in SQL Server 2005. It was introduced in SQL Server 2016. Earlier versions required workarounds using CHARINDEX, SUBSTRING, XML methods, or custom user-defined functions to split strings.

Alt + Enter is the standard keyboard shortcut in Windows Explorer to open the Properties dialog for the selected folder or file. This shows detailed information including attributes, size, creation date, and more.

Alt + Spacebar is a Windows keyboard shortcut that opens the window control menu (system menu) for the active window. This menu contains options like Restore, Move, Size, Minimize, Maximize, and Close.

Holding the Shift key during Windows boot (specifically after the BIOS screen but before Windows logo) will trigger Safe Mode or the Advanced Boot Options menu. Safe Mode loads Windows with minimal drivers and services for troubleshooting.