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
-
Select Column
-
Select All
-
Select Row
-
None of the above
C
Correct answer
Explanation
In Excel and most spreadsheet applications, pressing Shift+Spacebar selects the entire current row. This is a useful shortcut for quickly highlighting all cells in the active row without using the mouse.
-
Fill right
-
Fill down
-
Undo
-
Cut
A
Correct answer
Explanation
Ctrl+R is the Excel shortcut to fill right, which copies the content and formatting from the cells to the left into the selected cell(s). This is different from Ctrl+D which fills down.
-
Open new workbook
-
Insert new worksheet
-
Open VBE
-
Select all cells
B
Correct answer
Explanation
Shift+F11 is the Excel shortcut to insert a new worksheet. F11 alone creates a chart, while Alt+F11 opens the VBA editor, making this combination specific to adding sheets.
-
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.
-
Select Column
-
Select All
-
Select Row
-
None of the above
C
Correct answer
Explanation
Shift+Spacebar selects the entire row in Excel where the active cell is located. This is different from Ctrl+Spacebar which selects the entire column.
-
Fill right
-
Fill down
-
Undo
-
Cut
A
Correct answer
Explanation
Ctrl+R is the Excel shortcut to fill right, which copies the content and formatting from the cells to the left into the selected cell(s). This is different from Ctrl+D which fills down.
-
Open new workbook
-
Insert new worksheet
-
Open VBE
-
Select all cells
B
Correct answer
Explanation
Shift+F11 is the Excel shortcut to insert a new worksheet. F11 alone creates a chart, while Alt+F11 opens the VBA editor, making this combination specific to adding sheets.
-
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.