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
-
SHIFT+P
-
CTRL+P
-
ESC+P
-
DEL+ENTER
B
Correct answer
Explanation
CTRL+P is the universal keyboard shortcut for printing across almost all applications and operating systems. This standard has been consistent for decades in computing.
-
ALT+UP ARROW
-
SHIFT+PAGE UP
-
CTRL++
-
CTRL+SCROLL UP
D
Correct answer
Explanation
CTRL+SCROLL UP is the most universal way to zoom in on a webpage. While CTRL++ also works in some browsers, CTRL+SCROLL UP is consistent across browsers and platforms.
-
ALT+ENTER
-
SHIFT+F1
-
CTRL+CAPS
-
CTRL+ENTER
A
Correct answer
Explanation
ALT+ENTER is the standard keyboard shortcut to view properties of a selected file or object in Windows and many other systems. This quickly displays detailed information without multiple clicks.
-
Ctrl+Shift Key
-
Shift+Space Key
-
Ctrl+Space Key
-
Shift+Tab Key
C
Correct answer
Explanation
Ctrl+Space is the Excel shortcut to select the entire column of the active cell. This differs from Shift+Space, which selects the entire row instead - both are useful for working with large datasets.
-
Ctrl+Up Arrow Key
-
Ctrl+Pageup Key
-
Shift+Pageup Key
-
Ctrl+Left Arrow Key
B
Correct answer
Explanation
Ctrl+PageUp is the Excel shortcut to navigate to the previous sheet in a workbook. The complementary shortcut Ctrl+PageDown moves to the next sheet, making it easy to cycle through multiple tabs.
C
Correct answer
Explanation
F4 is the Excel function key that repeats your last action or command. This is particularly useful for quickly applying formatting, formulas, or edits to multiple cells without re-navigating menus.
A
Correct answer
Explanation
F5 opens the Go To dialog box in Excel, allowing quick navigation to any cell reference or named range. This is useful for jumping to distant cells or specific data points without scrolling.
-
Ctrl+Shift+Tab
-
Shift+Space
-
Shift+Tab
-
Ctrl+Space
B
Correct answer
Explanation
Shift+Space is the Excel shortcut to select the entire row of the active cell. This complements Ctrl+Space for column selection, making it efficient to work with rows and columns in data analysis.
-
Shift+Ctrl+Page Down
-
Ctrl+Down Arrow
-
Shift+Down Arrow
-
Ctrl+Page Down
D
Correct answer
Explanation
Ctrl+PageDown is the Excel shortcut to navigate to the next sheet in a workbook. This standard shortcut allows quick movement between worksheet tabs when working with multi-sheet files.
B
Correct answer
Explanation
F11 is the correct keyboard shortcut to create a chart in Microsoft Excel. When you have data selected, pressing F11 instantly creates a new chart sheet with a default chart. The other options (F10, F12, F4) perform different functions like activating menu bar, saving as, or repeating last action.
-
Alt+F4
-
Alt+M
-
Alt+F8
-
Ctrl+F8
C
Correct answer
Explanation
Alt+F8 is the correct shortcut to display the Macro dialog box in Excel, allowing you to run, create, or manage macros. Alt+F4 closes the application, Alt+M is not a standard Excel shortcut, and Ctrl+F8 has no default function related to macros.
-
Shift+F2
-
Shift+F1
-
Shift+F6
-
Shift+F9
A
Correct answer
Explanation
Shift+F2 is the correct shortcut to edit an existing cell comment in Excel. When a cell has a comment, this shortcut lets you quickly edit its contents. F2 alone edits the cell itself, and adding Shift extends this to comments.
-
.wav files and .mid files
-
.wav files and .gif files
-
.wav files and .jpg files
-
.jpg files and .gif files
A
Correct answer
Explanation
.wav is a standard audio format for sound effects, and .mid (MIDI) files are used for musical sequences in PowerPoint. .gif and .jpg are image file formats, not audio formats, so they cannot be used for sound effects.
-
Tab
-
Ctrl + K
-
Ctrl + h
-
All of above
A
Correct answer
Explanation
Tab is the keyboard shortcut that cycles through hyperlinks in presentation order. Ctrl+K creates hyperlinks but doesn't select them, Ctrl+h is find/replace not related to hyperlinks.
-
Next slide button
-
Page up
-
Ctrl + Home
-
Ctrl + End
C
Correct answer
Explanation
Ctrl + Home is the keyboard shortcut that navigates to the first slide in a PowerPoint presentation. Ctrl + End would take you to the last slide, while the Next slide button and Page Up move forward through slides.