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
-
Crtl+Shift+!
-
Crtl+Shift+~
-
Shift+~
-
Shift+!
B
Correct answer
Explanation
Ctrl+Shift+~ (tilde) applies the General number format in Excel, which is the default format that displays numbers as they are entered. The exclamation mark option applies currency format, while just Shift+~ has no formatting function.
-
Ctrl+Shift+$
-
Ctrl+Shift+#
-
Ctrl+#
-
Shift+#
A
Correct answer
Explanation
Ctrl+Shift+$ applies the Currency format with two decimal places in Excel. The $ symbol represents the currency key - on most keyboards this is the same as the number 4 key. The hash symbol (#) is used for date format, not currency.
-
Crtl+Shift+_
-
Crtl+Shift+^
-
Ctrl+Shift+%
-
Crtl+Shift+)
C
Correct answer
Explanation
Ctrl+Shift+% applies percentage format with no decimal places in Excel. The percentage symbol key is Shift+5 on most keyboards, so the full shortcut is Ctrl+Shift+5 (which displays as Ctrl+Shift+%).
-
Ctrl+#+Shift
-
Ctrl+Shift+&
-
Crtl+Shift+*
-
Ctrl+Shift+(
D
Correct answer
Explanation
Ctrl+Shift+( (opening parenthesis) is the Excel shortcut to unhide any hidden rows within the selected range. This is the opposite of Ctrl+9 which hides rows. The ampersand (&) is for borders, asterisk (*) has other functions.
-
Ctrl+Shift+8
-
Ctrl+Shift+&
-
Crtl+Shift+$
-
Ctrl+Shift+0
B
Correct answer
Explanation
Ctrl+Shift+& is the correct Excel keyboard shortcut to apply an outline border to selected cells. The other options are not standard Excel border shortcuts.
-
Ctrl+5
-
Ctrl+2
-
Ctrl+Y
-
Ctrl+R
A
Correct answer
Explanation
Ctrl+5 is the Excel keyboard shortcut to apply or remove strikethrough formatting from selected text. The other shortcuts perform different formatting functions.
-
Ctrl+Q
-
Ctrl+9
-
Ctrl+N
-
Ctrl+7
B
Correct answer
Explanation
Ctrl+9 is the Excel keyboard shortcut to hide selected rows. This is a quick way to conceal rows without using the ribbon menu. Ctrl+Shift+9 unhides them.
-
Ctrl+Q
-
Ctrl+9
-
Ctrl+N
-
Ctrl+7
B
Correct answer
Explanation
Ctrl+9 is the Excel keyboard shortcut to hide selected rows. This is a quick way to conceal rows without using the ribbon menu. Ctrl+Shift+9 unhides them.
-
Ctrl+D
-
Ctrl+O
-
Ctrl+0
-
Ctrl+F
C
Correct answer
Explanation
In Excel and similar spreadsheet applications, Ctrl+0 is the keyboard shortcut to hide selected columns. To unhide hidden columns, use Ctrl+Shift+0. Ctrl+D is for fill down, Ctrl+O opens files, and Ctrl+F opens Find.
-
Ctrl+#
-
Ctrl+%
-
Ctrl+Shift+&
-
Ctrl+Shift+#
D
Correct answer
Explanation
In Excel, Ctrl+Shift+# applies the date format (dd-mmm-yy) which displays day, month abbreviation, and year. Ctrl+# without Shift doesn't exist as a default shortcut. Ctrl+% applies percentage format.
-
CTRL +; (semicolon)
-
CTRL + SHIFT + :(colon)
-
CTRL + F10
-
CTRL + F11
A
Correct answer
Explanation
In Excel and most spreadsheet software, CTRL + ; (semicolon) inserts the current date in the selected cell. CTRL + SHIFT + : inserts the current time.
-
Auto Summarize
-
Home key
-
Ctrl key + End key
-
End key
C
Correct answer
Explanation
The keyboard combination Ctrl + End is the standard shortcut to quickly navigate to the end of a document in most applications. The End key alone moves to the end of the current line, while Ctrl + Home moves to the beginning of the document. This shortcut works consistently across Microsoft Word, text editors, and most software applications.
-
End
-
Ctrl + End
-
Home
-
Ctrl + Home
B
Correct answer
Explanation
Ctrl+End is the standard keyboard shortcut to move the cursor to the end of a document in most text editors and word processors. The 'End' key alone moves only to the end of the current line, while Ctrl+Home moves to the beginning of the document.
-
Ctrl + Enter
-
Ctrl + Shift + Enter
-
Shift + Enter
-
Ctrl + D
-
Ctrl + '+'
-
Ctrl + S
-
Ctrl + *
-
Ctrl + Shift + '+'
A
Correct answer
Explanation
Ctrl + '+' (Ctrl plus the plus key) is the standard shortcut in most applications to make selected text subscript. This formatting is commonly used for chemical formulas (H₂O) and mathematical expressions.