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
-
Function 5
-
Function 6
-
Function 7
-
Function 8
A
Correct answer
Explanation
F5 is the standard shortcut key to run a macro in Microsoft Office applications when the macro is selected or in the VBA editor. This shortcut executes the currently selected macro or the macro code where the cursor is positioned.
-
Ctrl + Break
-
Shift + Break
-
Alt + Break
-
Break
A
Correct answer
Explanation
In Microsoft Excel or VBA development environments, the standard shortcut key to interrupt or stop execution of a running macro is Ctrl + Break. The other combinations do not trigger the macro execution halt.
-
Home
-
View
-
Developer
-
Tester
C
Correct answer
Explanation
Macro development tools including the Visual Basic Editor, Macros dialog, and recording features are located in the Developer tab in Microsoft Office applications. This tab must be enabled through Office Options as it's hidden by default.
-
Office Button -> excel options -> Trust Center -> Macro Enable/Disable
-
Office Button -> excel options -> Trust Center -> Macro Security
-
Office Button -> excel options -> Trust Center -> Privacy Options
-
Office Button -> excel options -> Trust Center -> Macro Settings
D
Correct answer
Explanation
Macro security settings are accessed through Office Button > Excel Options > Trust Center > Macro Settings. This is where users configure how macros are handled - enable all, disable with notifications, or disable completely. Option D shows the correct navigation path.
-
Ellipses
-
Quotation marks
-
Ampersand
-
Asterisk
C
Correct answer
Explanation
In SQL*Plus and Oracle SQL Developer, the ampersand character (&) is the default prefix used to denote substitution variables. When the SQL parser encounters an ampersand, it prompts the user for a value, making this the correct option while other symbols are incorrect.
-
Menu and Line
-
Line and Data
-
Primary and Line
-
Primary and Secondary
C
Correct answer
Explanation
In ISPF (Interactive System Productivity Facility), EDIT commands are categorized into Primary commands and Line commands. Primary commands are entered on the command line and operate on the entire dataset (like CHANGE, FIND), while Line commands are entered in the line number area and operate on specific lines (like C, D, M for copy, delete, move). This distinction is fundamental to ISPF edit operations.
-
Menu and Line
-
Line and Data
-
Primary and Line
-
Primary and Secondary
C
Correct answer
Explanation
ISPF Edit commands are categorized into primary commands, which are entered on the Command/Option line at the top, and line commands, which are entered directly in the line command area on the left side of the data. Other options do not correctly name these two edit command types.
-
Terminate the program currently running.
-
Terminate ISPF to return to the TSO READY prompt.
-
Pause a program so that data will not continue to scroll.
-
Clear the screen to allow the next screen of data to display.
A
Correct answer
Explanation
PA1 interrupts the currently executing program or command, returning control to the system prompt. It doesn't exit ISPF itself - that's PA3 or the END command. PA2 is for attention requests, not program termination.
A
Correct answer
Explanation
The PAUSE command in SQL*Plus controls output pagination. When enabled (SET PAUSE ON), output pauses after each page and waits for the user to press Enter before continuing. This is useful for viewing large query results that span multiple pages.
-
CTRL+L
-
CTRL+SHIFT+K
-
CTRL+SHIFT+L
-
Windowslogo+L
D
Correct answer
Explanation
Windows logo key + L (Windowslogo+L) is the standard Windows shortcut to lock the computer (locks the entire workstation, not just the keyboard). This is a security feature that requires password to regain access. While the question says 'lock keyboard,' the standard answer refers to this workstation lock function.
-
Windowslogo+F
-
Windowslogo+E
-
CTRL+E
-
CTRL+SHIFT+E
B
Correct answer
Explanation
Windows logo key + E (Windowslogo+E) opens File Explorer (formerly My Computer) in Windows. This is a universal shortcut that has been consistent across Windows versions. CTRL+E is typically used for search in browsers, while Windowslogo+F opens the search dialog specifically.
C
Correct answer
Explanation
F1 is the universal help key across Windows and most applications. Pressing F1 opens context-sensitive help or the application's help documentation. F2 is commonly used for renaming, F3 for search, and F5 for refresh in most applications.
-
Ctrl +
-
Ctrl -
-
Shift +
-
Shirt -
B
Correct answer
Explanation
In Excel, Ctrl+- (Ctrl minus) is the keyboard shortcut to delete the selected row(s) or cells. The Ctrl+ key typically opens insert dialog, while Shift combinations are used for selection, not deletion.
-
Ctrl + Q
-
Ctrl + N
-
Ctrl + D
-
Ctrl + U
D
Correct answer
Explanation
In Microsoft Outlook, Ctrl+U marks selected email messages as unread. Ctrl+Q is for marking as read, Ctrl+N creates new messages, and Ctrl+D deletes items. The U key was chosen to match 'Unread'.
-
Alt + A
-
Alt + B
-
Alt + C
-
Alt + D
D
Correct answer
Explanation
Alt + D is the keyboard shortcut to move focus to the Address bar in Internet Explorer. This shortcut works across multiple versions of Internet Explorer and is commonly used to quickly type or paste a URL without clicking.