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

Multiple choice technology
  1. rename

  2. erase

  3. open

  4. delete

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Among the file operations listed, 'erase' is the odd one out because it is a DOS/Windows command, while 'rename', 'open', and 'delete' are common Unix/Linux commands. The Unix equivalent of 'erase' is 'rm' (remove). This tests knowledge of cross-platform command differences.

Multiple choice technology
  1. Unhides columns in the selection

  2. Inserts the argument names and parentheses for the function (after you type a valid function name in a formula)

  3. Selects direct precedent cells

  4. Hides columns

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The Ctrl+Shift+) keyboard shortcut in Excel unhides any hidden columns within the selected range. This is useful when you've hidden columns for presentation purposes and need to reveal them again. The other shortcuts described (Ctrl+A for function arguments, Ctrl+[ for precedents, Ctrl+0 to hide) use different key combinations.

Multiple choice technology
  1. Enters the current time

  2. Equivalent to Undo

  3. Equivalent to Insert ? Links ? Hyperlink

  4. Closes the window

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The Ctrl+: (Ctrl+semicolon) keyboard shortcut in Excel enters the current time into the selected cell. This is useful for timestamping data entries. The other options (Ctrl+Z for Undo, Ctrl+K for Hyperlink, Alt+F4 for Close) use different key combinations.

Multiple choice technology
  1. Inserts the AutoSum formula

  2. Hides rows

  3. Minimizes the workbook

  4. Activates to the next window

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Ctrl+F9 is a keyboard shortcut in Microsoft Excel that minimizes or restores the current workbook window. Option A describes Alt+= (AutoSum), Option B refers to Ctrl+9 (hide rows), and Option D refers to Ctrl+F6 or Ctrl+Tab (switch to next window).

Multiple choice technology
  1. Sets or removes strikethrough

  2. Applies the comma format with two decimal places

  3. Hides columns

  4. Applies border to outline

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Ctrl+Shift+& applies an outside border (outline border) to the selected cells in Excel. Option A refers to Ctrl+5 (strikethrough), Option B is Ctrl+Shift+! (comma format), and Option C is Ctrl+0 (hide columns). The ampersand (&) key shares the 7 key, making this the border shortcut.

Multiple choice technology
  1. Repeats the last Find (Find Next)

  2. Edits a cell comment

  3. Edits the active cell

  4. Allows resizing the window with the arrow keys

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Shift+F2 edits or inserts a comment on the active cell in Excel. Option A is Shift+F4 (Find Next), Option C is F2 (edit cell), and Option D refers to maximizing/restoring with arrow keys. The Shift modifier changes F2 from editing cell contents to editing the cell comment.

Multiple choice technology operating systems
  1. Windows Logo + E

  2. Windows Logo + D

  3. Windows Logo + M

  4. None

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Windows Logo + D is the keyboard shortcut that minimizes all open windows and displays the desktop. Windows Logo + E opens File Explorer, while Windows Logo + M minimizes all windows but doesn't necessarily display the desktop if there are minimized windows.

Multiple choice technology operating systems
  1. Ctrl + S

  2. Windows Logo + D

  3. Windows Logo

  4. None

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Pressing the Windows Logo key alone opens the Start Menu in Windows. Ctrl + S is the save shortcut, Windows Logo + D shows the desktop, and None is incorrect. This is a fundamental Windows navigation shortcut.