Computer Knowledge
Computer Software Operations
1,659 Questions
This hub provides extensive practice on computer software operations and keyboard shortcuts. It covers document formatting, spreadsheet navigation, and common application commands. These questions are essential for candidates preparing for banking, railways, and staff selection computer proficiency tests.
Keyboard shortcutsSpreadsheet formattingDocument editingWeb page navigationMail merge operations
Computer Software Operations Questions
B
Correct answer
Explanation
Among the file operations listed, 'erase' is the odd one out because it is a DOS/Windows command, while 'rename', 'open', and 'delete' are common Unix/Linux commands. The Unix equivalent of 'erase' is 'rm' (remove). This tests knowledge of cross-platform command differences.
B
Correct answer
Explanation
F9 is the shortcut key to access the Requirements menu bar in Quality Center's Requirements module. This is application-specific keyboard mapping (varies by QC version).
-
Unhides columns in the selection
-
Inserts the argument names and parentheses for the function (after you type a valid function name in a formula)
-
Selects direct precedent cells
-
Hides columns
A
Correct answer
Explanation
The Ctrl+Shift+) keyboard shortcut in Excel unhides any hidden columns within the selected range. This is useful when you've hidden columns for presentation purposes and need to reveal them again. The other shortcuts described (Ctrl+A for function arguments, Ctrl+[ for precedents, Ctrl+0 to hide) use different key combinations.
-
Enters the current time
-
Equivalent to Undo
-
Equivalent to Insert ? Links ? Hyperlink
-
Closes the window
A
Correct answer
Explanation
The Ctrl+: (Ctrl+semicolon) keyboard shortcut in Excel enters the current time into the selected cell. This is useful for timestamping data entries. The other options (Ctrl+Z for Undo, Ctrl+K for Hyperlink, Alt+F4 for Close) use different key combinations.
-
Inserts the AutoSum formula
-
Hides rows
-
Minimizes the workbook
-
Activates to the next window
C
Correct answer
Explanation
Ctrl+F9 is a keyboard shortcut in Microsoft Excel that minimizes or restores the current workbook window. Option A describes Alt+= (AutoSum), Option B refers to Ctrl+9 (hide rows), and Option D refers to Ctrl+F6 or Ctrl+Tab (switch to next window).
-
Sets or removes strikethrough
-
Applies the comma format with two decimal places
-
Hides columns
-
Applies border to outline
D
Correct answer
Explanation
Ctrl+Shift+& applies an outside border (outline border) to the selected cells in Excel. Option A refers to Ctrl+5 (strikethrough), Option B is Ctrl+Shift+! (comma format), and Option C is Ctrl+0 (hide columns). The ampersand (&) key shares the 7 key, making this the border shortcut.
-
Repeats the last Find (Find Next)
-
Edits a cell comment
-
Edits the active cell
-
Allows resizing the window with the arrow keys
B
Correct answer
Explanation
Shift+F2 edits or inserts a comment on the active cell in Excel. Option A is Shift+F4 (Find Next), Option C is F2 (edit cell), and Option D refers to maximizing/restoring with arrow keys. The Shift modifier changes F2 from editing cell contents to editing the cell comment.
-
Windows Logo + E
-
Windows Logo + D
-
Windows Logo + M
-
None
B
Correct answer
Explanation
Windows Logo + D is the keyboard shortcut that minimizes all open windows and displays the desktop. Windows Logo + E opens File Explorer, while Windows Logo + M minimizes all windows but doesn't necessarily display the desktop if there are minimized windows.
-
Ctrl + S
-
Windows Logo + D
-
Windows Logo
-
None
C
Correct answer
Explanation
Pressing the Windows Logo key alone opens the Start Menu in Windows. Ctrl + S is the save shortcut, Windows Logo + D shows the desktop, and None is incorrect. This is a fundamental Windows navigation shortcut.
-
Ctrl + R
-
Ctrl + Y
-
Ctrl + Z
-
None
B
Correct answer
Explanation
In Windows and most standard applications, Ctrl + Y is the default keyboard shortcut used to redo the last undone action. Ctrl + Z is used for undo, and Ctrl + R is typically used for refreshing a page or aligning text.
C
Correct answer
Explanation
F2 is the universal keyboard shortcut to rename a selected file or folder in Windows and most file managers. F8 is used for boot menu options (Shift+F8 for advanced boot), and Ctrl+W typically closes windows/tabs.
-
Ctrl + S
-
F3
-
Shift + F8
-
None
B
Correct answer
Explanation
F3 is the keyboard shortcut to open the search/find function in Windows Explorer and most applications. Ctrl + S is for saving, Shift+F8 is rarely used, and the search function is the correct answer for finding files or folders.
-
Ctrl + E
-
right arrow
-
left arrow
-
None
B
Correct answer
Explanation
The right arrow key expands the current selection in Windows Explorer (e.g., expanding a folder to show its contents). Ctrl + E is often used for search, left arrow collapses selections, making right arrow the correct answer for expansion.
B
Correct answer
Explanation
F10 activates the menu bar in most Windows programs, highlighting the first menu item (usually File). F1 opens help, F3 is for search, and F10 is the standard shortcut for menu bar access across Windows applications.
B
Correct answer
Explanation
In HP Quality Center / ALM, pressing the F9 shortcut key allows users to access the Requirements menu bar directly from the Requirements module, facilitating quick keyboard navigation.