IBPS Clerk Exam 2014: Check your computer prowess with our mock test

Question 1 of 10

1

1. If you wished to limit what you would see on an Excel worksheet, what data function would you use?

Select one of the following:

Sort
Filter
Conditional format
Data analysis
None of these

Explanation

Question 2 of 10

1

2. If you wished to highlight, not hide, some information in a worksheet because it met some criteria, what Excel tool would you use?

Select one of the following:

Table
Format
Conditional Format
Filter
None of these

Explanation

Question 3 of 10

1

3. What Excel tool allows you to create quickly and automatically summary data from a large data set?

Select one of the following:

Conditional formatting
Sorting
Pivot tables
Field lists
None of these

Explanation

Question 4 of 10

1

4. When creating a custom filer in Excel, which of the following would not be considered a Boolean operator?

Select one of the following:

If
And
Or
Not
None of these

Explanation

Question 5 of 10

1

5. What database key uniquely identifies a record within a table?

Select one of the following:

Primary key
Foreign key
Secondary key
Relational key
None of these

Explanation

Question 6 of 10

1

6. What database key links one table to another?

Select one of the following:

Primary key
Foreign key
Secondary key
Relational key
None of these

Explanation

Question 7 of 10

1

7. What do you create when you need to pose a question to the database?

Select one of the following:

Inquiry
Rule
Question
Query
None of these

Explanation

Question 8 of 10

1

8. Debugging tools are there to debug errors in

Select one of the following:

printers
keyboards
programs
language
None of these

Explanation

Question 9 of 10

1

9. It converts accepted instructions into machine language:

Select one of the following:

input unit
output unit
processing unit
memory unit
None of these

Explanation

Question 10 of 10

1

10. An operation in which data is moved to a different location is referred as

Select one of the following:

Block move
Street move
Delete
All of the above
None of these

	Created by walletwatchteam about 10 years ago

MockBank, a group of experts who carefully create mock tests specific to each competitive examination, have come up with sample questions regarding Computer Knowledge for IBPS Clerical Exam 2014.

IBPS Clerk Exam 2014: Check your computer prowess with our mock test

Question 1 of 10

1. If you wished to limit what you would see on an Excel worksheet, what data function would you use?

Select one of the following:

Explanation

Question 2 of 10

2. If you wished to highlight, not hide, some information in a worksheet because it met some criteria, what Excel tool would you use?

Select one of the following:

Explanation

Question 3 of 10

3. What Excel tool allows you to create quickly and automatically summary data from a large data set?

Select one of the following:

Explanation

Question 4 of 10

4. When creating a custom filer in Excel, which of the following would not be considered a Boolean operator?

Select one of the following:

Explanation

Question 5 of 10

5. What database key uniquely identifies a record within a table?

Select one of the following:

Explanation

Question 6 of 10

6. What database key links one table to another?

Select one of the following:

Explanation

Question 7 of 10

7. What do you create when you need to pose a question to the database?

Select one of the following:

Explanation

Question 8 of 10

8. Debugging tools are there to debug errors in

Select one of the following:

Explanation

Question 9 of 10

9. It converts accepted instructions into machine language:

Select one of the following:

Explanation

Question 10 of 10

10. An operation in which data is moved to a different location is referred as

Select one of the following:

Explanation