ICT Revision MCQ Series 7. Electronic Spreadsheet

ICT Revision MCQ Series – Master Your Knowledge with Interactive Questions

Introduction In today’s fast-paced learning environment, multiple-choice questions (MCQs) have become a powerful tool for quick revision and self-assessment. Our Revision MCQ Series is designed to help students reinforce their understanding of key concepts through well-structured MCQs.

/25

ICT Revision MCQ Series 7. Electronic Spreadsheet

This quiz assesses your knowledge of Grade 10 ICT lessons and serves as a revision test for your O/L examination preparation. It helps reinforce key concepts and improve your understanding of important ICT topics.

Perfect for:

• Sri Lankan OL ICT students revising core concepts.
• Building a strong foundation for exams and practical applications.

Good luck! 🖥️📊

1 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

Which of the following is NOT a type of computer classification?

Mainframe

Mini

Analog

Hybridization

Computers are classified as mainframe, mini, digital, analog, or hybrid, but "hybridization" is not a valid classification.

2 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

Which of the following is NOT a benefit of ICT in national development?

Improved communication

Increased unemployment

Enhanced education

Better healthcare

ICT generally reduces unemployment by creating new job opportunities and improving efficiency.

3 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

Which of the following is NOT a component of a computer system?

Input devices

Output devices

Entertainment devices

Storage devices

Entertainment devices are not a core component of a computer system.

4 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

Which of the following is NOT a benefit of using spreadsheets?

Easy data organization

Automatic video editing

Built-in calculation functions

Data visualization tools

Spreadsheets are not designed for video editing but excel at organizing data, performing calculations, and visualizing data.

5 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

Match the following spreadsheet functions with their purposes:

(a-1, b-2, c-3, d-4)

(a-2, b-1, c-4, d-3)

(a-3, b-4, c-1, d-2)

(a-4, b-3, c-2, d-1)

SUM adds numbers, AVERAGE calculates the mean, MAX finds the highest value, and MIN finds the lowest value.

6 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

ICT is used in various sectors. In education, it enables ___________ learning. In business, it facilitates communication through ___________. In healthcare, it manages patient records with ___________. For government services, it improves citizen access via ___________.

physical, meetings, paper, queues

remote, email, databases, websites

traditional, memos, filing cabinets, offices

classroom, phones, folders, counters

ICT enables remote learning, email communication, database management, and online government services.

7 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

A company wants to calculate the total sales for the year. Which function should they use in a spreadsheet?

SUM

AVERAGE

MAX

COUNT

The SUM function adds up values, making it ideal for calculating total sales.

8 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

What formula should be used to find the highest score in Science (cell C8)?

0

#DIV/0!

0

0

The MAX function identifies the highest value in the range C2 to C6, which represents the Science scores of all students.

9 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

Which of the following is NOT a function of a computer system?

Input

Processing

Entertainment

Output

Entertainment is not a core function of a computer system.

10 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

Which of the following statements about the evolution of computers is FALSE?

First-generation computers were large and consumed significant power.

Transistors replaced vacuum tubes in the second generation.

Integrated circuits were introduced in the fourth generation.

Microprocessors improved speed and efficiency in the fourth generation.

Integrated circuits were introduced in the third generation, not the fourth.

11 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

Which of the following statements about spreadsheets are true?

Spreadsheets allow users to perform calculations using formulas.

Spreadsheets cannot store data in tables.

Spreadsheets support formatting options like font size and alignment.

Spreadsheets are primarily used for creating presentations.

Spreadsheets allow calculations, support formatting, and store data in tables but are not primarily used for presentations.

12 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

Which of the following best describes the role of ICT in e-government?

Reducing transparency

Enhancing citizen access to services

Increasing paperwork

Limiting communication

E-government uses ICT to provide citizens with easier access to government services.

13 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

Which of the following is NOT a valid operator in spreadsheet calculations?

+

-

*

@

Common operators in spreadsheets include addition (+), subtraction (-), multiplication (*), and division (/). The "@" symbol is not a valid operator.

14 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

Which of the following is NOT a characteristic of data?

Raw facts

Processed information

Unorganized

Input material

Data refers to raw, unprocessed facts, while processed information is the output.

15 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

A system that converts raw data into meaningful information is called a(n):

Information system

Data processor

Communication network

Storage device

An information system processes raw data into meaningful information using input, processing, and output components.

16 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

To find the lowest score in English (cell D9), which formula should be used?

0

#DIV/0!

0

0

The MIN function identifies the lowest value in the range D2 to D6, which represents the English scores of all students.

17 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

What formula should be used to calculate the total marks for John (cell E2)?

1

1

1

1

The SUM function adds up all the values in the range B2 to D2, which represents John's scores in Math, Science, and English.

18 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

Which of the following is NOT a basic feature of a spreadsheet?

Worksheet

Columns and rows

Animation tools

Cells

Spreadsheets are designed for data entry, calculations, and analysis, not for animation tools.

19 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

Which of the following is NOT a characteristic of a good information system?

Accuracy

Complexity

Timeliness

Relevance

A good information system should be simple and user-friendly, not overly complex.

20 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

Which formula calculates the class average for Math scores (cell B7)?

1.2

1.2

2

5

The AVERAGE function calculates the mean of the values in the range B2 to B6, which represents the Math scores of all students.

21 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

Match the following ICT benefits with their descriptions:

(a-3, b-2, c-1, d-4)

(a-1, b-3, c-4, d-2)

(a-2, b-4, c-3, d-1)

(a-4, b-1, c-2, d-3)

Efficiency reduces resource usage, accuracy ensures error-free results, speed enables faster processing, and scalability allows growth.

22 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

Which of the following is NOT a feature of modern ICT systems?

High-speed processing

Manual operation

Large storage capacity

Network connectivity

Modern ICT systems are automated and do not rely on manual operation.

23 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

How can you count the number of students in the table (cell B10)?

5010

1002

5

1004

The COUNT function counts the number of non-empty cells in the range A2 to A6, which corresponds to the number of students listed in the table.

24 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

Match the following spreadsheet components with their descriptions:

(a-1, b-2, c-3, d-4)

(a-2, b-1, c-4, d-3)

(a-3, b-4, c-1, d-2)

(a-4, b-3, c-2, d-1)

A worksheet is a single page, a cell is the intersection of a row and column, rows are horizontal, and columns are vertical.

25 / 25

Category: Revision MCQ OL Grade 10 Lesion 7

Select Your Preferred Language 😊 

What is the correct sequence of steps to create a chart in a spreadsheet?

Select data, choose chart type, customize options, insert chart

Choose chart type, select data, customize options, insert chart

Customize options, select data, choose chart type, insert chart

Insert chart, select data, choose chart type, customize options

The logical sequence is to first select the data, then choose the chart type, customize options, and finally insert the chart.

Your score is

0%

Restart quiz

7. Uses Spreadsheet to Solve Simple Statistical Problems

• 7.1 Explores a Spreadsheet to identify its basic features and functions.
  • Introduction to spreadsheets
  • GUI of spreadsheet software
• 7.2 Moves around the worksheet to gain hands-on experience of data entry.
  • Worksheet, columns, rows, and cells
  • Moving around worksheet, Data entry (label, number, formulae)
• 7.3 Performs basic mathematical operations.
  • Simple calculations using values and operators (+, -, *, /, ^)
  • Simple calculations using cell addresses and operators (+, -, *, /, ^)
• 7.4 Uses inbuilt functions for calculations.
  • SUM, AVERAGE, MAX, MIN, COUNT
• 7.5 Formats a worksheet.
  • Font, Font size, Boldface, Italic, etc.
  • Alignment (center, left, right, justify), Decimal places (increase and decrease)
• 7.6 Uses relative versus absolute cell references appropriately.
  • Absolute and Relative cell references
• 7.7 Creates charts using Spreadsheet to explain data.
  • Charts: Chart type, Chart options
  • Chart types: Bar, Column, Line, Pie

Why Use MCQs for Learning?

MCQs are a great way to evaluate your understanding of a subject in a structured manner. Here’s why they are effective:

• Quick and Efficient – MCQs allow for rapid assessment of knowledge.
• Engaging and Interactive – They keep learning interesting and encourage active participation.
• Memory Retention – Answering questions enhances recall and reinforces concepts.
• Instant Feedback – You can immediately check your answers and improve your understanding.

Tips MCQ-Based Exams

To score well in MCQ exams, follow these strategies:

1. Understand the Concepts – Don’t just memorize answers; understand the logic behind them.
2. Eliminate Wrong Options – Narrow down choices by eliminating incorrect answers.
3. Time Management – Avoid spending too much time on one question.
4. Practice Regularly – Consistent practice improves accuracy and speed.
5. Read Carefully – Pay attention to tricky words like not, always, and except.

Conclusion

The Revision MCQ Series is your go-to resource for mastering concepts efficiently. Keep practicing with Lesson 1 questions and stay tuned for upcoming lessons. Your success starts with consistent revision and smart study techniques!

FAQs

1. How can MCQs help in learning? MCQs improve retention, provide quick assessment, and make learning engaging.

2. Can I find more lessons in this series? Yes! We regularly update the Revision MCQ Series with new lessons. Stay tuned!

3. How should I prepare for MCQ-based exams? Understand concepts, practice regularly, manage time well, and eliminate wrong answers.

4. Where can I access more MCQs? You can find additional MCQs on our website or in upcoming blog posts.

5. Is this MCQ series suitable for all students? Yes! Whether you’re a beg