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
A
Correct answer
Explanation
In Microsoft Excel, pressing Ctrl + F9 minimizes the workbook window, whereas Ctrl + F10 maximizes or restores it. Therefore, the statement is true.
A
Correct answer
Explanation
Ctrl + 1 in Excel opens the Format Cells dialog box, which provides access to all formatting options for the selected cell or range. This is the correct answer.
-
Format
-
bold
-
underline
-
none
B
Correct answer
Explanation
Ctrl + 2 in Excel is used to apply or remove bold formatting from the selected cell or text. This is the correct answer.
-
Italicize
-
underline
-
bold
-
none
B
Correct answer
Explanation
Ctrl + 4 in Excel is used to apply or remove underline formatting from the selected cell or text. This is the correct answer.
-
Strikethrough the font
-
underline
-
change font
-
none
A
Correct answer
Explanation
Ctrl + 5 in Excel is used to apply or remove strikethrough formatting from the selected cell or text. This is the correct answer.
B
Correct answer
Explanation
In Excel, Ctrl+D fills down (copies from cell above), Ctrl+' copies formula from cell above, and Ctrl+" copies value from cell above. These are three different keyboard shortcuts with distinct functions - they are not equivalent to each other. Each shortcut serves a specific purpose in data entry and formula manipulation.
B
Correct answer
Explanation
In Excel, Ctrl+R copies from the LEFT cell to the active cell (fill right), not from the upper cell. Ctrl+D copies from the UPPER cell (fill down). These are two different shortcuts - Ctrl+D goes vertical, Ctrl+R goes horizontal. The statement incorrectly describes Ctrl+D's function.
A
Correct answer
Explanation
In Microsoft Excel, the shortcut Ctrl + R executes the Fill Right command, which copies the contents and format of the leftmost cell in a selected range into the cells to the right. Consequently, the statement is true.
B
Correct answer
Explanation
Ctrl+Shift+F4 is not equivalent to Shift+Tab in Excel or most applications. Ctrl+Shift+F4 typically has no default function in Excel or is related to closing windows in some applications, while Shift+Tab moves backward between cells/fields. These are completely different keyboard commands with unrelated functions.
B
Correct answer
Explanation
Ctrl+Shift+F3 (not F2) is the Excel shortcut for creating names from selected text. Ctrl+Shift+F2 has no default function related to creating names in Excel - it may be used for other purposes like inserting comments or closing windows in different applications. The statement incorrectly identifies the shortcut.
B
Correct answer
Explanation
In most Microsoft Office applications, Ctrl+F12 is typically the shortcut for 'Save As' (opening the save dialog), while Ctrl+P is the 'Print' command. These are two distinct functions with different purposes, so they are not equivalent.
B
Correct answer
Explanation
In PowerPoint (and most Office applications), Alt+F opens the File menu, while F10 is also used to activate the Menu Bar or File menu in different contexts. The equivalence depends on the specific PowerPoint version and context. The question is ambiguous without specifying version/context.
B
Correct answer
Explanation
F4 and Ctrl+F4 are different keyboard shortcuts. F4 alone typically activates the address bar in browsers or repeats the last action in some applications, while Ctrl+F4 is used to close the current tab or document window in many programs.
B
Correct answer
Explanation
Ctrl+F2 is not the shortcut for previewing slides in black and white mode in PowerPoint. The black and white preview is typically accessed through the View menu, not via a Ctrl+F2 keyboard shortcut.
B
Correct answer
Explanation
Alt+4 is not the keyboard shortcut to close PowerPoint. The standard shortcut to close an application in Windows is Alt+F4. Alt+4 has no special function for closing PowerPoint presentations.