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

Multiple choice technology
  1. Control+"{"

  2. Control+"}"

  3. Control+"["

  4. Control+"]"

Reveal answer Fill a bubble to check yourself
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.

Multiple choice technology
  1. Ctrl+Shift+2

  2. Ctrl+Shift+D

  3. Ctrl+Shift+0

  4. Ctrl+Shift+"`"

Reveal answer Fill a bubble to check yourself
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.

Multiple choice technology
  1. Ctrl+Shift+4

  2. Ctrl+Shift+9

  3. Ctrl+Shift+F10

  4. Ctrl+Shift+F4

Reveal answer Fill a bubble to check yourself
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.

Multiple choice technology
  1. Ctrl+Shift+5

  2. Ctrl+Shift+"-"

  3. Ctrl+Shift+7

  4. Ctrl+Shift+2

Reveal answer Fill a bubble to check yourself
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.

Multiple choice technology
  1. Click the "Errors" tab

  2. Click the "All Errors" tab

  3. Click the "All Issues" tab

  4. Click the "Warnings" tab

Reveal answer Fill a bubble to check yourself
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.

Multiple choice technology
  1. click the code tab

  2. Click the impact tab

  3. Click the severity tab

  4. None of the above

Reveal answer Fill a bubble to check yourself
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.

Multiple choice technology
  1. Allows for viewing of performance statistics for network devices

  2. Allows for viewing of cricket score

  3. Allows for viewing of performance statistics for servers

  4. None of the above

Reveal answer Fill a bubble to check yourself
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.

Multiple choice technology web technology
  1. If onKeyDown returns false, the key-press event is cancelled.

  2. If onKeyPress returns false, the key-down event is cancelled.

  3. If onKeyDown returns false, the key-up event is cancelled.

  4. If onKeyPress returns false, the key-up event is cancelled.

Reveal answer Fill a bubble to check yourself
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.