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
B
Correct answer
Explanation
Pre-query trigger fires once before the query executes. Post-query trigger fires once per record fetched, so for 10 records it fires 10 times. This makes option B (1,10) correct.
-
Provides code to execute if a key's own trigger fails
-
Provides code to execute if user presses a key that has no trigger attached
-
Provides code to execute if user presses wrong key
-
Provides code that accesses another key's trigger and executes the code it contains
B
Correct answer
Explanation
The KEY-OTHERS trigger in Oracle Forms defines the action to be taken when a user presses a function key that does not have its own specific key trigger defined, preventing default behavior or providing a fallback.
-
DOWN
-
COMMIT_FORM
-
No Answer is Correct.
-
All Answers are Correct.
-
GO_ITEM
C
Correct answer
Explanation
PRE-UPDATE triggers have restricted built-in usage. DOWN is for navigation, COMMIT_FORM would cause recursion, and GO_ITEM is restricted in this context. These built-ins cannot be used in PRE-UPDATE triggers.
-
Never
-
When data is committed
-
Before the form is validated
-
After the form is validated
A
Correct answer
Explanation
When Validation Unit is Form, item-level validation (and thus PRE-TEXT-ITEM triggers) is bypassed. Validation occurs only at form level (e.g., on commit), so PRE-TEXT-ITEM never fires.
-
Append, Insert and copy modes
-
Insert Mode, delete mode
-
Add mode, delete mode, append mode
-
Command, Insert mode, Edit mode
B
Correct answer
Explanation
JSON emerged as a lighter alternative to XML for data interchange, especially in web applications. While XML was the dominant format for structured data exchange (especially in SOAP web services), JSON's simpler syntax and native JavaScript compatibility made it a preferred choice for AJAX and later REST APIs. JSON and XML serve similar purposes but with different trade-offs.
-
CTRL + F10
-
CTRL + F5
-
CTRL + F12
-
CTRL + F2
B
Correct answer
Explanation
The shortcut key to Run from Step in QTP is CTRL + F5. This executes the test starting from the currently selected step. Options A (CTRL+F10), C (CTRL+F12), and D (CTRL+F2) are incorrect keyboard combinations for this action.
-
you save and close the file
-
you save excel in XML format
-
you create an excel template
-
you save it in Excel 2007 version
C
Correct answer
Explanation
The .xlt extension is created when you save an Excel file as a template. Templates preserve formatting and structure for reuse. Saving in XML format uses different extensions. Excel 2007 uses .xlsx for regular files. Regular save/close uses .xls or .xlsx.
-
An entire column gets selected in MS Excel
-
The entire worksheet gets selected in MS Excel
-
An entire row gets selected in MS Excel
-
Nothing happens
C
Correct answer
Explanation
Pressing Shift + Space bar in Excel selects the entire row of the active cell. Conversely, Ctrl + Space bar selects the entire column. Selecting the entire worksheet is typically done via Ctrl + A or clicking the top-left corner button.
C
Correct answer
Explanation
Alt+V+Z+2 opens the zoom dialog and selects 25%. In Excel's zoom dialog, the 2 key corresponds to 25% (not 2% or 20%). 200% would be a different selection. This shortcut is a quick way to set a specific zoom level.
-
Shift + F1
-
Ctrl + 1
-
F11 or ALT+F1
-
Ctrl + Shift + F1
C
Correct answer
Explanation
In Microsoft Excel, F11 is the standard shortcut to create a chart on a new sheet instantly from a selected range. ALT+F1 creates an embedded chart on the current worksheet. Other shortcuts like Ctrl+1 are used for formatting cells, not chart creation.
-
The cell gets formatted to Number category with 2 decimal places
-
The cell gets formatted to Number category with 4 decimal places
-
The cell gets formatted into different font
-
Nothing happens
A
Correct answer
Explanation
Ctrl+Shift+1 applies the Number format with 2 decimal places and thousand separators. It does not change fonts, and 4 decimal places would be Ctrl+Shift+2. This is a formatting shortcut for quick number display.
-
Media Player 9
-
Flash Player 9
-
Media Player 8
-
Flash Player 8
B
Correct answer
Explanation
Adobe Flex 3 applications compile into SWF files that require Flash Player 9 or higher to run in a web browser. Older versions like Flash Player 8 do not support the ActionScript 3.0 runtime required by Flex 3.
B
Correct answer
Explanation
VBScript can control the mouse pointer and simulate clicks by utilizing the Windows Script Host Shell object to run PowerShell commands or by calling Windows API functions via external COM objects. Therefore, the statement that we cannot control the mouse using VBScript is false.
A
Correct answer
Explanation
The keyboard shortcut ALT + TAB is the standard operating system command in Windows and many other environments to switch between open applications.