Prepare for the Class 10 ICT Chapter 1: Digital Literacy Test 3, a comprehensive Full Unit Test designed for students of the Computer Tech Group. This Information and Communication Technology (ICT) test is based on the new syllabus issued by PECTAA Punjab for the Punjab Board Annual Examination 2027. The test is part of our specially designed Class 10 ICT Chapter-Wise Test Series, helping students evaluate their knowledge, practice important questions, strengthen digital literacy concepts, and improve their board examination preparation. Explore more Punjab Board 2027 Model Papers and chapter-wise tests to achieve better academic results.
Information and Communication Technology
Chapter 1: Basic Digital Literacy | Board Standard Paper – Test 3
| Name: ______________________ | Roll No: ____________ | Class: ________ |
| Time: Objective 10 Min | Subjective 1 Hr 45 Min | Total Marks: 40 | |
OBJECTIVETime: 10 Min Marks: 10
| No. | Answer | No. | Answer |
|---|---|---|---|
| 1 | ABCD | 6 | ABCD |
| 2 | ABCD | 7 | ABCD |
| 3 | ABCD | 8 | ABCD |
| 4 | ABCD | 9 | ABCD |
| 5 | ABCD | 10 | ABCD |
NOTE: Four possible answers A, B, C and D are given for each question. Fill the circle of the correct answer with a marker or pen. Cutting or filling two or more circles will score zero in that question.
Q.1: Choose the correct answer. (10 × 1 = 10)
1. The title of a chart:
(A) Shows each axis(B) Explains the colours(C) Tells what the chart is about(D) Adds the numbers
Correct Answer: C
2. To show trends or progress over time, we use a:
(A) Pie chart(B) Table(C) Line chart(D) Bar chart
Correct Answer: C
3. Which chart connects points with lines?
(A) Table(B) Bar chart(C) Line chart(D) Pie chart
Correct Answer: C
4. In MS Excel, which option creates an empty file?
(A) Open(B) Blank Workbook(C) Recent(D) Add a Place
Correct Answer: B
5. A spreadsheet makes work:
(A) Slower and harder(B) Less accurate(C) Faster, neater and more accurate(D) More expensive
Correct Answer: C
6. Columns are:
(A) Formulas(B) Horizontal lines of cells(C) Small pictures(D) Vertical lines of cells
Correct Answer: D
7. Pressing the Enter key moves you to:
(A) The next cell below(B) The last cell of the column(C) The first cell of the row(D) The next cell on the right
Correct Answer: A
8. Arranging data in a specific order is called:
(A) Sorting(B) Charting(C) Filtering(D) Formatting
Correct Answer: A
9. Which key combination opens the Format Cells window?
(A) Ctrl + 5(B) Ctrl + 1(C) Ctrl + Alt + 1(D) Ctrl + F
Correct Answer: B
10. Spreadsheets are used in:
(A) Only in banks(B) Only in hospitals(C) Only in factories(D) Schools, offices and businesses
Correct Answer: D
Page 1 of 2
www.786Times.com | An Education Project in Punjab
Information and Communication Technology
Chapter 1: Basic Digital Literacy | Subjective
Note: It is compulsory to attempt any four (4) parts each from Q.No.2 and Q.No.3, and any two (2) questions from Part II. Write the same question number and part number as given in the question paper.
SUBJECTIVE – PART IMarks: 16
Q.2: Write short answers to any FOUR parts. (4 × 2 = 8)
- Write the use of the functions SUM, AVERAGE, MIN and MAX.
Ans: SUM adds numbers, AVERAGE finds the mean, MIN shows the smallest value and MAX shows the largest value.
- What is a chart? Write one use of charts.
Ans: A chart is a picture that shows data in a clear and easy way. Use: it helps us understand information quickly and compare data instead of reading long tables of numbers.
- Define a cell. Why is it called the smallest unit of a spreadsheet?
Ans: A cell is a small box where we type numbers, words or formulas. It is the smallest unit of a spreadsheet, and every cell has its own address.
- What are custom filters? Write the shortcut key to apply or remove filters.
Ans: Custom filters can be used on multiple columns at the same time to narrow down data efficiently. The shortcut to apply or remove filters is Ctrl + Shift + L.
- Which chart is best to show: (a) marks of five students compared, (b) parts of a household budget, (c) sales over a year?
Ans: (a) Bar chart for comparing values. (b) Pie chart for parts of a total. (c) Line chart for changes over time.
- How can a spreadsheet help in making a budget plan?
Ans: We list all sources of income and all types of expenses. Formulas quickly find total income, total spending and the remaining balance. This helps us understand how we use our money each month.
Q.3: Write short answers to any FOUR parts. (4 × 2 = 8)
- Why are data reports useful? Name two spreadsheet tools that make reports detailed.
Ans: Reports help people understand results quickly and make better decisions. Sorting, filtering and charts make reports detailed and easy to read.
- When do we use a bar chart? Give one example.
Ans: A bar chart shows data using bars of different lengths and is useful for comparing values. Example: comparing the marks of different students.
- Write any two benefits of sorting data.
Ans: 1) It helps us find information easily and see patterns in the data. 2) Sorted data looks more organized and is easier to understand.
- Differentiate between a pie chart and a line chart.
Ans:
Pie chart Line chart Shows data as parts of a circle Connects points with lines Shows how each part contributes to the whole Shows changes over time, such as sales during a year - What is a cell address? Give two examples.
Ans: Every cell has its own address, made by combining its column letter and row number. It tells us exactly where the data is stored. Examples: A1, B2.
- In how many ways can text and numbers be sorted? Write them.
Ans: Text can be sorted from A to Z (alphabetical) or Z to A. Numbers can be sorted from smallest to largest or largest to smallest.
SUBJECTIVE – PART IIMarks: 14
Attempt any TWO questions. (2 × 7 = 14)
Q.4: Explain the importance of adding titles, labels and legends to a chart. How can they be added or changed? (7)
Ans: A chart looks better and is easier to understand when we add titles, labels and legends.
How to add or change them: select the chart, then use the Design tab of the chart tools to change or set the title, labels and legends.
- Title: tells what the chart is about.
- Labels: show what each axis or part represents.
- Legend: explains the colours or symbols used in the chart.
How to add or change them: select the chart, then use the Design tab of the chart tools to change or set the title, labels and legends.
Q.5: What is a spreadsheet? Describe its importance, popular programs and uses. How is a new file created in MS Excel? (7)
Ans: A spreadsheet is a computer program that looks like a large table made of small cells. It helps us store, organize and calculate data, from simple lists to complex mathematical problems. It is like a big digital notebook for organizing numbers and words neatly.
- Importance: it helps people work with numbers and data easily, and makes work faster, neater and more accurate. A single spreadsheet can hold thousands of rows and columns of data.
- Popular programs: Microsoft Excel, Google Sheets and LibreOffice Calc.
- Uses: calculations and data management in schools, offices and businesses, for office work, school projects and personal records.
Q.6: Explain data entry and formatting data in a spreadsheet. Write the related shortcut keys. (7)
Ans:
- Data entry: typing information into the cells of a spreadsheet. We can type numbers, words or formulas, such as student names, marks or prices. Each piece of data should be placed in the correct cell to keep the table organized. Enter moves to the next cell below and Tab moves to the next cell on the right.
- Formatting: changing the look of data to make it neat and attractive. We can change font size, colour and alignment and add borders around cells. Formatting highlights important data such as titles or totals, makes large tables easier to read, and makes the spreadsheet look professional and organized. Colours can separate different types of data, e.g. bold headings and totals in a different colour.
- Shortcut keys: Ctrl + 1 opens the Format Cells window with a preview. Alt + H + O + I AutoFits the selected column. To AutoFit all columns press Ctrl + A and then Alt + H + O + I.
Page 2 of 2
www.786Times.com | An Education Project in Punjab
