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
-
Copy
-
Paste
-
Delete
-
Fill down
D
Correct answer
Explanation
Ctrl+D fills down in Excel, copying content and formatting from cells directly above into the selected cell(s). The D stands for Down, just as Ctrl+R fills Right.
-
maximize all
-
minimize all
-
open mouse settings
-
open microsoft official site
B
Correct answer
Explanation
The Windows key + M keyboard shortcut immediately minimizes all open windows to the taskbar, providing a quick way to clear your desktop. This is different from Windows + D which shows the desktop. The 'M' stands for minimize, making it easy to remember.
-
refresh
-
Undo
-
Moves among panes in windows explorer
-
select all
C
Correct answer
Explanation
F6 is a specialized navigation key that cycles through different panes or sections within Windows Explorer and other multi-pane applications. This helps users move between the folder tree, file list, and address bar without using the mouse. It's particularly useful for keyboard-only navigation.
-
print last page
-
print all pages
-
disable printing
-
Toggles high contrast
D
Correct answer
Explanation
The Alt + Shift + PrintScreen combination is a Windows accessibility shortcut that toggles High Contrast mode, making the screen easier to see for users with visual impairments. This is not related to printing documents despite the PrintScreen key in the combination. It's an important accessibility feature in Windows.
-
direct shutdown
-
start menu
-
Task Manager
-
delete item directly
C
Correct answer
Explanation
Ctrl + Shift + Esc is the direct keyboard shortcut to open Task Manager in Windows, providing immediate access to monitor and manage running processes. This is faster than the alternative Ctrl + Alt + Delete method. Task Manager is essential for troubleshooting unresponsive programs and system performance issues.
-
Close Workbook
-
Insert Chart Sheet
-
Close Help window
-
New Workbook
B
Correct answer
Explanation
Alt + F1 in Excel inserts a new chart sheet. This shortcut creates a chart sheet in the workbook. The other options are incorrect - Alt + F1 does not close workbooks, help windows, or create new workbooks.
-
Select All
-
Cut
-
Save As
-
Goto
C
Correct answer
Explanation
Alt + F2 in Excel opens the Save As dialog box. This keyboard shortcut allows users to save the current workbook with a new name or in a different location. It is different from Ctrl + S which performs a regular save operation.
-
Close Workbook
-
Open Workbook
-
Save As
-
Delete
A
Correct answer
Explanation
Ctrl + W in Excel closes the current workbook. This is a standard shortcut used to close the active workbook. Users are prompted to save changes if there are any unsaved modifications before the workbook closes.
-
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.