INTRODUCTION TO COMPUTER
Define Data
Raw facts and figures that have no meaning until processed.
State one function of an operating system.
Manages computer hardware resources.
Define disk partitioning
Dividing a physical hard disk into separate logical sections.
– Define word processor
A software application used to create, edit, format, and print text documents
– Define columns, rows, and cells.
Column = vertical arrangement (A, B, C…).
Row = horizontal arrangement (1, 2, 3…).
Cell= intersection of row and column
Differentiate between data processing and information.
Data processing is the manipulation of data into a meaningful form, while information is the processed, meaningful and organized output.
Explain the function of authenticity in software purchase.
Ensures the software is original and not pirated.
State two purposes of the recycle bin.
Stores deleted files temporarily; allows restoration of deleted files.
Give two examples of word processing software.
MS Word, Google Docs.
Write a formula to calculate the total for a row of sales (e.g., Rexona).
=SUM(B4:E4).
Explain what is meant by computer booting
The process of starting up a computer and loading the operating system into memory.
Explain the function of portability in software purchase.
the ability of software to run on different computer systems
Give three advantages and one disadvantage of laser printers over inkjet printers.
Advantages:Faster printing, higher quality, lower cost per page.
Disadvantage: Expensive to purchase
Name four document formatting features.
Bold, italics, font size, alignment.
Write the formula for the maximum sales in Region 2.
=MAX(C4:C8).
List four parts that make up a computer.
Input devices, output devices, central processing unit (CPU), storage devices.
State three functions of an operating system.
1. File management.
2. Resource allocation.
3. User interface management.
List three factors to consider when buying an output device.
Cost, compatibility, speed/quality of output.
Explain find & replace and undo & redo.
Find & Replace -locates text and substitutes it.
Undo & Redo -reverses or restores recent actions.
Write the function that returns the number of sales ≥ 2000.
=COUNTIF(B4:E8, ">=2000").
Explain three ways computers can make an office more efficient.
1. Faster document preparation and editing.
2. Easy communication via email and networks.
3. Efficient storage and retrieval of records.
List and explain three functional elements of a computer system.
1. Input – for data entry (e.g., keyboard).
2. Processing – CPU executes instructions.
3. Output – displays results (e.g., monitor, printer).
What is meant by warranty when purchasing a computer?
A written guarantee that the computer will be repaired or replaced if it fails within a specified period.
Explain thesaurus and autocorrect
Thesaurus suggests synonyms/antonyms.
Autocorrect automatically fixes typing/spelling errors.
If =SUM(B4:E4) is copied to cell F8, what does the new formula become?
=SUM(B8:E8)