Computer Knowledge
Computer Software Operations
1,772 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
-
Goto
-
Find
-
Find and Replace
-
Hide rows
D
Correct answer
Explanation
Ctrl + 9 in Excel hides the selected rows. This keyboard shortcut allows users to quickly conceal row data from view without deleting it. The rows remain in the worksheet but are not visible until unhidden.
-
Insert Hyperlink
-
Bold
-
Unhide rows
-
Underline
C
Correct answer
Explanation
Shift + Ctrl + 9 in Excel unhides any hidden rows in the selected range. This is the reverse operation of Ctrl + 9 and makes previously hidden rows visible again. It's useful for revealing data that was concealed.
-
Italic
-
Insert
-
Find
-
Hide Columns
D
Correct answer
Explanation
Ctrl + 0 in Excel hides the selected columns. Similar to how Ctrl + 9 hides rows, Ctrl + 0 hides columns from view. The columns remain in the worksheet but are not visible until unhidden using the appropriate shortcut.
-
Unhide Columns
-
Next Worksheet
-
Page Up
-
Page down
A
Correct answer
Explanation
In Excel, Ctrl+0 hides the selected columns, while Ctrl+Shift+0 unhides any hidden columns in the selected range. This keyboard shortcut is the standard method for revealing column data that has been hidden from view.
B
Correct answer
Explanation
Ctrl+Insert is a legacy keyboard shortcut that performs the Copy operation, equivalent to the more commonly used Ctrl+C. This shortcut originated from early IBM PC standards and continues to work in most modern Windows applications for copying selected content to the clipboard.
-
ALT+SHIFT
-
CTRL+SHIFT
-
ALT+ENTER
-
CTRL+ENTER
C
Correct answer
Explanation
ALT+ENTER is the standard keyboard shortcut to open the Properties dialog for a selected file or folder in Windows Explorer. ALT+SHIFT and CTRL+SHIFT are used for various other functions but not properties. CTRL+ENTER is typically used for 'Open' or in browsers for auto-complete URLs. This is a fundamental Windows keyboard shortcut.
A
Correct answer
Explanation
CTRL+Z is the universal keyboard shortcut for Undo across Windows and most applications. It reverses the last action. Other options are different operations: CTRL+C is Copy, CTRL+X is Cut (for Move), and DELETE is for deletion. Undo is one of the most fundamental shortcuts that every computer user must know for correcting mistakes.
-
CTRL + PAGEUP
-
CTRL + ALT + PAGEDOWN
-
CTRL+ALT+PAGEUP
-
CTRL+ PAGEDOWN
A
Correct answer
Explanation
In Excel, Ctrl + Page Up is the keyboard shortcut to navigate to the previous sheet in the workbook, while Ctrl + Page Down goes to the next sheet. Options with Alt key combinations are incorrect, and the basic Ctrl + PageDown would move forward, not backward.
-
Left Click
-
Right Click
-
Drag
-
Drop
B
Correct answer
Explanation
Right-clicking on an object opens a context menu that includes Properties as an option, allowing users to view and modify object attributes. Left-click selects, drag moves, and drop places objects.
-
End
-
Start
-
Turnoff
-
Restart
B
Correct answer
Explanation
The Help Menu in Windows is accessed through the Start button, which opens the main menu containing Help and Support options. End, Turnoff, and Restart are not standard Windows buttons for accessing help.
-
Text would be copied from the document and placed in the clipboard
-
Text would be removed from the document and placed in the clipboard
-
Text from the clipboard would be placed in the document at the place where the cursor is blinking
-
All of These
A
Correct answer
Explanation
The Copy command duplicates selected text and places it in the clipboard without removing it from the original document. Cut removes text, Paste places clipboard content, and 'All of These' would be incorrect since only Copy is described.
B
Correct answer
Explanation
In Windows and most GUI systems, Ctrl+V is the standard keyboard shortcut for Paste. After copying or cutting content (with Ctrl+C or Ctrl+X), Paste inserts it at the cursor location. This convention is consistent across almost all applications.
A
Correct answer
Explanation
In Windows and most GUI systems, Ctrl+C is the universal keyboard shortcut for Copy. It duplicates selected content to the clipboard, leaving the original in place. This works consistently across text, files, images, and other selectable content in most applications.
D
Correct answer
Explanation
Ctrl+Z is the standard shortcut for Undo in Windows and most applications. It reverses the last action, whether it was typing, formatting, deleting, or another operation. Multiple presses can undo multiple actions, depending on the application's undo history.
C
Correct answer
Explanation
Ctrl+X is the keyboard shortcut for Cut in Windows environments. Cut removes the selected content from its current location and places it on the clipboard, ready to be pasted elsewhere. Unlike Copy (which leaves the original), Cut removes the source after copying.