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
-
Control+"{"
-
Control+"}"
-
Control+"["
-
Control+"]"
C
Correct answer
Explanation
Trace Precedents is an Excel auditing tool that draws arrows from precedent cells to the selected cell. The keyboard shortcut is Ctrl+[ (Control+[), which selects all direct precedent cells. Options A, B, and D are incorrect - they do not correspond to Trace Precedents.
-
Ctrl+F
-
Ctrl+1
-
Ctrl+6
-
Ctrl+Alt+6
B
Correct answer
Explanation
Ctrl+1 is the standard Excel shortcut to open the Format Cells dialog. This shortcut provides quick access to all cell formatting options.
-
Ctrl+Shift+2
-
Ctrl+Shift+D
-
Ctrl+Shift+0
-
Ctrl+Shift+"`"
D
Correct answer
Explanation
In Excel, Ctrl+Shift+` (backtick/grave accent) applies the General number format to selected cells. This format displays numbers without specific formatting like decimal places or currency symbols. The shortcut uses the key to the left of the number 1 on standard keyboards.
-
Ctrl+Shift+4
-
Ctrl+Shift+9
-
Ctrl+Shift+F10
-
Ctrl+Shift+F4
A
Correct answer
Explanation
Ctrl+Shift+4 applies the Currency format with two decimal places in Excel. This shortcut adds the currency symbol and ensures exactly two decimal places are displayed. The choice makes sense because the $ symbol appears on the same key as the number 4.
-
Ctrl+Shift+5
-
Ctrl+Shift+"-"
-
Ctrl+Shift+7
-
Ctrl+Shift+2
B
Correct answer
Explanation
Ctrl+Shift+- (minus sign) removes all borders from selected cells in Excel. This is a quick way to clear cell borders without accessing the format menu. Note that Ctrl+Shift+7 does the opposite - it applies an outline border.
-
Ctrl+Shift+D
-
Ctrl+Shift+T
-
Ctrl+Shift+3
-
Ctrl+D
C
Correct answer
Explanation
Ctrl+Shift+3 applies the date format with day-month-year (or your system's default date format) in Excel. This shortcut converts numbers to dates without decimal places. Ctrl+Shift+# would also work since # shares the same key as 3.
-
Ctrl+Shift+6
-
Ctrl+Shift+E
-
Ctrl+E
-
Ctrl+Shift+7
A
Correct answer
Explanation
Ctrl+Shift+6 applies the Exponential (Scientific) number format in Excel. This displays numbers in scientific notation like 1.23E+10. The format is useful for very large or very small numbers and shows no decimal places in the default setting.
-
Ctrl+Shift+2
-
Ctrl+Shift+T
-
Ctrl+T
-
Ctrl+S
A
Correct answer
Explanation
Ctrl+Shift+2 applies the time format in Excel, displaying values as hours:minutes or hours:minutes:seconds depending on your system settings. This shortcut is different from date formatting (Ctrl+Shift+3). The number 2 was chosen to distinguish it from the date shortcut.
-
Ctrl+Shift+1
-
Ctrl+1
-
Ctrl+Shift+"."
-
Ctrl+"."
A
Correct answer
Explanation
Ctrl+Shift+1 applies the number format with two decimal places in Excel, using the thousands separator. This displays numbers like 1,234.56 with commas separating thousands. Ctrl+1 opens the Format Cells dialog but does not apply a specific format directly.
-
Ctrl+7
-
Ctrl+Shift+7
-
Ctrl+B
-
Ctrl+Shift+B
B
Correct answer
Explanation
Ctrl+Shift+7 applies the outline border around selected cells in Excel. This adds a border on all outside edges of the selection. Note that Ctrl+Shift+- removes borders, while Ctrl+B applies bold formatting rather than borders.
-
Click the "Errors" tab
-
Click the "All Errors" tab
-
Click the "All Issues" tab
-
Click the "Warnings" tab
B
Correct answer
Explanation
In TMF (Testing Management Framework), the All Errors tab shows every error encountered during test execution. This is distinct from a general Errors tab which might show only current or filtered errors. The All Issues tab would include warnings as well.
-
click the code tab
-
Click the impact tab
-
Click the severity tab
-
None of the above
B
Correct answer
Explanation
In MSChange, to find the expected impact of a change, you click on the Impact tab. This is the most direct and logical path - the Impact tab would contain information about what systems or services will be affected. The Code tab would typically contain technical details or identifiers, Severity tab indicates urgency level, and None of the above is incorrect since the Impact tab exists.
-
Allows for viewing of performance statistics for network devices
-
Allows for viewing of cricket score
-
Allows for viewing of performance statistics for servers
-
None of the above
A
Correct answer
Explanation
CricketNet is a network monitoring tool that provides performance statistics and graphs for network devices such as routers, switches, and other infrastructure. Option A correctly describes its purpose. Option B is incorrect despite the name - it's not related to the sport of cricket. Option C is incorrect because CricketNet focuses on network devices, not servers.
-
If onKeyDown returns false, the key-press event is cancelled.
-
If onKeyPress returns false, the key-down event is cancelled.
-
If onKeyDown returns false, the key-up event is cancelled.
-
If onKeyPress returns false, the key-up event is cancelled.
A
Correct answer
Explanation
In DOM event handling, onKeyDown returning false prevents the key-press event from firing. The event sequence is keydown → keypress → keyup, and canceling keydown stops the chain. Options C and D are wrong because onKeyDown doesn't affect key-up, which always fires when the key is released.
-
keybrd
-
kb.ctl
-
keyboard.control
-
control keyboard
D
Correct answer
Explanation
The command to open keyboard properties is 'control keyboard'. This opens the Keyboard tab in Control Panel. The other options ('keybrd', 'kb.ctl', 'keyboard.control') are not valid commands.