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

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.

Multiple choice general knowledge

The Key Ctrl+F6 is used to

  1. Select Entire Row

  2. Switch between open workbooks /windows

  3. Move Between two or more open Excel files

  4. Underline the selected text
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Ctrl+F6 switches between open workbook windows in Excel, allowing navigation when multiple Excel files are open simultaneously. This is similar to Alt+Tab for switching between applications but specific to Excel windows. Options A (row selection) and D (underline) are incorrect - Ctrl+F6 is purely for window switching within Excel.

Multiple choice general knowledge

The Key Ctrl+ U is used for

  1. Create Chart

  2. Bring up Search Box

  3. Underlined selected text

  4. Underlined highlighted selection
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Ctrl+U applies or removes underline formatting for the selected text in most Microsoft Office applications. This is a text formatting shortcut similar to Ctrl+B (bold) and Ctrl+I (italic). Creating charts uses F11 or Alt+F1, and search is Ctrl+F. Options C and D both describe the same action (underline), with D being the selected answer.

Multiple choice general knowledge

The Key Ctrl+ Shift+ ; is used for

  1. Enter the current time

  2. Enter the current date

  3. Edit the selected cell

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

Ctrl+Shift+; enters the current time into the selected cell in Excel. This is a useful shortcut for timestamping data. For entering just the date, use Ctrl+; (semicolon without Shift). Editing cells is F2, and going to a specific cell is F5 or Ctrl+G. The time is entered in the default time format (e.g., 14:30:00).

Multiple choice general knowledge

The Key Ctrl+ G is used to

  1. Open Go-To Options

  2. Open find and replace options

  3. Select all contents of the Worksheet

  4. Move next section of the text
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Ctrl+G opens the 'Go To' dialog in Excel, allowing you to jump to a specific cell address, named range, or reference. This is useful for navigating large spreadsheets quickly. Find and Replace is Ctrl+H, Select All is Ctrl+A, and Ctrl+G does not move to the next text section. The Go To feature can also be accessed with F5.

Multiple choice general knowledge

The key Ctrl+ Page Up+ Page Down is used to

  1. Move between Excel worksheets in the same document

  2. Switch between open workbooks /windows

  3. Open Excel Formula Window

  4. Open Print Dialog Box
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Ctrl+Page Up/Page Down navigates between worksheet tabs within the same Excel workbook. For switching between open workbooks or windows, Ctrl+Tab is typically used instead.

Multiple choice general knowledge

The Key Ctrl+ W is used to

  1. Open Document

  2. Close Document

  3. Move the next section of the text

  4. Format number in date format
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Ctrl+W is the universal keyboard shortcut to close the current document or tab in most applications including web browsers, word processors, and email clients.

Multiple choice general knowledge

The key Alt+ S is used for

  1. Send the mail

  2. Copy the selected text

  3. Cut the selected text

  4. Open print dialog box
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Alt+S is commonly used in email applications like Microsoft Outlook to send the current message. Alt key combinations typically access application-specific menu functions and shortcuts.

Multiple choice general knowledge

The Key Ctrl+ C is used for

  1. Copy the selected text

  2. Create a new mail

  3. Reply to an mail

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

Ctrl+C is the universal keyboard shortcut for copying selected text or objects to the clipboard. It works across virtually all applications and operating systems as a standard convention.