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

Multiple choice general knowledge
  1. Select Column

  2. Select All

  3. Select Row

  4. None of the above

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In Excel and most spreadsheet applications, pressing Shift+Spacebar selects the entire current row. This is a useful shortcut for quickly highlighting all cells in the active row without using the mouse.

Multiple choice general knowledge
  1. Fill right

  2. Fill down

  3. Undo

  4. Cut

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

Ctrl+R is the Excel shortcut to fill right, which copies the content and formatting from the cells to the left into the selected cell(s). This is different from Ctrl+D which fills down.

Multiple choice general knowledge
  1. Open new workbook

  2. Insert new worksheet

  3. Open VBE

  4. Select all cells

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Shift+F11 is the Excel shortcut to insert a new worksheet. F11 alone creates a chart, while Alt+F11 opens the VBA editor, making this combination specific to adding sheets.

Multiple choice general knowledge
  1. Copy

  2. Paste

  3. Delete

  4. Fill down

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Ctrl+D fills down in Excel, copying content and formatting from cells directly above into the selected cell(s). The D stands for Down, just as Ctrl+R fills Right.

Multiple choice general knowledge
  1. Select Column

  2. Select All

  3. Select Row

  4. None of the above

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Shift+Spacebar selects the entire row in Excel where the active cell is located. This is different from Ctrl+Spacebar which selects the entire column.

Multiple choice general knowledge
  1. Fill right

  2. Fill down

  3. Undo

  4. Cut

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

Ctrl+R is the Excel shortcut to fill right, which copies the content and formatting from the cells to the left into the selected cell(s). This is different from Ctrl+D which fills down.

Multiple choice general knowledge
  1. Open new workbook

  2. Insert new worksheet

  3. Open VBE

  4. Select all cells

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Shift+F11 is the Excel shortcut to insert a new worksheet. F11 alone creates a chart, while Alt+F11 opens the VBA editor, making this combination specific to adding sheets.

Multiple choice general knowledge
  1. Copy

  2. Paste

  3. Delete

  4. Fill down

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Ctrl+D fills down in Excel, copying content and formatting from cells directly above into the selected cell(s). The D stands for Down, just as Ctrl+R fills Right.

Multiple choice general knowledge science & technology
  1. maximize all

  2. minimize all

  3. open mouse settings

  4. open microsoft official site

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The Windows key + M keyboard shortcut immediately minimizes all open windows to the taskbar, providing a quick way to clear your desktop. This is different from Windows + D which shows the desktop. The 'M' stands for minimize, making it easy to remember.

Multiple choice general knowledge science & technology
  1. refresh

  2. Undo

  3. Moves among panes in windows explorer

  4. select all

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

F6 is a specialized navigation key that cycles through different panes or sections within Windows Explorer and other multi-pane applications. This helps users move between the folder tree, file list, and address bar without using the mouse. It's particularly useful for keyboard-only navigation.

Multiple choice general knowledge science & technology
  1. print last page

  2. print all pages

  3. disable printing

  4. Toggles high contrast

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The Alt + Shift + PrintScreen combination is a Windows accessibility shortcut that toggles High Contrast mode, making the screen easier to see for users with visual impairments. This is not related to printing documents despite the PrintScreen key in the combination. It's an important accessibility feature in Windows.

Multiple choice general knowledge science & technology
  1. direct shutdown

  2. start menu

  3. Task Manager

  4. delete item directly

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Ctrl + Shift + Esc is the direct keyboard shortcut to open Task Manager in Windows, providing immediate access to monitor and manage running processes. This is faster than the alternative Ctrl + Alt + Delete method. Task Manager is essential for troubleshooting unresponsive programs and system performance issues.

Multiple choice general knowledge
  1. Close Workbook

  2. Insert Chart Sheet

  3. Close Help window

  4. New Workbook

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Alt + F1 in Excel inserts a new chart sheet. This shortcut creates a chart sheet in the workbook. The other options are incorrect - Alt + F1 does not close workbooks, help windows, or create new workbooks.

Multiple choice general knowledge
  1. Select All

  2. Cut

  3. Save As

  4. Goto

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Alt + F2 in Excel opens the Save As dialog box. This keyboard shortcut allows users to save the current workbook with a new name or in a different location. It is different from Ctrl + S which performs a regular save operation.

Multiple choice general knowledge
  1. Close Workbook

  2. Open Workbook

  3. Save As

  4. Delete

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

Ctrl + W in Excel closes the current workbook. This is a standard shortcut used to close the active workbook. Users are prompted to save changes if there are any unsaved modifications before the workbook closes.