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 operating systems
  1. CTRL+SPACEBAR

  2. SHIFT+SPACEBAR

  3. CTRL+SHIFT+SPACEBAR

  4. SPACEBAR

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

SHIFT+SPACEBAR is the Excel shortcut to select the entire row of the active cell. Option B is correct. Option A (CTRL+SPACEBAR) selects the entire column. Option C selects the entire worksheet. Option D has no selection function.

Multiple choice technology operating systems
  1. CTRL + ENTER

  2. ALT + ENTER

  3. SHIFT + ENTER

  4. ENTER

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

ALT+ENTER creates a line break within the same cell in Excel. Option B is correct. Option A (CTRL+ENTER) fills selected cells with the current entry. Options C and D simply move the selection to different cells.

Multiple choice technology operating systems
  1. Delete the selected cells.

  2. Clear the contents of the selected cells.

  3. Insert blank cells.

  4. Cut the selected cells.

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

CTRL+SHIFT+PLUS SIGN inserts blank cells at the selected location, shifting existing cells as needed. Option C is correct. Options A and D describe delete/cut operations. Option B clears cell contents without removing the cells themselves.

Multiple choice technology operating systems
  1. CTRL + SHIFT + (

  2. CRTL + [

  3. CRTL + 9

  4. CRTL + 0

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

CTRL+9 is the correct keyboard shortcut to hide selected rows in Excel. The shortcut hides the entire row(s) containing the selected cell(s). Option A's CTRL+SHIFT+( is a typo and not a valid Excel shortcut.

Multiple choice technology operating systems
  1. ok

  2. sk

  3. oks

  4. osk

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

osk is the Windows Run command that opens the On-Screen Keyboard. The other options are either incorrect or incomplete: 'ok' and 'oks' are not valid commands, 'sk' is too short and not recognized.

Multiple choice technology operating systems
  1. SHIFT + CTRL + A

  2. SHIFT + ALT + A

  3. SHIFT + CTRL + F

  4. SHIFT + ALT + F

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

SHIFT + CTRL + F in Excel opens the Format Cells dialog with the Font tab active, providing access to font family, size, style, and color options. This is the standard shortcut for font formatting in Microsoft Office. The other key combinations listed are not standard font property shortcuts.

Multiple choice technology operating systems
  1. CTRL + 1

  2. CTRL + 2

  3. CTRL + 3

  4. CTRL + 4

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

CTRL + 2 in Excel toggles bold formatting as an alternative to CTRL + B, using Excel's numbered shortcut system where 2=bold, 3=italic, 4=underline. This provides the same functionality as CTRL + B but can be more convenient with the number row. CTRL + 1 opens Format Cells instead.

Multiple choice technology operating systems
  1. SHIFT + CTRL + 7

  2. SHIFT + 7

  3. ALT + 7

  4. CTRL + 7

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

SHIFT + CTRL + 7 in Excel applies borders to selected cells using the last-used border style, or removes borders if already present. This shortcut is specific to Excel and works with the bottom border by default. The 7 key was chosen for its visual similarity to a corner bracket.

Multiple choice technology operating systems
  1. SHIFT + F5

  2. SHIFT + F1

  3. SHIFT + F10

  4. SHIFT + F9

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

SHIFT + F10 universally opens the right-click context menu in Windows applications, serving as a keyboard alternative to right-clicking or pressing the Menu key. This shortcut works across most Windows programs. SHIFT + F5 performs find or refresh, SHIFT + F1 shows help, and SHIFT + F9 varies by application.

Multiple choice technology operating systems
  1. ALT + V

  2. CTRL + V

  3. SHIFT + F11

  4. ALT + F11

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

ALT + F11 opens the Visual Basic Editor across Microsoft Office applications, providing access to VBA macros and programming environment. This shortcut works consistently in Excel, Word, PowerPoint, and Outlook. ALT + V opens View menu, CTRL + V is paste, and SHIFT + F11 inserts a worksheet.

Multiple choice technology operating systems
  1. ALT + >

  2. CTRL + +(plus)

  3. SHIFT + CTRL + >

  4. SHIFT + ALT + P

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

SHIFT + CTRL + > increases font size in Microsoft Office by stepping up through available font sizes. The greater-than symbol visually represents making text larger. CTRL + + also works in some apps, while ALT + > and SHIFT + ALT + P are not standard font shortcuts.