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

Which of the following are correct functions in Excel? (a) = SUM (A1 : A10) (b) = SUM (A1 : B10) (c) = SUM (B1 : A10) (d) = SUM (B10 : A1) (e) = SUM (B10 : A1)

  1. a, b only

  2. a, b, d only

  3. a, b, e only

  4. a, b, c, d only

  5. all of the functions are correct
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

All of the functions are correct. (a) = SUM (A1 : A10) will calculate sum of 10 cells from A1 to A10.  (b) = SUM (A1 : B10) will calculate sum of 20 cells from A1 to B10.  (c) = SUM (B1 : A10) is correct; it will work same as = SUM (A1 : B10) and calculate sum of 20 cells from A1 to B10. (d) = SUM (B10 : A1) is correct; it will work same as = SUM (A1 : B10) and calculate sum of 20 cells from A1 to B10. (e) = SUM (B10 : A1) will calculate sum of 2 cells B10 and A1 Comma(,) is used to represent a group of seperate cells. Colon(:) is used to represent a range or of cells.

 

Multiple choice

A company purchased an asset at a cost of 2400 on 18/9/2012. The end of the first period of the asset is on 31/12/2012. The salvage value for the asset is 500 and the depreciation on the asset is 20%. Which function can be used to calculate the first period depreciation?

  1. ACCRINT function

  2. AMORLINC function

  3. ATAN function

  4. ACCRINTM function

  5. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This is the function in excel, which calculates the first depreciation period.

Multiple choice

A company has purchased an asset at a cost of 2400 on 18/9/2012. The end of first period of the asset is 31/12/2012. The salvage value for the asset is 500 and the depreciation on the asset is 20%. Which function can be used, if the results are needed in the flexible or floating decimals places?

  1. DB function

  2. B. DISC function

  3. C. DDB function

  4. DGET function

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

This function will provide the required result with flexible or floating decimals.

Multiple choice

To reload a Web page, press the ___ button.

  1. Redo

  2. Reload

  3. Restore

  4. Ctrl

  5. Refresh
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

To reload or refresh a web page in a browser, you click the Refresh button (or press F5). This causes the browser to fetch the current page from the server again, updating any content that may have changed. Options like Redo (for undoing an undo action), Reload (the action, not the button name), Restore (for windows or minimized applications), and Ctrl (a modifier key used in keyboard shortcuts) are incorrect.

Multiple choice

In word, you can force a page break

  1. by positioning your cursor at the appropriate place and pressing the F1 key

  2. by positioning your cursor at the appropriate place and pressing Ctrl + Enter

  3. by using the Insert/Section Break

  4. by changing the font size of your document

  5. none of these
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Ctrl+Enter is the standard keyboard shortcut to force a page break at the cursor position in Microsoft Word. The F1 key opens help documentation, Insert/Section Break creates section boundaries rather than simple page breaks, and changing font size has no effect on page breaks.

Multiple choice

Excel documents are stored as files called

  1. workforce

  2. worksheets

  3. worktables

  4. workgroups

  5. workbooks
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

In Microsoft Excel, individual files created and saved are known as workbooks, which can contain multiple worksheets.

Multiple choice

Entering data interactively at the keyboard is called _______.

  1. inquiry-and-response mode

  2. programming mode

  3. indirect mode

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

Inquiry-and-response mode (also called interactive mode) describes entering data at the keyboard during program execution, where the computer prompts (inquires) and the user responds. Programming mode is for writing code, indirect mode stores commands for later execution, and direct mode executes commands immediately without programming.

Multiple choice

Directions: Use the following program segment.

SELECT CASE Choice CASE 10 Price = Quantity * UnitPrice CASE 20 Price = Quantity * UnitPrice * 0.95 CASE 30 Price = Quantity * UnitPrice * 0.90 CASE ELSE PRINT "Invalid Choice." END SELECT

What happens if Choice equals 21?

  1. Price equals Quantity- UnitPrice.

  2. Price equals 95% of Quantity - UnitPrice.

  3. Price equals 90% of Quantity -UnitPrice.

  4. Invalid Choice is displayed.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

When Choice equals 21, it doesn't match any of the specific CASE values (10, 20, or 30). The SELECT CASE structure falls through to the CASE ELSE clause, which executes the PRINT statement displaying "Invalid Choice." None of the Price calculations are performed because no matching CASE was found. Options A, B, and C are all incorrect because they suggest Price calculations occur, which they don't.

Multiple choice

When you type something in a program, the text appears in the _______.

  1. menu bar

  2. view window

  3. title bar

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

The view window (document window) is correct because it displays the content where you type. Menu bar contains commands, title bar shows the program name, and immediate window is specific to programming environments.