ARMY PUBLIC SCHOOL
BATHINDA MILITARY STATION
COMPUTER SCIENCE HOLIDAY HOMEWORK
(SESSION: 2025-26)
CLASS: VII
TOPIC: Number System and Advance Excel: Charts
Questions:
1. What is the base of the binary number system?
2. Convert the binary number 1011 into decimal form.
3. Write the decimal equivalent of 11001.
4. Convert 25 into binary.
5. Perform the binary addition: 1010 + 1101.
6. What are the only two digits used in the binary number system?
7. Convert the binary number 100100 to decimal.
8. Perform binary subtraction: 1110 - 101.
9. Represent the decimal number 45 in binary.
10. Explain the significance of the binary number system in computing.
11. What do you mean by base value?
12. Define in 2 lines: binary, Decimal, octal and Hexadecimal numbers.
Charts in Excel - Q&A Worksheet
Name: ___________
Class: ___________
Date: ___________
Questions & Answers:
1. What is a chart in Excel?
A chart is a graphical representation of data that helps to visualize patterns and trends.
2. Name any three types of charts available in Excel.
Bar Chart, Pie Chart, Line Chart.
3. What is the purpose of using charts in Excel?
Charts make it easier to analyze and compare data visually instead of looking at numbers in a table.
4. Which chart type is best suited for representing trends over time?
A Line Chart is best for showing trends over time.
5. What are the main components of a chart in Excel?
Chart Title, Axis (X and Y), Legend, Data Series, Gridlines.
6. How can you insert a chart in Excel?
Select your data → Click on the ‘Insert’ tab → Choose the ‘Chart’ type.
7. What does the "Legend" in a chart represent?
The legend helps to identify different data series in the chart by using colors or symbols.
8. Explain the difference between a Bar Chart and a Column Chart.
A Bar Chart represents data using horizontal bars, while a Column Chart uses vertical bars.
9. How can you change the chart type after inserting a chart?
Click on the chart → Go to ‘Chart Design’ → Select ‘Change Chart Type’ and choose a new one.
10. What is a Pie Chart, and when should it be used?
A Pie Chart shows data as slices of a circle, used when comparing proportions of a whole.
11. Define the term Data Series in the context of an Excel chart.
A Data Series is the group of values plotted on a chart that represent a single category.
12. How can you edit the title of a chart in Excel?
Click on the Chart Title → Type the new title or edit it.
13. What is the use of Axis Titles in a chart?
Axis Titles describe what each axis represents in the chart (e.g., Months, Sales figures).
14. How can you format a chart in Excel to make it more visually appealing?
You can change colors, add labels, adjust font size, and apply different styles from the ‘Chart Design’ tab.
15. Why is it important to choose the right chart type for your data?
Choosing the right chart type helps in better data representation and easier understanding of trends.
COMPARISON OF CHARTS IN EXCEL
Chart Type Description Best Used For Example Usage
Column Sales comparison across different
Displays data using vertical bars. Comparing data across categories.
Chart months.
Comparing multiple values where Survey results with lengthy category
Bar Chart Uses horizontal bars instead of vertical ones.
labels are long. names.
Line Chart Connects data points with a continuous line. Showing trends over time. Temperature changes over a year.
Showing proportions or percentages Budget distribution among different
Pie Chart Represents data as slices of a circle.
of a whole. departments.
Doughnut Displaying multiple data series in a Comparing product revenue from
Similar to a pie chart but with a hole in the center.
Chart circular format. different brands.
Showing relationships or correlations Comparing height vs. weight for a
Scatter Chart Plots data points on a coordinate grid.
between variables. group of students.
Similar to a line chart but fills the area below the Showing trends while emphasizing
Area Chart Visualizing total rainfall over months.
line. volume.
A scatter chart with an additional data dimension Showing relationships between three Comparing company revenue, profit,
Bubble Chart
represented by bubble size. variables. and employee count.
Displays data as lines radiating from a central Comparing multiple categories on a Analyzing skill levels in different areas
Radar Chart
point. single scale. for an employee.
Charts in Excel - Question Paper
Name: ___________
Class: ___________
Date: ___________
Instructions:
All questions are compulsory.
Marks are indicated next to each question.
Section A - Multiple Choice Questions (MCQs) (1 mark each)
1. Which chart type is best suited for showing trends over time?
a. Pie Chart
b. Line Chart
c. Column Chart
d. Bar Chart
2. In a Pie Chart, what does each slice represent?
a. Categories
b. Values
c. Percentage of a whole
d. Axis Titles
3. What component of a chart helps to identify different data series?
a. Gridlines
b. Legend
c. Axis Titles
d. Chart Area
4. Which of the following charts is best for comparing multiple categories using vertical bars?
a. Bar Chart
b. Column Chart
c. Doughnut Chart
d. Scatter Chart
5. What does the X-axis generally represent in a chart?
a. Labels or Categories
b. Data Values
c. Chart Title
d. Gridlines
Section B - Short Answer Questions (2 marks each)
6. What is the purpose of using charts in Excel?
7. Name any four types of charts available in Excel.
8. Explain the difference between a Bar Chart and a Column Chart.
9. How can you insert a chart in Excel?
10. What is a Pie Chart used for?
Section C - Long Answer Questions (3 marks each)
11. Define the major components of a chart in Excel.
12. How can you change the chart type after inserting a chart? Explain step-by-step.
13. Why is it important to choose the right chart type for data representation?
14. Describe how formatting a chart improves its readability and effectiveness.
15. Create a simple data table and explain which chart type would be best to visualize it.
This question paper covers different aspects of Charts in Excel, including conceptual understanding and practical application. Let me know if
you’d like any modifications! 😊
Here are the answers to the Charts in Excel worksheet:
Section A - Multiple Choice Questions (MCQs)
1. b) Line Chart
2. c) Percentage of a whole
3. b) Legend
4. b) Column Chart
5. a) Labels or Categories
Section B - Short Answer Questions
6. Purpose of using charts in Excel: Charts help visualize data, making it easier to analyze trends and comparisons.
7. Four types of charts in Excel: Column Chart, Bar Chart, Pie Chart, Line Chart.
8. Difference between Bar Chart and Column Chart: A Bar Chart uses horizontal bars, while a Column Chart uses vertical bars to represent data.
9. Steps to insert a chart in Excel: Select data → Click ‘Insert’ tab → Choose ‘Chart’ type → Click ‘OK’.
10. Use of Pie Chart: A Pie Chart is used to represent proportions of a whole, showing how different categories contribute to a total.
Section C - Long Answer Questions
11. Major components of a chart: Chart Title, Axis (X and Y), Legend, Data Series, Gridlines.
12. Changing chart type: Click on the chart → Go to ‘Chart Design’ → Select ‘Change Chart Type’ → Choose a new chart type → Click ‘OK’.
13. Importance of choosing the right chart type: The correct chart type ensures clear data representation, making analysis easier and more effective.
14. Formatting a chart for better readability: Adjust colors, add labels, change font size, and apply different styles to enhance clarity.
15. Example data table and best chart type: If you have monthly sales data, a Line Chart would be best to show trends over time.
Let me know if you need further explanations or modifications! 😊
Sure! Here's a Question Paper with Answers on the Computer Number System for Class 6 students.
Computer Number System - Question Paper
Name: ___________
Class: ___________
Date: ___________
Instructions:
All questions are compulsory.
Marks are indicated next to each question.
Section A - Multiple Choice Questions (MCQs) (1 mark each)
1. What is the base of the Binary Number System?
a. 2
b. 8
c. 10
d. 16
2. Which number system uses digits 0 to 9 only?
a. Binary
b. Decimal
c. Octal
d. Hexadecimal
3. What does the Hexadecimal Number System include?
a. Numbers from 0 to 9 only
b. Letters from A to G
c. Numbers from 0 to 9 and letters from A to F
d. Only odd numbers
4. How many bits make 1 byte?
a. 4
b. 8
c. 16
d. 32
5. What is the binary equivalent of decimal number 5?
a. 100
b. 101
c. 110
d. 111
Section B - Short Answer Questions (2 marks each)
6. Define a computer number system.
7. Name and define the four types of number systems used in computers.
8. Convert 1101₂ into decimal.
9. Convert 25₁₀ into binary.
10. What is the difference between Binary and Decimal Number Systems?
Section C - Long Answer Questions (5 marks each)
11. Explain the importance of number systems in computers.
12. Convert 78₁₀ into Octal and Binary number systems.
13. Perform the following binary addition: 1011 + 1101.
Answers
Section A - Multiple Choice Questions (MCQs)
1. a) 2
2. b) Decimal
3. c) Numbers from 0 to 9 and letters from A to F
4. b) 8
5. b) 101
Section B - Short Answer Questions
6. Computer Number System: A set of rules for representing numbers in different formats using specific symbols or digits.
7. Types of Number Systems:
o Binary (Base 2) – Uses 0 and 1, fundamental in computing.
o Decimal (Base 10) – Uses digits 0 to 9, commonly used by humans.
o Octal (Base 8) – Uses digits 0 to 7, a compact way to represent binary numbers.
o Hexadecimal (Base 16) – Uses digits 0 to 9 and letters A to F, used in programming and color coding.
8. 1101₂ = 1 × 2³ + 1 × 2² + 0 × 2¹ + 1 × 2⁰ = 13₁₀
9. 25₁₀ into Binary: 11001₂
10. Binary vs. Decimal:
o Binary uses only 0 and 1, whereas Decimal uses digits 0 to 9.
o Computers process instructions using Binary, while humans commonly use Decimal.
Section C - Long Answer Questions
11. Importance of Number Systems:
o Essential for storing, processing, and computing data.
o Used in programming, digital communication, and error detection.
o Enables correct interpretation of numbers in computing.
12. Binary to Decimal Conversion Example:
o Convert 1010₂ → 1 × 2³ + 0 × 2² + 1 × 2¹ + 0 × 2⁰ = 10₁₀
13. Conversions:
o 78₁₀ to Octal: 116₈
o 78₁₀ to Binary: 1001110₂
14. Advantages of Hexadecimal:
o Easier to understand than long binary strings.
o Used in memory addressing and digital encoding.
o Saves space when representing large binary numbers.
15. Binary Addition:
o 1011₂ + 1101₂ = 11000₂
This question paper covers Computer Number Systems in an engaging way for Class 6 students. Let me know if you'd like any modifications!
😊
