Class 10 Half Yearly Sample Paper 2025 - Spreadsheet

Class 10 Half Yearly Sample Paper 2025

Class 10 Half Yearly Sample Paper 2025

INFORMATION TECHNOLOGY (Subject Code 402)

Section A: Objective Type Questions

1. Fill in the blanks:

(a) ____________ tool is used to test different values and assumptions in spreadsheets.
Answer: Scenario

(b) To arrange data in ascending or descending order, we use ____________ option.
Answer: Sort

(c) ____________ is an advanced tool in spreadsheets used for optimization problems.
Answer: Solver

(d) ____________ tool is used to find the input value required to achieve a specific target result.
Answer: Goal Seek

(e) The active cell in a spreadsheet has a ____________ border.
Answer: Bold

2. State True or False:

(a) Styles help in maintaining consistency in documents. → True

(b) Templates cannot be modified once created. → False

(c) Macros can automate repetitive tasks. → True

(d) In spreadsheets, consolidation is used to split a worksheet into parts. → False

(e) In spreadsheets, data can be linked between sheets. → True

Section B: Subjective Type Questions

3. Worksheet Problem: Consider a worksheet where a student wants to predict target marks in Computer Science. Pass percentage is 33% (B4), maximum marks 75 (B5), target 75% (B6), and actual marks obtained 50 (B7).

(a) To calculate percentage of marks obtained (B8):
Formula: =B7/B5*100

(b) Tool used to find what marks are needed to reach 75% target:
Goal Seek

(c) What-if analysis tables:

Table 1 — MARKS CALCULATION USING WHAT-IF ANALYSIS

ItemValueAlternative marksPercentage of alternate marks
Pass Percentage ►331013.33
Maximum Marks ►752533.33
Target Percentage ►754560.00
Marks Obtained ►506080.00
Percentage ►66.677093.33

Table 2 — MARKS CALCULATION USING WHAT-IF ANALYSIS (multiple formulas)

ItemLess marks than targetAlternative marksPercentage of alternate marksDifference from obtained
Pass Percentage ►1013.33-40
Maximum Marks ►2533.33-25
Target Percentage ►4560.00-5
Marks Obtained ►6080.00+10
Percentage ►257093.33+20

Formula corrections:
- Column D (Percentage) → =C2/$B$5*100
- Column E (Difference) → =C2-$B$7

Comments

Post a Comment

Popular posts from this blog

Communication Skill

Interactive Guide to Communication Skills Communication Skills Home The Process Effective Communication Challenges Grammar Essentials Exercises Our Team Home The Process Effective Communication Challenges Grammar Essentials Exercises Our Team Welcome to the Interactive Guide to Communication This guide transforms the key concepts of communication into an interactive experience. Explore the communication process, discover principles for effecti...
Read more

Class IX - Sample Test I - (Q&A)

SUNRISE PUBLIC SCHOOL - IT Periodic Test Sample Set 3 (2025-26) SUNRISE PUBLIC SCHOOL, BHUBANESWAR-03 PERIODIC TEST - SAMPLE SET 3 (2025-26) CLASS-X (QA) | INFORMATION TECHNOLOGY (402) TIME:- 1hr. 30 Mins. | FULL MARKS:- 40 A. Multiple Choice Question [Each Question carries 1 mark] (10 Marks) 1. Which of the following is NOT an element of communication? a. Sender b. Receiver c. Tree d. Message 2. Which type of communication uses signs, symbols, and pictures? a. Verbal communication b. Non-verbal communication c. Visual communication d. Written communication 3. The ability to regulate one's emotions, thoughts, and behavior is known ...
Read more

Class 9 - Chapter - 7 - Introduction to IT-ITES Industry

Image
Introduction to IT-ITES Industry Introduction to IT-ITES Industry Explanation, Notes, Examples, and Practical Uses Introduction to IT-ITES Industry This unit introduces students to the vast world of Information Technology (IT) and Information Technology Enabled Services (IT-eS), highlighting their significance in modern life and various industries. Theory: Appreciating the Application of IT and IT-eS Industry 1. Introduction to IT and IT-eS, BPO Services, BPM Industry in India Information Technology (IT) IT refers to the use of computers, storage, networking, and other physical devices, infrastructure, and processes to create, process, store, secure, and exchange all forms of electronic data. In simpler terms, it's about using technology to manage inf...
Read more