UNIT 1

1. What is the primary function of a computer?

- A) To generate power
- B) To accept data, process it, and produce output
- C) To store physical documents
- D) To communicate with other computers
Answer: B) To accept data, process it, and produce output

2. Which of the following best describes data?

- A) Processed and meaningful information
- B) Organized facts and figures
- C) Unstructured facts and figures
- D) A collection of programs
Answer: C) Unstructured facts and figures

3. What is the role of the CPU in a computer system?

- A) To store data permanently
- B) To process instructions and data
- C) To connect to the internet
- D) To provide power to the computer
-Answer:B) To process instructions and data

4. Which component is NOT typically part of a computer system?

- A) Input devices
- B) Output devices
- C) GPS unit
- D) Storage devices
Answer: C) GPS unit
5. What is one of the main advantages of computers in terms of speed?
- A) They slow down over time
- B) They can process tasks in seconds
- C) They require constant supervision
- D) They only work during business hours
Answer: B) They can process tasks in seconds

6. Which of the following is a disadvantage of using computers?

- A) Increased productivity
- B) Health issues from prolonged use
- C) High storage capacity
- D) High accuracy
Answer: B) Health issues from prolonged use

7. What type of computer is designed for individual use and typically includes a
microprocessor?
- A) Supercomputer
- B) Mainframe
- C) Personal computer
- D) Minicomputer
Answer: C) Personal computer

8. Which of the following computers is best suited for complex mathematical

calculations and scientific simulations?
- A) Minicomputer
- B) Workstation
- C) Mainframe
- D) Supercomputer
Answer: D) Supercomputer
9. In business applications, what does CRM stand for?
- A) Customer Resource Management
- B) Customer Relationship Management
- C) Corporate Resource Management
- D) Corporate Relationship Management
Answer: B) Customer Relationship Management

10. Which of the following is a primary function of accounting software?

- A) To create graphics
- B) To process payroll
- C) To improve internet speed
- D) To design websites
Answer: B) To process payroll

11. What is a significant characteristic of a supercomputer?

- A) Supports only a few users
- B) Low power consumption
- C) Executes many programs concurrently
- D) Performs hundreds of millions of instructions per second
Answer: D) Performs hundreds of millions of instructions per second

12.Which function does NOT typically fall under the applications of computers
in business?
- A) Document processing
- B) Inventory management
- C) Cooking recipes
- D) Sales analysis
Answer: C) Cooking recipes
13. What is one of the major health issues associated with prolonged computer
use?
- A) Improved eyesight
- B) Back pain
- C) Increased productivity
- D) Enhanced memory
Answer: B) Back pain

14. Which of the following is NOT a characteristic of computers?

- A) Versatility
- B) Fatigue
- C) Speed
- D) Accuracy
-Answer:B) Fatigue

15. What type of computer is typically used for engineering applications and
has high-quality graphics capabilities?
- A) Personal computer
- B) Workstation
- C) Minicomputer
- D) Mainframe
Answer: B) Workstation
16. What is e-waste?
- A) Electronic devices that enhance productivity
- B) Discarded computers and electronic devices
- C) Renewable energy sources
- D) Internet-based software
Answer: B) Discarded computers and electronic devices
17. Which type of computer can support hundreds of users simultaneously?
- A) Personal computer
- B) Supercomputer
- C) Mainframe
- D) Workstation
Answer:C) Mainframe

18. What is the primary benefit of automation in computing?

- A) Increased costs
- B) Reduced efficiency
- C) Consistency and reliability in repetitive tasks
- D) Increased manual labor
Answer: C) Consistency and reliability in repetitive tasks

19.Which of the following best describes the term "versatility" in relation to

computers?
- A) Limited to one specific task
- B) Ability to perform a wide range of tasks
- C) Requires constant updates
- D) Only suitable for gaming
Answer: B) Ability to perform a wide range of tasks
20. What is one of the key applications of computers in logistics and supply
chain management?
- A) Cooking meals
- B) Creating artwork
- C) Tracking shipments
- D) Playing games
Answer: C) Tracking shipments
21. What does "hardware" refer to in a computer system?
- A) Software applications
- B) Physical components
- C) Network connections
- D) User data
Answer: B) Physical components

22. Which of the following is an example of firmware?

- A) Microsoft Word
- B) BIOS/UEFI
- C) Windows OS
- D) Adobe Photoshop
Answer: B) BIOS/UEFI

23. What does "liveware" represent in computing?

- A) Hardware components
- B) Firmware updates
- C) Users interacting with systems
- D) Software applications
Answer: C) Users interacting with systems

24. Which of the following is NOT a function of an operating system?

- A) Process management
- B) Data encryption
- C) Application design
- D) Device management
Answer: C) Application design
25.What is the primary purpose of a compiler?
- A) Execute high-level code line-by-line
- B) Translate high-level code into machine code
- C) Load programs into memory
- D) Manage user input
Answer: B) Translate high-level code into machine code

26. Which type of processing requires ongoing communication between the user
and the system?
- A) Batch processing
- B) Multi-tasking
- C) Interactive processing
- D) Multi-user processing
Answer:C) Interactive processing

27. What is the main characteristic of tailor-made software?

- A) Pre-developed for general use
- B) Custom-built for specific needs
- C) Free and open-source
- D) Requires no user input
Answer: B) Custom-built for specific needs

28. Which of the following is an example of application software?

- A) Device drivers
- B) Microsoft Excel
- C) BIOS firmware
- D) Operating system kernels
Answer: B) Microsoft Excel
29. In multi-programming, how does the operating system manage tasks?
- A) By executing one program at a time
- B) By switching jobs based on priority
- C) By batch processing all jobs together
- D) By distributing tasks among multiple CPUs
Answer: B) By switching jobs based on priority

30. What is a characteristic of general-purpose packaged software?

- A) Customized for specific organizations
- B) Readily available and cost-effective
- C) Always open-source
- D) Requires extensive user training
Answer: B) Readily available and cost-effective
UNIT 2
1. What is the primary purpose of Microsoft Office?
- A) Gaming
- B) Business productivity
- C) Web design
- D) Graphic design
Answer: B) Business productivity

2. Which of the following is NOT a core application of Microsoft Office?

- A) Word
- B) Excel
- C) Photoshop
- D) PowerPoint
Answer: C) Photoshop

3.What type of software is MS Word primarily considered?

- A) Spreadsheet software
- B) Word processing software
- C) Database management software
- D) Presentation software
Answer: B) Word processing software

4. Which feature in MS Word helps you track changes made to a document?

- A) Spell Check
- B) Track Changes
- C) Quick Access Toolbar
- D) Mail Merge
Answer: B) Track Changes
5. What is the function of the Ribbon in MS Word?
- A) To save documents
- B) To organize commands and tools
- C) To format text
- D) To print documents
Answer: B) To organize commands and tools

6. In MS Word, which tab would you use to insert a table?

- A) Home
- B) Insert
- C) Design
- D) Layout
Answer: B) Insert

7. What does Mail Merge allow you to do?

- A) Save documents as PDFs
- B) Create multiple personalized documents
- C) Format text in different styles
- D) Insert hyperlinks
Answer: B) Create multiple personalized documents

8. How can you protect a Word document with a password?

- A) Go to File > Info > Protect Document > Encrypt with Password
- B) Use the Home tab
- C) Save the document as a PDF
- D) Use the Review tab
Answer: A) Go to File > Info > Protect Document > Encrypt with Password
9. Which of the following is a feature of OLE security?
- A) Automatic formatting
- B) Object Isolation
- C) Spell Check
- D) Mail Merge
Answer: B) Object Isolation

10. What is a macro in MS Word?

- A) A type of document format
- B) A recorded sequence of actions
- C) A tool for spell checking
- D) A method for inserting images
Answer: B) A recorded sequence of actions

11. What does the Status Bar in MS Word display?

- A) Document formatting options
- B) Page numbers and word count
- C) Available templates
- D) Recent documents
Answer: B) Page numbers and word count

12. To create a hyperlink in MS Word, you need to:

- A) Click on the Home tab
- B) Insert a table
- C) Right-click the text and select Hyperlink
- D) Use the Ruler Bar
Answer: C) Right-click the text and select Hyperlink**
13. Which of the following is NOT a valid file format for saving documents in
MS Word?
- A) .docx
- B) .pdf
- C) .html
- D) .jpg
Answer: D) .jpg

14. What feature in Word helps to automate repetitive tasks?

- A) Mail Merge
- B) Quick Access Toolbar
- C) Macros
- D) Spell Check
Answer: C) Macros

15. Which referencing style is commonly used in social sciences?

- A) APA
- B) MLA
- C) Chicago
- D) Harvard
Answer: A) APA

16. How do you insert a table in MS Word?

- A) Click on the Home tab
- B) Go to Insert > Table
- C) Use the Ruler Bar
- D) Right-click in the document
Answer: B) Go to Insert > Table
17. What is the purpose of the 'References' tab in MS Word?
- A) To format text
- B) To manage citations and sources
- C) To insert images
- D) To print documents
Answer: B) To manage citations and sources

18. Which of the following allows you to link objects rather than embed them in
a Word document?
- A) Macros
- B) OLE
- C) Mail Merge
- D) Spell Check
Answer: B) OLE

19. What is a bibliography?

- A) A list of all sources cited in a document
- B) A summary of the document's content
- C) A tool for spell checking
- D) A feature for formatting text
Answer: A) A list of all sources cited in a document

20.Why is it important to check for viruses in macros?

- A) Macros can be used to format text
- B) Macros may contain harmful code
- C) Macros are always safe
- D) Macros improve document formatting
Answer: B) Macros may contain harmful cod
UNIT 3
1. What is a PowerPoint presentation primarily used for?
- A) Writing documents
- B) Creating spreadsheets
- C) Presenting information interactively
- D) Editing photos
Answer: C) Presenting information interactively

2. Which option should you select to start a presentation from scratch in

PowerPoint?
- A) New Template
- B) Blank Presentation
- C) Existing Presentation
- D) Create Tour
Answer: B) Blank Presentation

3. What is a slide in PowerPoint?

- A) A video
- B) A single page of a presentation
- C) A graph
- D) A background
Answer: B) A single page of a presentation

4. How do you add a new slide after an existing one?

- A) Right-click the existing slide and select Add Slide
- B) In the Home tab, select New Slide
- C) Press Ctrl + N
- D) Click on the Insert tab
Answer: B) In the Home tab, select New Slide
5. To delete multiple slides at once, you must:
- A) Click and delete each slide individually
- B) Hold Ctrl and select the slides, then right-click and choose Delete
- C) Use the Delete key on the keyboard
- D) Right-click the slide deck and select Delete
Answer: B) Hold Ctrl and select the slides, then right-click and choose Delete

6. What does the Handout Master allow you to edit?

- A) Slide animations
- B) Slide layouts
- C) Handout appearance and layout
- D) Speaker notes
Answer: C) Handout appearance and layout

7. How can you view your speaker notes while presenting in Google Slides?
- A) By clicking on the slide
- B) By using Presenter view
- C) By printing the notes
- D) By selecting Slide Show mode
Answer: B) By using Presenter view

8. What does Outline View show?

- A) Only images in the presentation
- B) The text in your presentation arranged as an outline
- C) Speaker notes for each slide
- D) The design templates available
Answer: B) The text in your presentation arranged as an outline
9. Which option allows you to insert a video from your PC?
- A) Home tab
- B) Insert tab
- C) View tab
- D) Design tab
Answer:B) Insert tab

10. What should you do to preview a video in PowerPoint?

- A) Click the video and use the Play/Pause button
- B) Right-click the video and select Preview
- C) Press the Spacebar
- D) Double-click the video
Answer: A) Click the video and use the Play/Pause button

11. To create a chart in PowerPoint, you should go to:

- A) Insert > SmartArt
- B) Insert > Chart
- C) Home > Charts
- D) Design > Chart
Answer: B) Insert > Chart

12. Which category of transitions is the most basic?

- A) Exciting
- B) Dynamic Content
- C) Subtle
- D) Advanced
Answer: C) Subtle
13. What are animation effects used for in PowerPoint?
- A) Changing slide layouts
- B) Capturing attention with movement
- C) Adjusting video sizes
- D) Creating charts
Answer: B) Capturing attention with movement

14. How can you insert SmartArt graphics in your presentation?

- A) From the Design tab
- B) From the Insert tab
- C) From the Home tab
- D) From the View tab
Answer: B) From the Insert tab

15. What are action buttons used for in PowerPoint?

- A) To add text
- B) To connect to webpages or files
- C) To create charts
- D) To change slide backgrounds
Answer: B) To connect to webpages or files

16. To set the timing for slides in a presentation, you must access:
- A) Slide Show tab
- B) Transitions tab
- C) Review tab
- D) Home tab
Answer: B) Transitions tab
17. What happens when you click "Collapse All" in Outline View?
- A) All slides are deleted
- B) All headings and subheadings collapse
- C) All animations are removed
- D) The presentation closes
Answer: B) All headings and subheadings collapse

18. To resize a video while maintaining its aspect ratio, you should use:
- A) Side sizing handles
- B) Corner sizing handles
- C) The Format tab
- D) The Play/Pause button
Answer: B) Corner sizing handles

19. Dynamic transitions are best used when:

- A) You want to change the background color
- B) Transitioning between similar slide layouts
- C) You have many slides
- D) You want to animate text
Answer: B) Transitioning between similar slide layouts

20. What is the primary benefit of using speaker notes during a presentation?
- A) They serve as the main content of the slides
- B) They help you remember what to say
- C) They can be printed for the audience
- D) They provide background music
Answer: B) They help you remember what to say
UNIT 4
1. What is a spreadsheet primarily designed to hold?
- A) Images
- B) Numerical data and short text strings
- C) Video files
- D) Audio files
Answer: B

2. Which shortcut key can be used to create a new workbook in Excel?

- A) Ctrl+N
- B) Ctrl+O
- C) Ctrl+S
- D) Ctrl+C
Answer: A

3. Which function would you use to find the smallest number in a range?
- A) MAX
- B) MIN
- C) AVERAGE
- D) SUM
Answer: B

4. What does the SUMIF function do?

- A) Counts cells that meet criteria
- B) Calculates average based on criteria
- C) Adds cells specified by a given condition
- D) Filters data
Answer: C
5.Which of the following is a type of chart best for showing trends over time?
- A) Pie Chart
- B) Bar Chart
- C) Line Chart
- D) Scatter Plot
Answer: C

6. What is the formula for calculating Net Present Value (NPV)?

- A) PV - Cash Flows
- B) Cash Inflows - Cash Outflows
- C) Present Value of cash inflows - Present Value of cash outflows
- D) Cash Inflows + Cash Outflows
Answer: C

7. What does the COUNT function do in Excel?

- A) Counts all cells
- B) Counts only numeric cells
- C) Counts non-empty cells
- D) Counts cells with text
Answer: B

8. Which function calculates the average of a range of numbers?

- A) SUM
- B) AVERAGE
- C) COUNT
- D) MAX
Answer: B
9. What does the term 'EMI' stand for?
- A) Equal Monthly Interest
- B) Equated Monthly Installment
- C) Estimated Monthly Income
- D) Emergency Money Installment
Answer: B

10. What is required for filtering data in Excel?

- A) Select a cell within the range of data
- B) Use the Data tab and select Filter
- C) Both A and B
- D) None of the above
Answer: C

11. Which function would you use to calculate the maximum value in a dataset?
- A) MIN
- B) MAX
- C) AVERAGE
- D) SUM
Answer: B

12. In which scenario would you use the AVERAGEIF function?

- A) To count cells
- B) To add numbers
- C) To calculate the average of cells that meet specific criteria
- D) To find the minimum value
Answer: C
13. What does the term 'Future Value' (FV) refer to?
- A) Current worth of an asset
- B) Value of a current asset at a future date
- C) Total cash inflow
- D) Cash flow over time
Answer: B

14. What happens to your EMI if you increase the loan tenure?
- A) It increases
- B) It decreases
- C) It remains the same
- D) It doubles
Answer: B

15. Which of the following is NOT a type of chart available in Excel?

- A) Bar Chart
- B) Line Chart
- C) Text Chart
- D) Pie Chart
Answer: C

16. What does the AVERAGE function do?

- A) Finds the total of a set of numbers
- B) Finds the middle number in a set
- C) Calculates the mean of a set of numbers
- D) Counts the number of entries
Answer: C
17. To dynamically link a chart to data in Excel, you should:
- A) Use static ranges
- B) Use dynamic ranges
- C) Use text labels
- D) None of the above
Answer: B

18. What is the main benefit of consolidating data from multiple worksheets?
- A) It complicates data analysis
- B) It eliminates the need for calculations
- C) It streamlines data analysis and enhances collaboration
- D) It reduces the number of worksheets
Answer: C

19. Which of the following factors does NOT affect the EMI amount?
- A) Loan tenure
- B) Rate of interest
- C) Loan repayment method
- D) Amount of loan
**Answer: C**

20. The formula to calculate EMI is:

- A) EMI = P x R x N
- B) EMI = [P x R x (1+R) ^ N]/ [(1+R) ^ (N-1)]
- C) EMI = P + R
- D) EMI = P / N
Answer: B