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

To make a window wider, you would move the pointer until it changes to the Horizontal Resize shape and then _____.

  1. click

  2. right click

  3. double click

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

To resize a window wider, you move the pointer to the edge until it becomes a horizontal resize cursor (double-headed arrow), then drag the edge to the desired width. Clicking or double-clicking does not resize the window. Dragging is the standard method for all window resizing operations.

Multiple choice general knowledge

In excel, "F7" is shortcut key for ?

  1. Next Pane

  2. Spell Check

  3. Activate menu

  4. Delete sheet
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

F7 in Excel launches the spell checker to review spelling and grammar errors in your worksheet. This shortcut is consistent across Microsoft Office applications. F6 moves between panes, and sheets are deleted differently.

Multiple choice general knowledge

In excel, Ctrl+Page Up is ?

  1. Previous Worksheet

  2. Next Worksheet

  3. Page Up

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

Ctrl+Page Up is a keyboard shortcut in Excel that navigates to the previous worksheet tab. This is useful for quickly moving between multiple sheets in a workbook without using the mouse. Ctrl+Page Down would move to the next worksheet instead.

Multiple choice general knowledge

In excel, Ctrl + insert is to ?

  1. Delete

  2. Copy

  3. Paste

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

Ctrl+Insert is a standard keyboard shortcut for copying selected content in Excel and many other applications. It works identically to the more commonly known Ctrl+C shortcut. This shortcut copies the selected cells to the clipboard for pasting later.

Multiple choice general knowledge

In excel, Shift+Ctrl+; is for ?

  1. Insert Date and Time

  2. Insert Date

  3. Insert Time

  4. None of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Ctrl+Shift+; (semicolon) inserts the current time in Excel. The standard Ctrl+; inserts the current date, while Ctrl+Shift+: (which is the same as Ctrl+Shift+;) inserts the current time. Both are useful for timestamping data entries.

Multiple choice general knowledge

Shift+Spacebar ?

  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

Ctrl+R ?

  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

Shift+F11 ?

  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

Ctrl+D ?

  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

Shift+Spacebar ?

  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

Ctrl+R ?

  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

Shift+F11 ?

  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.