0

Computer Aptitude (NCO)

Description: This test contains questions on basics Olympiad level questions.
Number of Questions: 15
Created by:
Tags: IT and computers Computer Aptitude MS Word M.S. Office NCO (National Cyber Olympiad) MS Excel
Attempted 0/15 Correct 0 Score 0

How many bits make 1 byte in the memory?

  1. 6 bits

  2. 7 bits

  3. 8 bits

  4. 9 bits

  5. 4 bits


Correct Option: C
Explanation:

In almost all the modern computers, the group of 8 bits is equal to 1 byte.

Which of the following commands is used in MS-DOS to view the name of the file or directory which starts with the letter 'A'?

  1. dir

  2. dir/p

  3. dir a*

  4. dir *a

  5. dir/w


Correct Option: C
Explanation:

This command will perform pattern matching in dos and display the list according to it.

What is the name given to the term which is available free of cost on the internet for a limited period?

  1. Shareware

  2. Firmware

  3. Windows update

  4. Open source software

  5. Netware


Correct Option: A
Explanation:

It is a trial version of the software which is available on the internet for free. As soon as it completes it's time period, it prompts the user for full download or to purchase the software.

What do you understand by redundancy in the database?

  1. Missing of information in the database

  2. Incorrect information in the database

  3. Repetition of information in the database

  4. Incomplete information in the database

  5. Non-repetition of data in the database


Correct Option: C
Explanation:

If in the table, certain value or data is coming twice or thrice times it is called redundancy.

A feature in word processing software, which enables the user to combine text with graphics or images is called

  1. word wrapping

  2. text editing

  3. text wrapping

  4. formatting

  5. deleting


Correct Option: C
Explanation:

The feature in the word processing software, which enables the user to place the text and position it with an image is called text wrapping. It provides you many options like in line with the text, below the text, etc.

Which option is used by a person in order to add/remove various toolbars from the window in Office 2003?

  1. File

  2. Insert

  3. View

  4. Tools

  5. Table


Correct Option: C
Explanation:

View contains options which are used for adding and removing various toolbars like standard bar, formatting bar, etc. You have to check against the bar which you want in your document.

What do you understand by the term software wizard?

  1. It is a combination of textual as well as graphical symbols which guides the user.

  2. It helps user in performing various tasks.

  3. It is a step-by-step process to solve a particular problem.

  4. It is a graphical approach which is used in various software designs.

  5. It is used in software installation.


Correct Option: A
Explanation:

The dialog box which contains written as well as graphical symbols and guides the user at each step and provide alternatives for every step is called a wizard.

Which Microsoft application is used by a person in order to manage group of records or information?

  1. Ms-Word

  2. Ms-Access

  3. Ms-Excel

  4. Word star

  5. Ms-Power Point


Correct Option: B
Explanation:

It is used for storing and managing information in the form of tables.

Which is the first step when you are working in a word document and perform mail merge by using step by step mail merge wizard?

  1. Select recipient

  2. Select starting documents

  3. Select document type

  4. Write your letter

  5. Type a new list


Correct Option: C
Explanation:

This is the first step in which the user has to select the type of document on which he applies mail merge, i.e. letters, envelopes, labels, etc.

Which feature is used by a person if he/she wishes to format cells based on conditions?

  1. Format cells

  2. Search

  3. Conditional formatting

  4. Sort

  5. Formatting


Correct Option: C
Explanation:

This option formats cells according to some rules and highlight cells with different colours.

What are the advantages offered by mail merge option in Ms-Word?

  1. Letters can be reused again and again.

  2. Once the merge has been set up, thousands of letters can be produced very quickly.

  3. Easy to make a change to a single letter and for that change to happen in every letter.

  4. The same data source can be reused to reduce the risk of errors.

  5. All of the above


Correct Option: E
Explanation:

All the above options are benefits offered by mail-merge.

Which symbol is used in Ms-Excel to perform absolute addressing?

  1. %

  2. @

  3. #

  4. $

  5. &


Correct Option: D
Explanation:

The dollar symbol is used in excel work sheets to perform absolute addressing.

What are the two addressing techniques used in Excel work sheets?

  1. Absolute addressing

  2. Relative addressing

  3. Explicit addressing

  4. Both absolute and relative addressing

  5. Implicit addressing


Correct Option: D
Explanation:

Yes, both absolute and relative addressing modes are used in Excel.

Which feature of Ms-Word enables the users to search words from a group of words?

  1. Thesaurus

  2. Tools

  3. Spelling

  4. Dictionary

  5. None of these


Correct Option: A
Explanation:

Thesaurus provides related words which is available in the word database.

What is/are the significance of Auto fit option in the table created in Ms-Word 2007?

  1. It provides various methods to adjust the data in the table.

  2. Table does not provide Auto fit option in the Word 2007.

  3. Using Auto fit option user can adjust the data by size of content, fixed column width or by size of window.

  4. Both 1 and 3 are correct.

  5. Data in the table can be adjusted by using the cell alignment.


Correct Option: D
Explanation:

Both the options explain the feature of Auto fit behaviour.

- Hide questions