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
-
CTRL+SPACEBAR
-
SHIFT+SPACEBAR
-
CTRL+SHIFT+SPACEBAR
-
SPACEBAR
B
Correct answer
Explanation
SHIFT+SPACEBAR is the Excel shortcut to select the entire row of the active cell. Option B is correct. Option A (CTRL+SPACEBAR) selects the entire column. Option C selects the entire worksheet. Option D has no selection function.
-
CTRL + F10
-
CTRL + F8
-
CTRL + F
-
CTRL + F9
D
Correct answer
Explanation
CTRL+F9 minimizes or restores the workbook window. Option D is correct. Options A and C are for other functions (F10 is for menu bar, F is for Find). Option B is not a standard Excel shortcut.
-
CTRL + ENTER
-
ALT + ENTER
-
SHIFT + ENTER
-
ENTER
B
Correct answer
Explanation
ALT+ENTER creates a line break within the same cell in Excel. Option B is correct. Option A (CTRL+ENTER) fills selected cells with the current entry. Options C and D simply move the selection to different cells.
-
Delete the selected cells.
-
Clear the contents of the selected cells.
-
Insert blank cells.
-
Cut the selected cells.
C
Correct answer
Explanation
CTRL+SHIFT+PLUS SIGN inserts blank cells at the selected location, shifting existing cells as needed. Option C is correct. Options A and D describe delete/cut operations. Option B clears cell contents without removing the cells themselves.
-
CTRL + SHIFT + (
-
CRTL + [
-
CRTL + 9
-
CRTL + 0
C
Correct answer
Explanation
CTRL+9 is the correct keyboard shortcut to hide selected rows in Excel. The shortcut hides the entire row(s) containing the selected cell(s). Option A's CTRL+SHIFT+( is a typo and not a valid Excel shortcut.
-
CTRL + ' (apostrophe)
-
CTRL + " (quotation mark)
-
CTRL + ; (semicolon)
-
CTRL + - (hyphen)
A
Correct answer
Explanation
CTRL+' (apostrophe) copies the formula from the cell above into the active cell or Formula Bar. This is different from CTRL+" which copies the value (not formula) from above.
-
ALT + F4
-
ALT + F5
-
ALT + F8
-
ALT + F7
C
Correct answer
Explanation
ALT+F8 opens the Macro dialog box in Excel, displaying all available macros. ALT+F4 closes the application, not macro-related.
D
Correct answer
Explanation
osk is the Windows Run command that opens the On-Screen Keyboard. The other options are either incorrect or incomplete: 'ok' and 'oks' are not valid commands, 'sk' is too short and not recognized.
-
SHIFT + CTRL + A
-
SHIFT + ALT + A
-
SHIFT + CTRL + F
-
SHIFT + ALT + F
C
Correct answer
Explanation
SHIFT + CTRL + F in Excel opens the Format Cells dialog with the Font tab active, providing access to font family, size, style, and color options. This is the standard shortcut for font formatting in Microsoft Office. The other key combinations listed are not standard font property shortcuts.
-
CTRL + 1
-
CTRL + 2
-
CTRL + 3
-
CTRL + 4
B
Correct answer
Explanation
CTRL + 2 in Excel toggles bold formatting as an alternative to CTRL + B, using Excel's numbered shortcut system where 2=bold, 3=italic, 4=underline. This provides the same functionality as CTRL + B but can be more convenient with the number row. CTRL + 1 opens Format Cells instead.
-
SHIFT + CTRL + 7
-
SHIFT + 7
-
ALT + 7
-
CTRL + 7
A
Correct answer
Explanation
SHIFT + CTRL + 7 in Excel applies borders to selected cells using the last-used border style, or removes borders if already present. This shortcut is specific to Excel and works with the bottom border by default. The 7 key was chosen for its visual similarity to a corner bracket.
-
SHIFT + F5
-
SHIFT + F1
-
SHIFT + F10
-
SHIFT + F9
C
Correct answer
Explanation
SHIFT + F10 universally opens the right-click context menu in Windows applications, serving as a keyboard alternative to right-clicking or pressing the Menu key. This shortcut works across most Windows programs. SHIFT + F5 performs find or refresh, SHIFT + F1 shows help, and SHIFT + F9 varies by application.
-
ALT + V
-
CTRL + V
-
SHIFT + F11
-
ALT + F11
D
Correct answer
Explanation
ALT + F11 opens the Visual Basic Editor across Microsoft Office applications, providing access to VBA macros and programming environment. This shortcut works consistently in Excel, Word, PowerPoint, and Outlook. ALT + V opens View menu, CTRL + V is paste, and SHIFT + F11 inserts a worksheet.
-
ALT + >
-
CTRL + +(plus)
-
SHIFT + CTRL + >
-
SHIFT + ALT + P
C
Correct answer
Explanation
SHIFT + CTRL + > increases font size in Microsoft Office by stepping up through available font sizes. The greater-than symbol visually represents making text larger. CTRL + + also works in some apps, while ALT + > and SHIFT + ALT + P are not standard font shortcuts.
-
SHIFT + CTRL + ALT + >
-
SHIFT + CTRL + >
-
CTRL + ALT + >
-
SHIFT + ALT + >