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 technology mainframe

Different formats of accessing files

  1. VFMT

  2. FMT

  3. UNFMT

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In mainframe file access, different formats include VFMT (Variable Format), FMT (Fixed Format), and UNFMT (Unformatted). These represent different ways data is structured and accessed in mainframe systems. 'All of the above' correctly indicates that these are all valid file format types in mainframe computing environments.

Multiple choice technology mainframe

VSAM files can be created through file aid?

  1. True

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

File-AID is primarily a file browsing, editing, and comparison tool, not a file creation utility. While you can edit VSAM file contents with File-AID, the actual creation and definition of VSAM clusters requires IDCAMS or similar utilities. VSAM file creation involves defining cluster structures that File-AID doesn't handle.

Multiple choice technology programming languages

Which of the following is used to check whether the Caps lock in keyboard is turned on or Not By using VB.Net 2005?

  1. If My.Computer.Keyboard.CapsLock = True Then

  2. If System.Computer.Keyboard.CapsLock = True Then

  3. Both A and B

  4. None of the Above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In VB.Net 2005, the My.Computer.Keyboard.CapsLock property returns a Boolean value indicating whether the Caps Lock key is turned on, making option A the correct syntax.

Multiple choice technology

What does the Key "F1" does ?

  1. Delete content of document

  2. Universal Help in Windows program.

  3. Edit options in current program

  4. Goes to end of document.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

F1 is the universal Help key in Windows applications. Pressing F1 typically opens context-sensitive help or documentation for the currently active application or control.

Multiple choice technology

What "Ctrl + End" does ?

  1. Goes to end of document

  2. Highlights from current position to end of line.

  3. Goes to end of current line.

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

Ctrl+End moves the cursor to the end of the entire document in Windows applications. The End key alone moves to the end of the current line, while adding Ctrl extends the navigation scope to the document end.

Multiple choice technology

What will happen when you tripple click by your mouse on a word document ?

  1. Opens to another open Microsoft Word document.

  2. Selects the line or paragraph of the text the mouse triple-clicked.

  3. Zooms in and out of document the mouse triple-clicked.

  4. Insert the current time.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When you triple-click in Microsoft Word, it selects the entire paragraph or line of text where your mouse is clicked. This is a standard Word shortcut for quickly selecting whole paragraphs. It does not open other documents, zoom, or insert time.

Multiple choice technology

Which do you press to enter the current date in a cell?

  1. CTRL+SHIFT+: (colon)

  2. CTRL+F10

  3. CTRL+; (semicolon)

  4. CTRL+F8
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In spreadsheet applications like Excel, pressing CTRL+; (semicolon) enters the current date into the active cell. The similar shortcut CTRL+SHIFT+: (colon) enters the current TIME, not the date. CTRL+F8 and CTRL+F10 are not related to date/time entry. This is a useful shortcut for quickly timestamping data.

Multiple choice technology

You need the Insert Function dialog box. How do you get it?

  1. Right-click a cell, and then click Insert.
  2. Type $ in a cell.

  3. Click the Insert menu, and then click Function.

  4. Type = in a cell.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The Insert Function dialog box in Excel is accessed by clicking the Insert menu and then selecting Function. This opens a dialog that helps you search for and insert functions with their arguments. Right-clicking a cell and choosing Insert inserts cells or rows/columns, not functions. Typing $ creates an absolute reference, and typing = simply begins a formula entry.

Multiple choice technology

What is the combinaison of keys required to come back to the top of the worksheet?

  1. PageUp (PgUp)

  2. Alt and PageUp

  3. Ctrl and Home

  4. Ctrl and left arrow
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Ctrl+Home is the universal keyboard shortcut in spreadsheet software like Microsoft Excel to jump to cell A1, which is the top-left corner of the worksheet. PageUp only moves up one screen at a time, while Ctrl+left arrow moves to the left edge of the current data region, not necessarily to the top.

Multiple choice technology

Say that you want to paste a formula result — but not the underlying formula — to another cell. In Excel 2002, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to. What next?

  1. Click the Paste button on the Standard toolbar.

  2. Click the arrow on the Paste button on the Standard toolbar, then click Formulas.

  3. Click the arrow on the Paste button on the Standard toolbar, then click Values.

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

To paste formula results (values only), you click the arrow on the Paste button and select Values. This pastes the calculated result without the underlying formula.

Multiple choice technology

Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

  1. Use CTRL to select all three cells, then click the Paste button on the Standard toolbar.

  2. Copy the selected cell, then select the other two cells, click Style on the Format menu, then click Modify.

  3. Click Format Painter on the Formatting toolbar twice, then click in each cell you want to copy the formatting to.

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

Format Painter copies formatting from one cell to others. Double-clicking Format Painter keeps it active for multiple cells. Clicking once applies it once; double-clicking allows applying to multiple cells sequentially.

Multiple choice technology

To balance your checkbook in Excel, your best method is:

  1. Copy your check amounts into Excel so that you'll have a neat printout to work on.

  2. Use Excel to check your arithmetic.

  3. Click Validation on the Data menu.

  4. Download the Checkbook Register template from Templates on Microsoft Office Online.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The best method to balance a checkbook in Excel is to download the Checkbook Register template from Microsoft Office Online templates. This provides a pre-formatted template designed specifically for checkbook management.