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
-
Ctrl+Shift+D
-
Ctrl+Shift+T
-
Ctrl+Shift+3
-
Ctrl+D
C
Correct answer
Explanation
Ctrl+Shift+3 applies the date format with day-month-year (or your system's default date format) in Excel. This shortcut converts numbers to dates without decimal places. Ctrl+Shift+# would also work since # shares the same key as 3.
-
Ctrl+Shift+6
-
Ctrl+Shift+E
-
Ctrl+E
-
Ctrl+Shift+7
A
Correct answer
Explanation
Ctrl+Shift+6 applies the Exponential (Scientific) number format in Excel. This displays numbers in scientific notation like 1.23E+10. The format is useful for very large or very small numbers and shows no decimal places in the default setting.
-
Ctrl+Shift+2
-
Ctrl+Shift+T
-
Ctrl+T
-
Ctrl+S
A
Correct answer
Explanation
Ctrl+Shift+2 applies the time format in Excel, displaying values as hours:minutes or hours:minutes:seconds depending on your system settings. This shortcut is different from date formatting (Ctrl+Shift+3). The number 2 was chosen to distinguish it from the date shortcut.
-
Ctrl+Shift+1
-
Ctrl+1
-
Ctrl+Shift+"."
-
Ctrl+"."
A
Correct answer
Explanation
Ctrl+Shift+1 applies the number format with two decimal places in Excel, using the thousands separator. This displays numbers like 1,234.56 with commas separating thousands. Ctrl+1 opens the Format Cells dialog but does not apply a specific format directly.
-
Ctrl+7
-
Ctrl+Shift+7
-
Ctrl+B
-
Ctrl+Shift+B
B
Correct answer
Explanation
Ctrl+Shift+7 applies the outline border around selected cells in Excel. This adds a border on all outside edges of the selection. Note that Ctrl+Shift+- removes borders, while Ctrl+B applies bold formatting rather than borders.
-
Click the "Errors" tab
-
Click the "All Errors" tab
-
Click the "All Issues" tab
-
Click the "Warnings" tab
B
Correct answer
Explanation
In TMF (Testing Management Framework), the All Errors tab shows every error encountered during test execution. This is distinct from a general Errors tab which might show only current or filtered errors. The All Issues tab would include warnings as well.
-
click the code tab
-
Click the impact tab
-
Click the severity tab
-
None of the above
B
Correct answer
Explanation
In MSChange, to find the expected impact of a change, you click on the Impact tab. This is the most direct and logical path - the Impact tab would contain information about what systems or services will be affected. The Code tab would typically contain technical details or identifiers, Severity tab indicates urgency level, and None of the above is incorrect since the Impact tab exists.
-
If onKeyDown returns false, the key-press event is cancelled.
-
If onKeyPress returns false, the key-down event is cancelled.
-
If onKeyDown returns false, the key-up event is cancelled.
-
If onKeyPress returns false, the key-up event is cancelled.
A
Correct answer
Explanation
In DOM event handling, onKeyDown returning false prevents the key-press event from firing. The event sequence is keydown → keypress → keyup, and canceling keydown stops the chain. Options C and D are wrong because onKeyDown doesn't affect key-up, which always fires when the key is released.
-
keybrd
-
kb.ctl
-
keyboard.control
-
control keyboard
D
Correct answer
Explanation
The command to open keyboard properties is 'control keyboard'. This opens the Keyboard tab in Control Panel. The other options ('keybrd', 'kb.ctl', 'keyboard.control') are not valid commands.
-
Bt1.Text = @”Go”;
-
Bt1.Text = “&Go”;
-
Bt1.Text = “&&Go”;
-
Bt1.Text = “@Go”;
B
Correct answer
Explanation
In Windows Forms, the ampersand (&) character before a letter creates an access key (shortcut). Writing "&Go" makes ALT+G trigger the button. The @ prefix in option A is for verbatim strings in C# and doesn't create shortcuts. Using && (option C) would display a literal ampersand. Option D uses @ incorrectly in this context.
B
Correct answer
Explanation
alt-t is NOT the keyboard shortcut for adding ports in a transformation. The correct shortcut varies by transformation type, but alt-t typically performs other functions. Common shortcuts involve right-click menus or other key combinations.
-
Ctrl + V
-
Ctrl + D
-
Ctrl + P
-
Ctrl + N
B
Correct answer
Explanation
In spreadsheet applications like Excel, Ctrl+D (Down) copies the content and formatting from the cell directly above to the selected cell(s) below. Ctrl+V is for paste, Ctrl+P is print, and Ctrl+N creates a new workbook.
-
Alt + Page Up
-
Alt + Page Down
-
Alt + Home
-
Alt + Insert
A
Correct answer
Explanation
In Windows Remote Desktop sessions, Alt + Page Up switches between applications in the left-to-right direction. This is specific to RDP client keyboard mapping and differs from standard Windows Alt+Tab behavior.
-
Ctrl + Alt + Break
-
Ctrl + Insert
-
Alt + Insert
-
Ctrl + Alt + End
C
Correct answer
Explanation
Alt + Insert in Remote Desktop sessions cycles through running programs in the order they were launched, providing an alternative to Alt+Tab that respects startup sequence rather than recent usage.
-
Ctrl + Home
-
Alt + Home
-
Alt + Del
-
Ctrl + Alt + End
B
Correct answer
Explanation
In Windows Remote Desktop sessions, Alt + Home brings up the Start menu, providing access to programs and system features when the local keyboard's Windows key might not be available or forwarded properly.