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

Multiple choice general knowledge

how do you select a columb in excel?

  1. Control +Space

  2. shift +Space

  3. control+1

  4. Shift+1
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Control + Space selects the entire column in Excel. This keyboard shortcut highlights all cells in the current column. Shift + Space selects rows, while Control + 1 opens format cells dialog.

Multiple choice general knowledge

how to add filter?

  1. ALT+D+D+D

  2. ALT+A+D+F

  3. ALT+D+E+E

  4. ALT+D+F+F
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

ALT+D+F+F is the Excel keyboard shortcut to add filters to a dataset. This activates AutoFilter on the selected header row. The other combinations are not valid Excel filter shortcuts.

Multiple choice general knowledge

How to select Row in Excel?

  1. Shift+1

  2. Control+Space

  3. Shift+Space

  4. control+1
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Shift + Space selects the entire row in Excel. This highlights all cells in the current row. Control + Space selects columns, while Control + 1 opens formatting options.

Multiple choice general knowledge

The Key Ctrl+ F9 is used to

  1. Minimize current Window

  2. MAximize the current Window

  3. Undo the last Action

  4. Fill
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Ctrl+F9 minimizes the current workbook window in Excel, collapsing it to a taskbar button while keeping the file open. This is different from closing (Alt+F4 or Ctrl+F4) - minimized files can be restored by clicking the taskbar item. Maximize is typically done with the window controls, not a keyboard shortcut in Excel.

Multiple choice general knowledge

The Key Ctrl+ k is used to

  1. Select the entire row

  2. Strikethrough highlighted section

  3. Insert Link

  4. Go to a specific cell
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Ctrl+K is the universal shortcut for inserting or editing hyperlinks in most Microsoft Office applications (Word, Excel, PowerPoint, Outlook) and many web browsers. It opens the 'Insert Hyperlink' dialog where you can specify the URL or document location. Selecting rows is typically Shift+Space, and strikethrough uses Ctrl+5 or format menus.

Multiple choice general knowledge

The Key Alt+Shift+F1 is used to

  1. Select alll the contents of the worksheet

  2. Insert New Worksheet

  3. Bold Highlighted Section

  4. Open Go-To Options
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Alt+Shift+F1 inserts a new worksheet in Excel, adding a blank sheet to the current workbook. The alternative shortcut Shift+F11 also performs the same action. Selecting all contents is Ctrl+A or Ctrl+Shift+Space, and bold formatting is Ctrl+B. The typo 'alll' in option A is a minor spelling error.