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
A
Correct answer
Explanation
In Windows Vista, the Alt+Tab key combination does access Windows Aero, displaying the 3D flip view of open windows. This is a correct statement.
-
Ctrl + A
-
Ctrl + V
-
Ctrl + Arrow Key
-
Ctrl + Page up / down Key
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.
-
Ctrl + A
-
Ctrl + V
-
Ctrl + Arrow Key
-
Ctrl + Page up / down Key
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.
-
Using F4 key in formula bar
-
Using F2 key in formula bar
-
Ctrl + F4
-
Ctrl + F3
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.
-
Using F4
-
Using F2
-
Ctrl + D
-
Ctrl + F3
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.
-
Ctrl + F2
-
Ctrl + F3
-
F4
-
F2
C
Correct answer
Explanation
F7 is the standard keyboard shortcut in Microsoft Word and many word processors to check spelling and grammar. This function reviews the document for errors and suggests corrections, making it an essential tool for document editing.
B
Correct answer
Explanation
A standard PC keyboard typically has 104 keys, which includes the standard alphanumeric keys, function keys, navigation keys, and numeric keypad. This is the industry standard for full-size keyboards, though specialized keyboards may vary.
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.
-
ALT+HOME
-
ALT+PAGEUP
-
ALT+PAGEDOWN
-
ALT+END
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.
-
SHIFT+PAGEDOWN
-
SHIFT+HOME
-
SHIFT+F11
-
SHIFT+F12
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.
-
CTRL+HOME
-
CTRL+PAGEUP
-
CTRL+PAGEDOWN
-
CTRL+END
B,C
Correct answer
Explanation
In Excel, CTRL+PAGEUP moves to the previous worksheet and CTRL+PAGEDOWN moves to the next worksheet. These are the standard keyboard shortcuts for navigating between tabs in an Excel workbook.
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.
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.
D
Correct answer
Explanation
The Edit menu in most applications contains clipboard operations like Cut, Copy, and Paste. These are standard editing functions for manipulating text and data within documents. The File menu handles file operations, while Tools typically contains utilities and settings.