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
-
Refresh
-
Undo
-
Redo
-
Concatenate
A
Correct answer
Explanation
Pressing F5 refreshes the current view in Windows Explorer and most Windows applications. This reloads the display to show any recent changes or updates. F5 is universally recognized as the refresh key across Windows and web browsers.
-
All the opened documents will be maximized
-
All the opened documents will be minimized
-
All the opened documents will be closed
-
None of the above
B
Correct answer
Explanation
The Windows Key + M shortcut is the standard command to minimize all currently open windows to the taskbar, showing the desktop. Windows Key + D performs a similar function by toggling the desktop view, but M specifically targets minimization.
-
Ctrl + Alt + Delete
-
Ctrl + Shift + Delete
-
Ctrl + Alt + Delete + Enter
-
Alt + Shift +Delete + Enter
C
Correct answer
Explanation
The standard shortcut to lock a Windows computer is Windows Key + L. However, Ctrl + Alt + Delete opens a security screen where 'Lock' is an option. Adding 'Enter' implies selecting the default lock option. The other combinations like Ctrl + Shift + Delete are for browser history or task management.
-
Alt + P
-
Ctrl + P
-
Ctrl + V
-
Alt + V
C
Correct answer
Explanation
Ctrl+V is the universal keyboard shortcut for pasting in Windows and most applications. Ctrl+P typically opens the Print dialog, not Paste. Alt combinations like Alt+P or Alt+V are not standard paste commands.
-
Alt + C
-
Ctrl + C
-
Ctrl + X
-
Alt + V
C
Correct answer
Explanation
Ctrl+X is the standard keyboard shortcut for Cut in Windows applications - it removes the selected content and places it in the clipboard. Ctrl+C is for Copy (duplicates without removing). The X represents scissors/cutting.
-
Lock Computer
-
Logoff
-
Shutdown
-
All the above
D
Correct answer
Explanation
Ctrl+Alt+Delete opens a security screen in Windows that provides access to Lock, Sign Out (Logoff), Switch User, Task Manager, and the power menu (which includes Shutdown). It's a versatile shortcut for multiple system functions.
-
Key board
-
Num pad
-
Mouse
-
None of these
D
Correct answer
Explanation
Num Lock toggles the numeric keypad between typing numbers and acting as navigation keys (arrows, Home, End, etc.). Turning it ON enables the numbers and disables the navigation functions. Since 'Num pad' itself isn't disabled (just its secondary function), 'None of these' is the most accurate choice.
-
My computer
-
Recycle bin
-
Temp
-
Desktop
B
Correct answer
Explanation
When you delete files in Windows, they first go to the Recycle Bin where they're temporarily stored before permanent deletion. The Temp folder contains temporary system files, not deleted user files. My Computer and Desktop are locations, not deletion destinations.
-
Average
-
Count
-
Minimun
-
Maximum
D
Correct answer
Explanation
The "Maximum" (MAX) function in Excel calculates the largest value in a set of numbers. "Average" calculates the mean, "Count" counts the cells with numbers, and "Minimum" (MIN) finds the smallest value.
-
CTRL+;
-
CTRL+SHIFT+:
-
CTRL+F10
-
CTRL+F11
A
Correct answer
Explanation
In Microsoft Excel, pressing "CTRL+;" inserts the current date into a cell. "CTRL+SHIFT+:" inserts the current time, while the other shortcuts perform different window or sheet functions.
A
Correct answer
Explanation
Most database systems and programming environments allow multiple cursors to be open simultaneously. You can declare and open multiple cursors in the same program or session, fetching from them independently as needed. This is essential for complex data processing scenarios requiring multiple active result sets.
A
Correct answer
Explanation
An application program can have multiple cursors open simultaneously to fetch and process data from different result sets at the same time.
-
Sum up value in the fields specified in the SORT FIELDS statement and keep it as only one occurence in the o/p
-
Removes the duplicates for the fields specified in the SORT FIELDS statement and keeps only the 1st occurence of it
-
Works only for those records in the i/p file where no duplicates for the fields specified in SORT FIELDS statement,
-
None of the above
B
Correct answer
Explanation
SUM FIELDS = NONE is a SORT statement (in JCL and similar utilities) that removes duplicate records. It keeps only the first occurrence of records for the specified sort fields and eliminates subsequent duplicates. It does not sum values - that would require SUM FIELDS = fieldname. The operation applies to all input records, not just non-duplicate ones.
-
Sum up value in the fields specified in the SORT FIELDS statement and keep it as only one occurence in the o/p
-
Removes the duplicates for the fields specified in the SORT FIELDS statement and keeps only the 1st occurence of it
-
Works only for those records in the i/p file where no duplicates for the fields specified in SORT FIELDS statement,
-
None of the above
B
Correct answer
Explanation
SUM FIELDS = NONE removes duplicates by keeping only the first occurrence of records with matching sort keys. Despite the name 'SUM', it doesn't perform arithmetic summation when =NONE is specified - it deduplicates. The matching fields are those in SORT FIELDS statement.
B
Correct answer
Explanation
The statement is false because INREC reformats, adds, or deletes fields before the records are sorted or merged, which optimizes performance by reducing record size prior to sorting. OUTREC is used after sorting.