Computer Software Operations

In spreadsheet applications like Microsoft Excel or Google Sheets, formulas must begin with an equals sign, followed by the cell references and operators, making '=A1 + A2' the correct syntax.

Switching between portrait and landscape orientation is done through the Page Setup dialog box. This is not handled by the header/footer toolbar or by simply switching views - you need to access Page Setup to change the orientation setting.

The Drawing toolbar (or Drawing tools in ribbon versions) contains the Order commands (Bring to Front, Send to Back, etc.) that control the layering and stacking order of objects like AutoShapes, pictures, and other graphical elements. The formatting and picture toolbars don't handle object layering.

The keyboard shortcut CTRL+Enter forces a page break at the insertion point in Word, starting content on the next page. CTRL+ALT and CTRL+Break are not standard page break commands.

F7 is the universal keyboard shortcut for spell check across Microsoft Office applications. It opens the spelling and grammar dialog box to review text errors.

Ctrl + P opens the print dialog in virtually all Windows applications, including PowerPoint. Ctrl + S saves the file, while Ctrl + T and Ctrl + E have different functions.

The Escape key is the standard method to exit slide show mode in PowerPoint and return to the normal editing view. Arrow keys navigate within the presentation but don't stop it.

The Slide Show icon (or pressing F5) starts the presentation from the beginning or from the current slide. 'Go' is not a PowerPoint command, and transitions are effects that play during the show, not something you enable to start it.

F5 is the standard keyboard shortcut in PowerPoint to begin a slide show from the current slide. F1 typically opens help, while F2 is used for editing text in cells. F10 activates menu ribbon shortcuts.

Ctrl+Shift+V is the standard keyboard shortcut for opening the Paste Special dialog in applications like LibreOffice Calc and Microsoft Excel. This feature allows you to paste content with specific formatting options, such as values only, formulas, or formatting. The other options (Ctrl+Shift+$, Ctrl+Shift+9, Ctrl+0) perform different functions related to formatting and navigation.

Ctrl+Shift+J is the keyboard shortcut in LibreOffice Writer and Calc that toggles between fullscreen and normal view. This is useful when you want to focus on your content without interface distractions. The function keys like F10 and F12 are typically used for menu activation and other functions, not fullscreen toggling.

Ctrl+Q is the universal keyboard shortcut for quitting or exiting an application across many programs and operating systems. This command closes the application completely. Options like Ctrl+Shift+2, Ctrl+Shift+3, and Ctrl+0 perform various other functions but are not standard exit commands.