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
-
Ctrl + Shift + R
-
Ctrl + Backspace
-
Ctrl + R
-
F7
C
Correct answer
Explanation
Ctrl + R is the standard keyboard shortcut in Microsoft Excel and other spreadsheet applications to fill right. This copies the contents or formula from the cell(s) to the left into the current cell(s) to the right. It's the horizontal equivalent of Ctrl + D which fills down.
-
Ctrl + J
-
Shift + F9
-
F3
-
Ctrl + K
D
Correct answer
Explanation
Ctrl + K is the universal keyboard shortcut for inserting hyperlinks across Microsoft Office applications (Word, Excel, PowerPoint, Outlook) and many other software programs. This shortcut opens the Insert Hyperlink dialog box, allowing you to link to web pages, files, or other locations within the document.
-
Ctrl + S
-
Ctrl + F4
-
Ctrl + t
-
Ctrl + Z
D
Correct answer
Explanation
Ctrl + Z is the standard keyboard shortcut for undoing the last action in most Windows and Linux applications. It's a universal command that reverses the most recent action. Ctrl + S saves, Ctrl + F4 often closes a document or tab, and Ctrl + T usually opens a new tab.
-
Ctrl + 3
-
Ctrl + 5
-
Ctrl + Shift + :(Colon)
-
Ctrl + Shift + ;(Semi Colon)
C
Correct answer
Explanation
In Microsoft Excel, Ctrl + Shift + : (colon) inserts the current time in the selected cell. This is a useful shortcut for quickly adding timestamps. The semicolon version (Ctrl + Shift + ;) inserts the date instead.
-
Ctrl + F4
-
Ctrl + ;(Semi Colon)
-
Ctrl + 4
-
Ctrl + 7
B
Correct answer
Explanation
In Microsoft Excel, Ctrl + ; (semicolon) inserts the current date in the selected cell. This is a standard Excel shortcut that's useful for quickly adding today's date to a spreadsheet. The time shortcut uses Ctrl + Shift + : instead.
-
Ctrl + Y
-
Shift + F7
-
Alt + F7
-
Shift + F9
A
Correct answer
Explanation
Ctrl + Y is the standard keyboard shortcut for 'redo' or repeating the last action in most applications. It's the opposite of Ctrl + Z (undo) and can repeat actions or redo undone steps. This shortcut works across most Windows software.
-
Ctrl + PAGE UP
-
Shift + Insert
-
Alt + P
-
Alt + Q
-
Ctrl + Shift + R
-
Ctrl + Backspace
-
Ctrl + R
-
Ctrl + W
D
Correct answer
Explanation
Ctrl + W is the universal keyboard shortcut to close the current document or tab in spreadsheet software like Excel and Google Sheets. This shortcut works consistently across most spreadsheet applications.
-
Shift + R
-
Ctrl + +
-
Ctrl + Shift + Q
-
Alt + Y
B
Correct answer
Explanation
Ctrl + + (plus sign) inserts a new row in Excel. The plus symbol visually represents adding something, making this shortcut intuitive for insertion operations.
-
Ctrl + -
-
Ctrl + Shift + R
-
Ctrl + Backspace
-
Shift + F2
A
Correct answer
Explanation
Ctrl + - (minus sign) deletes the selected row in Excel. The minus symbol represents removing or subtracting, making this shortcut easy to remember for deletion operations.
-
Ctrl + Shift + R
-
Ctrl + Backspace
-
Ctrl + R
-
Shift + F2
D
Correct answer
Explanation
Shift + F2 opens or edits the comment attached to the selected cell in Excel. F2 alone edits the cell content, while adding Shift modifies the action to edit the comment instead.
-
Ctrl + J
-
Shift + F9
-
F3
-
Ctrl + 9
D
Correct answer
Explanation
Ctrl + 9 hides the selected row(s) in Excel. The number 9 is used for hiding rows, while 0 is used for hiding columns. To unhide, use Ctrl + Shift + 9.
-
Enthiran
-
Chandhiran
-
Indhiran
-
Aegan
A
Correct answer
Explanation
'Alt+Control+Delete' refers to the keyboard task manager command. In the context of Tamil films, 'Enthiran' (2010) starring Rajinikanth features Chitti, a robot who can be controlled or deleted. The other options are also Tamil films with 'rajan' endings but 'Enthiran' is the sci-fi film about artificial intelligence.
-
Auto Summarize
-
Home key
-
Ctrl key + End key
-
End key
C
Correct answer
Explanation
Ctrl+End is the standard keyboard shortcut to jump to the end of a document. The End key alone moves to the end of the current line. Home key goes to line start. Auto Summarize is not a navigation feature.
-
CTRL + 1
-
CTRL + 2
-
CTRL + 3
-
CTRL + 6
C
Correct answer
Explanation
The question claims CTRL + 3 is the shortcut for italics. However, in Microsoft Office applications and most text editors, the standard shortcut for italics is CTRL + I. Different applications may have different shortcuts, and CTRL + 3 might be specific to a particular program version. The other options (CTRL + 1, 2, 6) are not standard formatting shortcuts.