Login / Register
Follow Us
0
0
Register Free!
Register Free!
Online Mock Tests & Exam Preparation | Target Exams
Select Medium:
🇬🇧 English Medium Active 🇮🇳 বাংলা মাধ্যম 🇮🇳 हिन्दी माध्यम
West Bengal Board (WBBSE) Class 10 (Madhyamik) Information Technology Set 01 (Foundation Level) English Medium 100% Free Practice Test

West Bengal Board (WBBSE) Class 10 (Madhyamik) Information Technology: Electronic Spreadsheet (Advanced) Online Test (Set 01 (Foundation Level))

Electronic Spreadsheet (Advanced) — Set 01 (Foundation Level)

Practise free online CBT mock test for West Bengal Board (WBBSE) Class 10 (Madhyamik) Information Technology Chapter 2 'Electronic Spreadsheet (Advanced)'. 20 MCQs, 20-minute timer, instant scorecard, and step-by-step solutions aligned with official board syllabus.

📝
20 MCQs
Questions
⏱️
20 Mins
Duration
🎯
20 Marks
Total Marks
➕
+1.0
Per Correct
🛡️
0.0
Negative Mark
🌐
English
Language
Start Test Now (English Medium)
Instant Scorecard Step-by-Step Solutions WBBSE Madhyamik Blueprint

Chapter Study Guide & In-Depth Notes

Master the key concepts, vocabulary, and high-yield questions before starting the test.

3 Sections

Chapter Overview & Core Concepts: Electronic Spreadsheet (Advanced)

Class 10 Study Guide

Mastering Electronic Spreadsheet (Advanced) in Class 10 provides critical subject intuition, analytical skills, and examination readiness.

Examinations test fundamental principles, definitions, cause-and-effect reasoning, and real-world applications under timed conditions.

Core Moral & Key Takeaway:

Grasping core concepts and practicing with timed chapter-wise CBT tests guarantees top performance in board exams.

Key Terminology, Definitions & Principles

Glossary & Concepts
Term / Formula Type Definition / Meaning Explanation / Notes Example / Usage
Core Concept Principle Primary concept governing Electronic Spreadsheet (Advanced). मुख्य सिद्धांत "Understand and apply the principle accurately."
Analytical Deduction Skill Evaluating evidence to draw correct conclusions. तार्किक विश्लेषण "Examine question clues systematically."

Key Features & Devices Explored:

Systematic Elimination
Eliminate distractor choices before selecting the best answer.
Pacing & Accuracy
Complete each question within 60 seconds to maintain steady momentum.

High-Yield Revision Points & Solved Board Exam Q&A

Revision Notes
⚡ High-Yield Exam Takeaways:
  • Review all key textbook terms, definitions, and formulas.
  • Pay attention to units, boundary values, and key keywords in questions.
  • Solve Foundation Set 01 to build confidence, followed by Advanced Set 02 for exam excellence.
Frequently Asked Questions & Model Answers:
Q1 How should students prepare for Electronic Spreadsheet (Advanced) exams?
Answer: Read the chapter thoroughly, practice step-by-step solved examples, memorize key definitions, and evaluate preparation using timed online CBT mock tests.

Sample Questions Preview

Free Sneak Peek

Here is a sneak peek of the questions included in this test set. Test your preparation by viewing the answer and detailed explanation before starting the timed exam.

Q1
In spreadsheet applications (LibreOffice Calc
স্প্রেডশীট অ্যাপ্লিকেশনগুলিতে (LibreOffice Calc
स्प्रेडशीट अनुप्रयोगों में (लिबरऑफिस कैल्क
A
Translating sheet text into another languageশীট পাঠ্যকে অন্য ভাষায় অনুবাদ করা হচ্ছেशीट टेक्स्ट का दूसरी भाषा में अनुवाद करना
B
Deleting empty columns in a sheetএকটি শীটে খালি কলাম মুছে ফেলা হচ্ছেकिसी शीट में खाली कॉलम हटाना
C
Encrypting the sheet with a biometric signatureএকটি বায়োমেট্রিক স্বাক্ষর সহ শীট এনক্রিপ্ট করাबायोमेट्रिक हस्ताक्षर के साथ शीट को एन्क्रिप्ट करना
D
Combining and summarizing data from multiple sheets or ranges into a single unified summary sheetএকক ইউনিফাইড সারাংশ শীটে একাধিক শীট বা রেঞ্জ থেকে ডেটা একত্রিত করা এবং সংক্ষিপ্ত করাएकाधिक शीटों या श्रेणियों से डेटा को एक एकीकृत सारांश शीट में संयोजित और सारांशित करना
Correct Answer: Option D
Explanation:
Data Consolidation aggregates data from multiple source ranges (e.g., quarterly sales sheets) and applies mathematical summary functions like SUM or AVERAGE.
ডেটা একত্রীকরণ একাধিক সোর্স রেঞ্জ (যেমন, ত্রৈমাসিক বিক্রয় পত্রক) থেকে ডেটা একত্রিত করে এবং SUM বা AVERAGE এর মত গাণিতিক সারাংশ ফাংশন প্রয়োগ করে।
डेटा समेकन कई स्रोत श्रेणियों (उदाहरण के लिए, त्रैमासिक बिक्री पत्रक) से डेटा एकत्र करता है और SUM या AVERAGE जैसे गणितीय सारांश फ़ंक्शन लागू करता है।
Q2
Which default mathematical function is applied in the Data Consolidation tool?
ডেটা একত্রীকরণ টুলে কোন ডিফল্ট গাণিতিক ফাংশন প্রয়োগ করা হয়?
डेटा समेकन उपकरण में कौन सा डिफ़ॉल्ट गणितीय फ़ंक्शन लागू होता है?
A
COUNTगिनती करना
B
AVERAGEগড়औसत
C
MAXमैक्स
D
SUMजोड़
Correct Answer: Option D
Explanation:
The default aggregation function in the Consolidate dialog is SUM, though other functions like AVERAGE, MIN, and MAX can also be selected.
একত্রীকরণ ডায়ালগে ডিফল্ট একত্রীকরণ ফাংশন হল SUM, যদিও অন্যান্য ফাংশন যেমন AVERAGE, MIN, এবং MAX নির্বাচন করা যেতে পারে।
कंसोलिडेट डायलॉग में डिफ़ॉल्ट एकत्रीकरण फ़ंक्शन SUM है, हालांकि औसत, MIN और MAX जैसे अन्य फ़ंक्शन भी चुने जा सकते हैं।

Ready to attempt all 20 questions in exam environment?

Get real-time countdown timer, question palette navigator, and instant analytics.

How Chapter-Wise Online CBT Tests Build Winning Habits for Future Competitive Exams

Early practice in high school builds the mental muscle, speed, and analytical discipline required to ace NTSE, Olympiads, JNVST, CUET, and Foundation JEE/NEET.

Competitive Edge

Real-Time Clock Awareness & Pacing

समय प्रबंधन एवं गति नियंत्रण

In school examinations, students write answers without active pacing. In national entrance tests, students have barely 45-60 seconds per MCQ. Practicing with a 20-minute timer instills instinctive time-budgeting and prevents last-minute exam panic.

Mastery of the Elimination Technique

विकल्प निष्कासन विधि में दक्षता

Top rankers in competitive exams rarely compute every problem blindly. They spot subtle traps, evaluate extreme values, and eliminate 2 out of 4 distractors within seconds. Our 4-option sets teach critical distractor analysis.

CBT Screen Stamina & Digital Comfort

कंप्यूटर आधारित परीक्षा का सहज अभ्यास

Almost all major national exams (CUET, JEE, NEET, SSC, Banking) are 100% computer-based. Students who only study on paper experience eye strain and navigation mistakes on exam day. Early CBT practice creates effortless digital fluency.

Immunity to Negative Marking

सटीकता और नकारात्मक अंकन से सुरक्षा

Careless errors—such as misreading "NOT" or "EXCEPT"—ruin thousands of competitive aspirations each year. Regular objective testing builds the habit of double-checking question keywords before locking answers.

Instant Diagnostic Feedback Loop

तत्काल त्रुटि निवारण एवं आत्म-मूल्यांकन

Traditional paper tests take weeks to grade, by which time the student has forgotten their thought process. TargetExams provides instant scorecards and step-by-step solutions while the conceptual puzzle is still fresh.

Start Building Your Competitive Edge from Class

Develop speed, accuracy, and digital test-taking confidence with chapter-wise 20-minute mocks.

Syllabus Concepts Evaluated in this Chapter

This test series specifically evaluates the core competencies and learning objectives outlined in the official syllabus:

  • Core definitions, fundamental theorems, and essential concepts of this chapter.
  • Step-by-step mathematical reasoning and deductive problem-solving.
  • Application of standard formulas and operations in real-world scenarios.
  • Critical examination of common exam pitfalls and misleading options.
  • Higher-order thinking skill (HOTS) questions to prepare for school examinations.
  • Speed and accuracy mastery under standard timed CBT exam conditions.

Exam Rules & Test Taking Guidelines

  • Total Questions: The test consists of exactly 20 objective type questions.
  • Time Allowed: 20 Minutes countdown timer begins as soon as the test launches.
  • Marking Scheme: +1.0 mark is awarded for each correct answer.
  • Zero Penalty: There is 0.0 negative marking for incorrect or unattempted questions.
  • Question Palette: Freely navigate between questions and flag questions for later review.
  • Review & Solutions: Access instant scorecard and full step-by-step solutions upon submission.

Frequently Asked Questions (FAQs)

Yes! Foundation Practice Set 01 for every chapter in West Bengal Board (WBBSE) Class 10 (Madhyamik) Information Technology is 100% free to attempt. Students can test their preparation without any subscription or payment.
This test strictly follows the official West Bengal Board (WBBSE) syllabus and curriculum for Class 10 (Madhyamik), covering textbook concepts, formulas, and board-standard MCQs for Chapter 2.
This dedicated test page is conducted in English Medium. If you prefer taking the test in Bengali or Hindi, you can switch using the language switcher bar at the top or toggle languages during the exam.
The test comprises 20 MCQs to be completed in 20 minutes. Each question carries +1.0 mark for a correct response, and there is 0.0 negative marking for incorrect or unattempted questions.
Yes! Instantly after submitting your test, you receive a comprehensive digital scorecard with accuracy analysis, time breakdown, and step-by-step verified explanations for all 20 questions.

Practice Sets in this Chapter

Set 02 (Advanced)

20 MCQs • 20 Mins
Current

Set 02 (Advanced)

20 MCQs • 20 Mins
View

More Chapters in this Subject

🎯 Start Preparation

Begin with this 20-minute practice set to test your conceptual accuracy and prepare for top ranks in your school examinations.

Electronic Spreadsheet (Advanced) (Set 01 (Foundation Level))
20 MCQs • 20 Mins • 100% Free Practice Test

Select Test Language Medium

Choose the language medium you want to attempt this online test in:

বাংলা মাধ্যম (Bengali Medium) WBBSE Official
পশ্চিমবঙ্গ মধ্যশিক্ষা পর্ষদ (WBBSE) পাঠ্যক্রম অনুযায়ী সম্পূর্ণ বাংলা মাধ্যমে পরীক্ষা দিন।
English Medium
Displays questions, options, and explanations in English medium.
हिन्दी माध्यम (Hindi Medium)
प्रश्नों और विकल्पों को हिन्दी माध्यम में प्रदर्शित करेगा।
English + বাংলা (Bilingual Bengali)
Displays questions and options in English & Bengali side-by-side.
English + हिन्दी (Bilingual Hindi)
Displays questions and options in English & Hindi side-by-side.