Expand the term VBA  .....[Visual Basic for Applications ]

Shortcut key for spelling check is .........   [   F7  ] 

Microsoft® Access is a  ...........  Application   [Relational database ]

e primary interface through which the users of the database enter data is called ...[ Form]

..........is an Email software program by Microsoft that enables users to send and receive e-mail on their computer.it also includes a calendar, task manager, contact manager, note taking, journal, and web browsing        [  Outlook]

............is a digital notebook for organizing your notes from multiple users online  [  Microsoft OneNote ]

Every power pint  presentation is made up of a series of pages called  ........ [ slides]  

..........is a full-featured word processing program for writing and editing text documents in MS office  [ Microsoft Word]

Typing Speed is measured in ...................., commonly used in typing test examination and recruitment   [  Words Per Minute (WPM)]

..............information is information that is known only within the business and is not publically available.  [   Confidential ] 

Without...........no one can be a good typist.   [   practice ]

This bar comprises the words in the document, total number of pages, language, and so on  [Status Bar ]

.......view displays pages exactly as they will appear when printed.   [Print layout view ]

Ms-Word has two rulers .......... and ....... [ horizontal and vertical ruler   ]

Data entry is the most powerful tool for managing information in any.............. [ business] 


What is the estimated contribution of the BPM sub-sector to India’s GDP by 2020 according to NASSCOM?

A) Up to 5%   B) Up to 9%    C) Up to 15%   D) Up to 20%      Answer: B) Up to 9%

Which parameter is NOT used to categorize organizations within the IT-BPM Industry?

A) Sector the organization is serving       B) Type of technology used by the organization

C) Geographic spread of operations    D) Revenues and size of operations

Answer: B) Type of technology used by the organization

Which sub-sector within the IT BPM industry has generated revenues of USD19 Billion in FY2013?

A) IT Services (ITS)     B) Engineering and R&D (ER&D)    C) Business Process Management (BPM)   D) Software Products (SPD)

Answer: C) Business Process Management (BPM)

What is one of the key trends identified in the BPM subsector?

A) Decreasing use of social media for CRM  B) Reduced focus on knowledge services specialization

C) Emergence of big data   D) Decline in locational advantage

Answer: C) Emergence of big data

How many Employment opportunities is the BPM sub-sector estimated to provide by 2020?

A) 10 million    B) 20 million  C) 30 million  D) 40 million

Answer: C) 30 million

Which sub-sector within the IT BPM industry is potentially pegged as a USD65 billion industry by 2020?

A) IT Services (ITS)    B) Business Process Management (BPM)

C) Engineering and R&D (ER&D)  D) Software Products (SPD)

Answer: B) Business Process Management (BPM)

What characterized the First Generation of computers in terms of technology?

A) Use of transistors  B) Introduction of integrated circuits

C) Utilization of vacuum tubes  D) Development of microprocessors

Answer: C) Utilization of vacuum tubes

Which computer is an example of the Second Generation?

A) IBM System/360     B) Apple II  C) UNIVAC 1108  D) DEC PDP-8

Answer: C) UNIVAC 1108

 What major technological advancement occurred during the Third Generation of computers?

A) Introduction of microprocessors  B) Use of vacuum tubes

C) Development of integrated circuits  D) Implementation of transistors

Answer: C) Development of integrated circuits

Which generation saw the creation of personal computers and microcomputers?

A) First Generation  B) Second Generation  C) Third Generation  D) Fourth Generation

Answer: D) Fourth Generation

What characterizes the Fifth Generation of computers?

A) Introduction of vacuum tubes  B) Development of microprocessors

C) Rise of smartphones and tablets D) Use of transistors

Answer: C) Rise of smartphones and tablets

What does RAM stand for in computer terminologies?

A) Random Access Memory  B) Read-Only Memory

C) Rapid Access Memory  D) Randomized Allocation Memory

Answer: A) Random Access Memory

Which device provides permanent storage for data even when the computer is powered off?

A) CPU  B) RAM   C) Hard Drive  D) Operating System

Answer: C) Hard Drive

What is the function of an Operating System in a computer system?

A) Executes instructions

B) Provides temporary storage

C) Manages computer hardware and provides a user interface

D) Stores data permanently

Answer: C) Manages computer hardware and provides a user interface

What component serves as the brain of the computer responsible for executing instructions?

A) RAM   B) Hard Drive  C) CPU   D) Input Devices

Answer: C) CPU

Which type of computer is designed for complex scientific and engineering tasks?

A) Personal Computers (PCs)  B) Supercomputers

C) Mainframe Computers  D) Workstations

Answer: B) Supercomputers

What is a key advantage of computers in terms of data processing compared to humans?

A) Increased Efficiency

B) Social Isolation

C) Security Risks

D) Environmental Impact

Answer: A) Increased Efficiency

Which subsector within the IT-BPM industry focuses on tasks like graphic design and video editing?

A) IT Services (ITS)

B) Business Process Management (BPM)

C) Engineering and R&D (ER&D)

D) Software Products (SPD)

Answer: C) Engineering and R&D (ER&D)


What are the four main sub-sectors within the IT BPM industry?

A) IT Services, Business Process Management, Engineering and R&D, Software Products

B) IT Solutions, Business Process Outsourcing, Research and Development, Software Development

C) IT Consulting, Business Process Automation, Engineering Design, Software Testing

D) IT Support, Business Process Optimization, Research and Design, Software Maintenance

Answer: A) IT Services, Business Process Management, Engineering and R&D, Software Products

Which trend is NOT associated with the BPM subsector?

A) Verticalization

B) Emergence of big data

C) Continued locational advantage

D) Increasing use of social media and internet for CRM

Answer: D) Increasing use of social media and internet for CRM


What parameter categorizes organizations within the IT-BPM Industry based on their sector served?

A) Type as well as range of offering

B) Geographic spread of operations

C) Revenues and size of operations

D) Sector served

Answer: D) Sector served

Which generation saw the introduction of microprocessors in computers?

A) First Generation

B) Second Generation

C) Third Generation

D) Fourth Generation

Answer: D) Fourth Generation

What is the function of Input Devices in a computer system?

A) Stores data temporarily

B) Provides permanent storage

C) Facilitates communication between the computer and the user

D) Executes instructions

Answer: C) Facilitates communication between the computer and the user

Which type of computer is intended for individual use?

A) Supercomputers

B) Mainframe Computers

C) Personal Computers (PCs)

D) Workstations

Answer: C) Personal Computers (PCs)

What does CPU stand for in computer terminologies?

A) Central Processing Unit

B) Random Access Memory

C) Hard Drive

D) Operating System

Answer: A) Central Processing Unit

Which component connects and controls all other components in a computer system?

A) CPU

B) RAM

C) Motherboard

D) Storage

Answer: C) Motherboard

Which disadvantage is associated with over-reliance on computers?

A) Increased Efficiency

B) Dependency issues if they malfunction or fail

C) Automation benefits

D) Storage capabilities

Answer: B) Dependency issues if they malfunction or fail

What type of computers are embedded in devices like smartphones and household appliances?

A) Supercomputers

B) Mainframe Computers

C) Personal Computers (PCs)

D) Embedded Computers

Answer: D) Embedded Computers


What is the first step in effective time management according to the text?

A) Setting long-term goals

B) Defining urgency of tasks

C) Creating a detailed schedule

D) Seeking feedback from peers

Answer: B) Defining urgency of tasks

How does prioritization contribute to efficiency in time management?

A) By focusing on trivial activities

B) By allocating resources randomly

C) By increasing productivity on key tasks

D) By avoiding planning altogether

Answer: C) By increasing productivity on key tasks

Why is defining importance crucial in time management?

A) To delay important tasks for later

B) To understand the value of each task

C) To ignore long-term goals

D) To increase stress levels

Answer: B) To understand the value of each task

What is a benefit of breaking down larger tasks into smaller steps?

A) Decreasing efficiency

B) Making tasks more overwhelming

C) Increasing achievability

D) Avoiding planning tools

Answer: C) Increasing achievability

How does monitoring performance help in achieving goals?

A) By ignoring feedback mechanisms

B) By avoiding self-assessment

C) By staying on track and making progress

D) By not establishing KPIs

Answer: C) By staying on track and making progress

Which tool or technique can help organize and track tasks effectively?

A) Ignoring deadlines

B) Using productivity tools like to-do lists

C) Avoiding time blocking

D) Not breaking down tasks into smaller steps

Answer: B) Using productivity tools like to-do lists

Why is adaptability important in time management?

A) To stick rigidly to plans

B) To avoid adjusting priorities

C) To anticipate challenges and adjust schedules

D) To increase stress levels

Answer: C) To anticipate challenges and adjust schedules

How does prioritizing based on importance align with goals?

A) By focusing on trivial activities only

B) By working towards significant objectives

C) By avoiding stress reduction techniques

D) By not optimizing resources effectively

Answer: B) By working towards significant objectives

What role do KPIs play in monitoring performance effectively?

A) They hinder progress tracking

B) They provide objective measures of progress

C) They are irrelevant in time management

D) They increase stress levels

Answer: B) They provide objective measures of progress

How does effective planning help reduce stress levels?

A) By creating chaos and confusion in schedules

B) By providing a clear roadmap of tasks to be done

C) By avoiding resource optimization strategies

D) By not anticipating potential challenges

Answer: B) By providing a clear roadmap of tasks to be done

What is the purpose of regular check-ins in monitoring performance?

A) To avoid evaluating progress regularly

B) To assess adherence to the plan and goal achievement

C) To ignore feedback from supervisors and mentors

D) To decrease self-awareness in performance tracking

Answer: B) To assess adherence to the plan and goal achievement

How does defining urgency differ from defining importance in time management?

A) Urgency focuses on long-term goals, while importance focuses on short-term goals.

B) Urgency refers to immediate attention, while importance relates to value.

C) Urgency involves trivial tasks, while importance involves significant activities.

D) Urgency leads to stress reduction, while importance increases stress levels.

Answer: B) Urgency refers to immediate attention, while importance relates to value.

Why is seeking feedback from peers important in monitoring performance?

A) To avoid gaining insights for improvement

B) To maintain a stagnant approach to tasks

C) To identify areas where improvement is needed

D) To decrease adaptability in planning strategies

Answer: C) To identify areas where improvement is needed

How does resource optimization contribute to productivity in time management?

A) By allocating resources randomly without prioritization

B) By focusing on trivial tasks for extended periods

C) By allocating time, effort, and attention to high-priority tasks

D) By avoiding adaptability and flexibility in planning

Answer: C) By allocating time, effort, and attention to high-priority tasks

What is the significance of adaptability when monitoring performance?

A) To stick rigidly to initial plans without adjustments

B) To anticipate challenges and adjust strategies accordingly

C) To avoid seeking feedback from mentors or supervisors

D) To increase stress levels by resisting change

Answer: B) To anticipate challenges and adjust strategies accordingly

How does operationalizing the plan contribute to effective time management?

A) By avoiding breaking down larger tasks into smaller steps

B) By not allocating specific time slots for each task

C) By creating a detailed action plan based on priorities

D) By ignoring the use of productivity tools or techniques

Answer: C) By creating a detailed action plan based on priorities



What is the shortcut key to paste content from the clipboard in Windows?

a) Ctrl + V

Which of the following is an example of an output device?

c) Monitor

What does HTML stand for?

b) Hyper Text Markup Language

Which of the following file extensions represents a spreadsheet file?

b) .xlsx

What is the function of the CTRL + Z shortcut key?

b) Undo

In Microsoft Excel, what function would you use to find the highest value in a range of cells?

a) MAX

What does CSV stand for?

a) Comma-Separated Values

Which of the following is a data validation technique?

d) Data verification

What is the purpose of a pivot table in Excel?

c) To summarize and analyze data

What is the correct sequence of steps to sort data in Microsoft Excel?

b) Select data range, choose sorting options, click on the Sort button

What does “F” mean on the F1, F2, F3, F4, etc. keyboard keys?

d) Function

You have completed the worksheet and want to make certain that you have not made spelling or grammar errors. Which button will you select?

c) C

Which software is commonly used for data entry tasks?

b) Microsoft Excel

What does the term “data validation” refer to in the context of data entry?

d) Validating user input against specified criteria

Which keyboard shortcut is used to copy selected data?

a) Ctrl + C

What is the purpose of using filters in spreadsheet programs like Microsoft Excel?

c) To organize and manipulate data

The part of a computer that coordinates all its functions is called

d) Control unit

A computer cannot boot if it does not have the

c) Operating System

A right-click on the desktop itself will?

b) Show a context-sensitive menu

By default, MS-PowerPoint 365 presentations are saved with which of the following extensions?

C) .pptx

Weight refers to _________.

d) The print density of characters

When you are typing an equation into a cell the first thing that must be entered is _________.

d) An equal sign

You can copy data or formulas _________.

b) All of these

Test Which of the following options is not available in Insert >> Picture?

c) Graph

When you see a cell with a red triangle in the top right corner, what does this signify?

c) There is a comment associated with the cell

Which command be used to ask you to confirm that you want to delete the directory?

b) Del ./p

Which command is used to delete all the files with extension .txt on the current drive and directory?

b) Del .txt

When you use the fill effects in the format data series dialog box, you cannot _________.

c) Rotate text on the chart

When you want to insert a blank embedded excel object in a Word document, you can _________.

b) Click the object command on the insert menu

Which of the following is not an option in the spelling dialog box?

a) Edit

The accounting style shows negative numbers in _________.

c) Parentheses

To select a column, the easiest method is to _________.

c) Click the column heading

A _________ is a group of cells that form a rectangle on the screen.

d) Range

What is the main advantage of networking?

c) All of these

You cannot close MS Word application by _________.

c) Click X button on title bar

State whether true of false about both statements -i) A worm mails a copy of itself to other systems. ii) A worm executes a copy of itself on another system.

a) False, True

Which command is used to see the version?

c) Ver

Which switch should be used in the DIR command to view files in all directories?

a) /s

which command is used to copy all files with extension .txt into one file named all.txt?

b) Copy *.txt all.txt

Excel uses the _________ Function when creating a data table.

b) Table

What is one of the factors that has contributed to the growth of the IT/ITeS industry in India?

c) Increasing globalization

Which government initiative in India focuses on transforming the country into a digitally empowered society?

b) Digital India

What is one key aspect of the Make in India initiative by the Indian government?

b) Promote local manufacturing

What is a key responsibility of data entry operators in terms of confidentiality and data security?

d) Following privacy policies, access restrictions, and confidentiality agreements

What is a crucial aspect of troubleshooting errors for data entry operators?

d) Identifying the source of the error and correcting inaccuracies

Question 1 Topic: MS Excel Questions
Weight refers to _________.

a) The height of the printed character
b) The design and appearance of characters
c) Upright or slanted shape
d) The print density of characters

Question 2 Topic: MS Excel Questions
When you are typing an equation into a cell the first thing that must be entered is _________.

a) Parenthesis
b) The first cell referenced
c) Quotation marks
d) An equal sign

Question 3 Topic: MS Excel Questions
You can copy data or formulas _________.

Question 4 Topic: Data Entry MS Word
Test Which of the following options is not available in Insert >> Picture?

a) Chart
b) Clip Art
c) Graph
d) Word Art

Question 5 Topic: MS Excel Questions
When you see a cell with a red triangle in the top right corner, what does this signify?

a) The font color for text in the cell is red
b) A formula cannot be entered into the cell
c) There is a comment associated with the cell
d) There is an error in the cell

Question 6 Topic: MS DOS Practice Questions
Which command be used to ask you to confirm that you want to delete the directory?

a) Erase .
b) Del ./p
c) Deltree
d) Deltree/f

Question 7 Topic: MS DOS Practice Questions
Which command is used to delete all the files with extension .txt on the current drive and directory?

a) Erase .txt
b) Del .txt
c) Del ./p
d) Del *.txt

Question 8 Topic: MS Excel Questions
When you use the fill effects in the format data series dialog box, you cannot _________.

a) Select a foreground color
b) Select a background color
c) Rotate text on the chart
d) Select a pattern

Question 9 Topic: MS Excel Questions
When you want to insert a blank embedded excel object in a Word document, you can _________.

a) Click the office links button on the standard toolbar
b) Click the object command on the insert menu
c) Click the create worksheet button on the formatting toolbar
d) Click the import excel command on the file menu

Question 10 Topic: MS Excel Questions
Which of the following is not an option in the spelling dialog box?

a) Edit
b) Change
c) Ignore all
d) Ignore

Question 11 Topic: MS Excel Questions
The accounting style shows negative numbers in _________.

a) Bold
b) Quotes
c) Parentheses
d) Brackets

Question 12 Topic: MS Excel Questions
 To select a column, the easiest method is to _________.

a) Drag from the top cell in the column to the last cell in the column
b) Double click any cell in the column
c) Click the column label
d) Click the column heading

Question 13 Topic: MS Excel Questions
A _________ is a group of cells that form a rectangle on the screen.

a) Range address
b) Calculation
c) Formula
d) Range

Question 14 Topic: Internet Practice Test
What is the main advantage of networking?

a) Sharing of data
b) Sharing of peripherals
c) All of these
d) Interactive data transfer

Question 15 Topic: Data Entry MS Word Test
 You cannot close MS Word application by _________.

a) Press Alt+F4
b) Choosing File menu then Exit submenu
c) Click X button on title bar
d) From File menu choose Close submenu

Question 16 Topic: Internet Practice Test
State whether true of false about both statements -i) A worm mails a copy of itself to other systems. ii) A worm executes a copy of itself on another system.

a) False, True
b) False, False
c) True, False
d) True, True

Question 17 Topic: MS DOS Practice Questions
Which command is used to see the version?

a) None of above
b) Version
c) Ver
d) Verson

Question 18 Topic: MS DOS Practice Questions
Which switch should be used in the DIR command to view files in all directories?

a) /s
b) /l
c) /p
d) /w

Question 19 Topic: MS DOS Practice Questions While working with MS-DOS,
 which command is used to copy all files with extension .txt into one file named all.txt?

a) Copy *.txt a:
b) Copy *.txt all.txt
c) Copy a: *.txt
d) Copy *.txt c:

Question 20 Topic: MS Excel Questions
Excel uses the _________ Function when creating a data table.

a) Sum
b) Table
c) Average
d) Count

Question 21 Topic: Introduction
What is one of the factors that has contributed to the growth of the IT/ITeS industry in India?

Question 22 Topic: Introduction
Which government initiative in India focuses on transforming the country into a digitally empowered society?

Question 23 Topic: Introduction
What is one key aspect of the Make in India initiative by the Indian government?

Question 24 Topic: Undertake Data Entry Services
What is a key responsibility of data entry operators in terms of confidentiality and data security?