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

How you select a range of cells using mouse in MS-Excel?

  1. Drag across the row and column heading.

  2. Press the arrow keys to move to the cell.

  3. Click the first cell of range, and then drag to the last cell.

  4. Click the row number.

  5. Click the column letter.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This will select a range of cells.

Multiple choice

What is the use of 'Ctrl + Spacebar' in MS-Excel?

  1. For selecting whole columns

  2. For selecting whole worksheets

  3. For selecting current region

  4. For selecting current block of data

  5. For selecting active cell plus one cell up
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

This is the right answer. This selects all columns.

Multiple choice

In MS-PowerPoint, what is the use of Ctrl + Shift + P?

  1. This shortcut key increases the font size of the selected text.

  2. This shortcut key decreases the font size of the selected text.

  3. This shortcut key opens the font dialog box to change the font.

  4. This shortcut key opens the font dialog box to change the font size.

  5. This shortcut key moves up one paragraph.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

For this, Ctrl + Shift + P is used.

Multiple choice

In Excel, 'go to' function is assigned to

  1. F4

  2. F5

  3. F6

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

In Microsoft Excel, the F5 key is assigned to the 'Go To' function. This allows users to quickly jump to a specific cell, range, or named range in the worksheet. F4 is used for repeating the last action or toggling reference types. This is a standard keyboard shortcut across Excel versions.

Multiple choice

An application program that stores data in columns and rows and permits calculations with the data is known as

  1. sheet

  2. spreadsheet

  3. file

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

A spreadsheet is application software designed to organize data in tabular format (rows and columns) and perform calculations on that data. Examples include Microsoft Excel and Google Sheets. A sheet is a component within a spreadsheet. A file is a generic storage container. A column is just one dimension of the tabular structure.