Information Technology Questions And Answers for Competitive Exams

1. The pair of files used to produce merged letters during a mail merge is?
1. Primary document and data source
2. Primary document and merged letters
3. Data source and merged letters
4. Primary document and current letter

2. Text entered into a spreadsheet is aligned towards the left by default. These entries are called
1. values
2. labels
3. formulae
4. functions

3. Which of the following formatting features is unique to numbers in spreadsheet?
1. Bold
2. Custom
3. Italics
4. Indent

4. To center the title rows of a spreadsheet across the column
1. Center align the title rows
2. Center align the title columns
3. Merge and center the title rows
4. Merge and center the title columns

5. Formulae in a spreadsheet involve
1. Cell addresses, values and labels
2. Cell addresses, values and mathematical operators
3. Cell addresses and labels
4. Cell addresses and values

6. Which of the following statements is NOT true of primary keys?
1. They do not contain blank value
2. They are unique identifiers
3. They are always in text form
4. They may be composed of one or more attributes

7. The shortcut key that can be used to activate or open the find and replace screen is
1. CtrlG
2. CtrlH
3. AltG
4. AltH

8. Footers are found at the ……………..of a document.
1. Bottom of every page
2. Top of every page
3. End of a page
4. end

9. Susan is using the ‘Find and Replace’ feature of a word processing tool, to search for the word “DELL”, in a document that she is typing. Which word or words can be found if she has the “Match case’ option disabled?
1. dell
2. Dell
3. DELL
4. DeLL
5. All of the above

10. The following words could be found in the document that Susan typed

1. sad
2. set
3. star
4. street

11. Software piracy involves………………
1. The authorized copying, use or selling of software that is copyrighted.
2. The authorized copying, use or selling of software that is not copyrighted.
3. The unauthorized copying, use or selling of software that is copyrighted.
4. The unauthorized copying, use or selling of software that is not copyrighted.

12. The purpose of the icon Σ is to
1. Move data to the clipboard
2. Insert a sum formula on the worksheet
3. Access the chart wizard
4. Provide on-screen help

13. A field in a table appears as a match of the primary key in another table is called a
1. Candidate key
2. Secondary key
3. Foreign key
4. Composite key

14. Given the following algorithm

1. 10
2. 11
3. 13
4. 14

15. The following variables s, t and u have been assigned the values shown

1. U>7 and T <=7
2. S< T or U < S – 2
3. U – 2 >= 1
4. T <> 4 or s = 5

16. Which of the following algorithms satisfies the requirement of asking the user to input two numbers, calculate the average and displaying the result
1. Display ‘Enter two numbers’

2. Input a, b

3.  Display ‘Enter two numbers’

4. Input a, b