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

Ctrl + F2 opens a task pane

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Ctrl + F2 does not open a task pane in Excel. In Excel, F2 by itself edits the active cell, while Ctrl + F2 is not a standard Excel shortcut. The statement is therefore false.

Multiple choice general knowledge

Alt + F8 used to enable Macro?

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Alt + F8 does not enable macros in Excel. Instead, Alt + F8 opens the Macro dialog box that allows you to run existing macros. Enabling macros is typically done through the Trust Center settings or security options.

Multiple choice general knowledge

Ctrl+1

  1. Format

  2. bold

  3. italics

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

Ctrl + 1 in Excel opens the Format Cells dialog box, which provides access to all formatting options for the selected cell or range. This is the correct answer.

Multiple choice general knowledge

Ctrl+ 2

  1. Format

  2. bold

  3. underline

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

Ctrl + 2 in Excel is used to apply or remove bold formatting from the selected cell or text. This is the correct answer.

Multiple choice general knowledge

Ctrl+ +4

  1. Italicize

  2. underline

  3. bold

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

Ctrl + 4 in Excel is used to apply or remove underline formatting from the selected cell or text. This is the correct answer.

Multiple choice general knowledge

Ctrl+ 5

  1. Strikethrough the font

  2. underline

  3. change font

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

Ctrl + 5 in Excel is used to apply or remove strikethrough formatting from the selected cell or text. This is the correct answer.

Multiple choice general knowledge

Ctrl + D = Ctrl + ' = Ctrl + "

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Excel, Ctrl+D fills down (copies from cell above), Ctrl+' copies formula from cell above, and Ctrl+" copies value from cell above. These are three different keyboard shortcuts with distinct functions - they are not equivalent to each other. Each shortcut serves a specific purpose in data entry and formula manipulation.

Multiple choice general knowledge

Ctrl + D copies down from the upper cell

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Excel, Ctrl+R copies from the LEFT cell to the active cell (fill right), not from the upper cell. Ctrl+D copies from the UPPER cell (fill down). These are two different shortcuts - Ctrl+D goes vertical, Ctrl+R goes horizontal. The statement incorrectly describes Ctrl+D's function.

Multiple choice general knowledge

Ctrl + Shift + F4 = Shift + Tab mostly?

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Ctrl+Shift+F4 is not equivalent to Shift+Tab in Excel or most applications. Ctrl+Shift+F4 typically has no default function in Excel or is related to closing windows in some applications, while Shift+Tab moves backward between cells/fields. These are completely different keyboard commands with unrelated functions.