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 general knowledge
  1. Ctrl + A

  2. Ctrl + V

  3. Ctrl + Arrow Key

  4. Ctrl + Page up / down Key

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

Ctrl + Arrow Key is the correct Excel shortcut to jump to the next occupied cell in the direction of the arrow pressed. This works horizontally (left/right arrows), vertically (up/down arrows), and can be used sequentially for diagonal movement. Ctrl+A selects all, Ctrl+V is paste, and Ctrl+Page Up/Down switches between worksheets.

Multiple choice general knowledge
  1. Ctrl + A

  2. Ctrl + V

  3. Ctrl + Arrow Key

  4. Ctrl + Page up / down Key

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

In Microsoft Excel, Ctrl+Page Up moves to the previous worksheet and Ctrl+Page Down moves to the next worksheet in a workbook. This is a standard keyboard shortcut that works consistently across Excel versions. The other options are incorrect - Ctrl+A selects all, Ctrl+V is paste, and Ctrl+Arrow keys move within the current sheet.

Multiple choice general knowledge
  1. Using F4 key in formula bar

  2. Using F2 key in formula bar

  3. Ctrl + F4

  4. Ctrl + F3

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

In Excel, pressing F4 in the formula bar or cell adds the dollar sign ($) to create absolute references (e.g., A1 becomes $A$1). This locks the cell reference so it doesn't change when copied. F2 is for editing, Ctrl+F4 closes the workbook, and Ctrl+F3 opens the Name Manager.

Multiple choice general knowledge
  1. Using F4

  2. Using F2

  3. Ctrl + D

  4. Ctrl + F3

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

In Excel, F4 repeats the last action (like a duplicate command), and Ctrl+D copies the content from the cell directly above to fill down. Both are valid keyboard shortcuts for duplicating actions or content. F2 is for editing, and Ctrl+F3 opens the Name Manager.

Multiple choice general knowledge
  1. F8

  2. F9

  3. F10

  4. F11

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

In Microsoft Excel, pressing F11 while cells are selected creates a chart on a new chart sheet. This is a quick shortcut to visualize selected data. F8, F9, and F10 serve other functions - F8 extends selection, F9 recalculates formulas, and F10 activates the menu bar. Note: This shortcut works in most Excel versions but behavior can vary by edition.

Multiple choice general knowledge
  1. ALT+HOME

  2. ALT+PAGEUP

  3. ALT+PAGEDOWN

  4. ALT+END

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

In Excel, ALT+PAGEUP moves to the previous worksheet and ALT+PAGEDOWN moves to the next worksheet. These shortcuts allow quick navigation between multiple sheets in a workbook without using the mouse. ALT+HOME and ALT+END are not valid worksheet navigation shortcuts.

Multiple choice general knowledge
  1. SHIFT+PAGEDOWN

  2. SHIFT+HOME

  3. SHIFT+F11

  4. SHIFT+F12

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

SHIFT+F11 is the Excel shortcut to insert a new worksheet immediately before the current (active) sheet. This is useful when you need to add sheets in specific positions. SHIFT+F12 has no default function, while SHIFT+HOME and SHIFT+PAGEDOWN are for cell selection, not worksheet insertion.

Multiple choice general knowledge science & technology
  1. File

  2. Tools

  3. Special

  4. Edit

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

The Edit menu in virtually all GUI applications contains the Cut, Copy, and Paste commands. This is a standardized convention across operating systems (Windows, macOS, Linux) that makes interfaces consistent and intuitive. The File menu typically deals with file operations (open, save, print), while Tools contains utilities and Special is rarely a standard menu.

Multiple choice general knowledge science & technology
  1. File

  2. Tools

  3. Special

  4. Edit

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

The Edit menu in virtually all GUI applications contains the Cut, Copy, and Paste commands. This is a standardized convention across operating systems (Windows, macOS, Linux) that makes interfaces consistent and intuitive. The File menu typically deals with file operations (open, save, print), while Tools contains utilities and Special is rarely a standard menu. This is a duplicate of question 13645.