Computer Software Operations

In Excel, Ctrl + - (minus) opens the Delete dialog box, which allows deleting either entire rows or entire columns. The user then chooses what to delete via the dialog. The keyboard shortcut itself doesn't distinguish between row and column - it presents both options.

In Excel, Ctrl + + (plus) opens the Insert dialog, which provides options to insert entire rows or entire columns. The user selects which to insert via the dialog. The keyboard shortcut itself doesn't target just one - it presents both insert options.

Ctrl + N in Excel creates a new workbook (a new Excel file), not a new worksheet within the current workbook. To insert a new worksheet within the current workbook, you would use Shift + F11 or right-click the sheet tab and select Insert. Ctrl+N always creates a fresh, blank workbook file.

In Excel, Alt + ' (apostrophe) opens the Format Cells dialog directly to the Style tab. This shortcut allows quick access to cell styles. The Style tab lets you apply, create, or modify cell styles for consistent formatting across your workbook.

Ctrl + i applies italic formatting in Excel, while Ctrl + 3 applies a specific style format (typically the 'Comma' style in older versions or another predefined style). These are two entirely different keyboard shortcuts with different functions - one is direct formatting (italic), the other applies a style. They are not equivalent.

The .docx extension is the default file format for Microsoft Word 2007 and later versions. This XML-based format replaced the older .doc binary format, offering better compatibility, smaller file sizes, and improved data recovery capabilities.

The .ppt extension is the traditional file format for Microsoft PowerPoint presentations (versions 97-2003). This binary format was replaced by .pptx in Office 2007, but .ppt remains a recognizable extension for PowerPoint files. Note: Option C has a slight typo with .ppt instead of just .ppt, but it's clearly intended to be the correct answer.

F11 is the keyboard shortcut in Excel that creates a default chart on a new sheet using the selected data. Pressing F11 instantly generates a chart based on the current data selection, making it a quick way to visualize data.

F12 is the universal keyboard shortcut for the Save As command in Microsoft Office applications (Word, Excel, PowerPoint, etc.). This shortcut opens the Save As dialog box, allowing you to save a file with a new name, location, or file format.

The F4 key in Excel repeats the last action or command you performed. This is useful when you need to apply the same formatting, insertion, or other operation multiple times without redoing all the steps. For example, after inserting a row, pressing F4 will insert another row.

CTRL+C is the standard keyboard shortcut for copying selected text or items in Windows and most operating systems. CTRL+V is for paste, CTRL+X is for cut, and CTRL+CY is not a standard shortcut.

SHIFT+DELETE permanently deletes the selected item without placing it in the Recycle Bin. This is a standard Windows shortcut. CTRL+DELETE is not a delete command, and CTRL+SHIFT+DELETE typically clears browser data.

ALT+ENTER is the standard Windows shortcut to view properties for the selected item (file, folder, etc.). CTRL+P is for print, ALT+P is not a standard shortcut, and SHIFT+P has no default function.

ALT+F4 is the universal Windows shortcut to close the active window or quit the active program. This is one of the most well-known keyboard shortcuts. ALT+F1, ESC+DELETE, and CTRL+TAB are not standard close commands.