Prepare for the Class 10 ICT Chapter 1: Digital Literacy Full Unit Test 1 with our chapter-wise test series for the Computer Science and Entrepreneurship Tech Group. This test is specially designed according to the new syllabus issued by PECTAA Punjab for the Punjab Board Annual Examination 2027. Students can use this Class 10 ICT Chapter 1 test to assess their understanding, improve digital literacy concepts, practise important exam questions, and strengthen their preparation for the upcoming board examinations. Explore our Punjab Board 2027 Model Papers and chapter-wise test series for effective exam preparation.
Computer Science
Chapter 1: Basic Digital Literacy | Board Standard Paper
| 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. A cell address is made by combining:
(A) Sheet name and column letter(B) Row number and sheet name(C) Column letter and row number(D) Cell colour and row number
2. Which of the following is NOT a spreadsheet program?
(A) Microsoft Excel(B) Google Sheets(C) LibreOffice Calc(D) Microsoft Word
3. Which shortcut key combination is used to apply or remove filters?
(A) Ctrl + 1(B) Ctrl + Shift + L(C) Alt + H + O + I(D) Ctrl + A
4. Which key combination opens the Format Cells window?
(A) Ctrl + 1(B) Ctrl + L(C) Ctrl + Alt + F(D) Ctrl + Shift + L
5. Which function shows the largest value in a range?
(A) SUM(B) AVERAGE(C) MIN(D) MAX
6. Which chart is the best choice to show trends or progress over time?
(A) Pie chart(B) Line chart(C) Table(D) None of these
7. In a spreadsheet, pressing the Tab key moves the cursor to:
(A) Next cell on the right(B) Next cell below(C) Previous cell on the left(D) Last cell of the row
8. In the formula =SUM(A1:A5), the part A1:A5 is called a:
(A) Cell address(B) Function name(C) Cell range(D) Formula bar
9. When a filter is applied, the rows that do not match the condition are:
(A) Deleted forever(B) Hidden but not deleted(C) Moved to a new sheet(D) Sorted in order
10. Which part of a chart explains the colours or symbols used in it?
(A) Title(B) Gridline(C) Legend(D) Border
Page 1 of 2
Computer Science
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 names of any two popular spreadsheet programs and any two places where spreadsheets are used.
- Differentiate between a row and a column.
- What is a cell address? Give two examples.
- Write the steps to create a new blank workbook in Microsoft Excel.
- What is the use of the Enter key and the Tab key during data entry?
- What is meant by formatting data? Why is it important?
Q.3: Write short answers to any FOUR parts. (4 × 2 = 8)
- What is a formula? Write the formula to add the values of cells A1 to A5.
- What is sorting? Give one example.
- What is filtering? How is it different from deleting data?
- Write the shortcut keys to apply or remove filters and to AutoFit a selected column.
- What is a chart? Write one use of charts.
- How can a spreadsheet help in making a budget plan?
SUBJECTIVE – PART IIMarks: 14
Attempt any TWO questions. (2 × 7 = 14)
Q.4: What is a spreadsheet? Explain its structure (cells, rows and columns) in detail. (7)
Q.5: Explain the basic tasks performed in a spreadsheet: data entry, formatting data and basic calculations (SUM, AVERAGE, MIN and MAX), with examples. (7)
Q.6: What are charts? Describe Bar, Pie and Line charts, and explain how to choose the right chart and add titles, labels and legends. (7)
Page 2 of 2
Answer Key – Page 1
Chapter 1: Basic Digital Literacy
Q.1 MCQ ANSWERS1 mark each
| Q | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
|---|---|---|---|---|---|---|---|---|---|---|
| Ans | C | D | B | A | D | B | A | C | B | C |
Q.2 SHORT ANSWERSAny 4 × 2 = 8
(i) Names of two spreadsheet programs and two places of use.
Programs: Microsoft Excel and Google Sheets (also LibreOffice Calc).
Used in: schools, offices and businesses (also for personal records).
Used in: schools, offices and businesses (also for personal records).
(ii) Differentiate between a row and a column.
| Row | Column |
|---|---|
| Horizontal line of cells | Vertical line of cells |
| Named by numbers: 1, 2, 3 | Named by letters: A, B, C |
| Holds all details of one person or item (a student’s name and marks) | Holds one type of data (all names in one column) |
(iii) What is a cell address? Give two examples.
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.
(iv) Steps to create a new blank workbook in Microsoft Excel.
- Open Microsoft Excel.
- Click File (top-left).
- Select New.
- Click Blank Workbook. The new file is created.
(v) Use of the Enter key and the Tab key during data entry.
Pressing Enter moves to the next cell below, and pressing Tab moves to the next cell on the right. Both make data entry quick.
(vi) What is formatting data? Why is it important?
Formatting means changing the look of data (font size, colour, alignment, borders) to make it neat and attractive. It highlights important data such as titles or totals, makes large tables easier to read, and makes the spreadsheet look professional and organized.
Answer Key – Page 2
Chapter 1: Basic Digital Literacy
Q.3 SHORT ANSWERSAny 4 × 2 = 8
(i) What is a formula? Formula to add A1 to A5.
A formula is an instruction typed in a cell that starts with an equal sign (=), followed by a function name and cell range. The spreadsheet calculates the answer right away.
Formula: =SUM(A1:A5)
Formula: =SUM(A1:A5)
(ii) What is sorting? Give one example.
Sorting means arranging data in a specific order: text from A to Z or Z to A, and numbers from smallest to largest or largest to smallest. Example: sorting a list of students by their names or marks.
(iii) What is filtering? How is it different from deleting data?
Filtering means showing only the data that meets certain conditions (for example, students who scored above 80). The other rows are only hidden, not deleted, and can be shown again. Deleting removes the data.
(iv) Shortcut keys for filters and AutoFit.
Apply / remove filters: Ctrl + Shift + L
AutoFit selected column: Alt + H + O + I
AutoFit selected column: Alt + H + O + I
(v) What is a chart? Write one use.
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.
(vi) How can a spreadsheet help in making a budget plan?
We list all sources of income and all types of expenses. Formulas quickly find total income, total spending and the remaining balance. Colours and borders can highlight important expenses or mark savings. This helps families and businesses control spending and save money.
Q.4 (7 marks)Spreadsheet and its structure
Spreadsheet: a computer program that looks like a large table made of small boxes called cells. Each cell can hold numbers, words or formulas. It helps us store, organize and calculate data easily, from simple lists to complex mathematical problems. Examples: Microsoft Excel, Google Sheets, LibreOffice Calc.
Structure: all data is arranged in rows and columns.
Structure: all data is arranged in rows and columns.
- Cell: the smallest unit, a small box where we type numbers, words or formulas. Its address is the column letter plus the row number (A1, B2).
- Row: a horizontal line of cells with a number (1, 2, 3). One row can hold all information about one person or item, such as a student’s name and marks.
- Column: a vertical line of cells with a letter (A, B, C). We can keep all names in one column and marks in another. Columns are important for sorting, filtering and calculations.
Answer Key – Page 3
Chapter 1: Basic Digital Literacy
Q.5 (7 marks)Basic tasks in a spreadsheet
1. Data entry: typing numbers, words or formulas into the cells, such as student names, marks or prices. Each piece of data must be in the correct cell to keep the table organized. Enter moves to the cell below and Tab moves to the cell on the right.
2. Formatting data: changing the look of data by changing font size, colour and alignment and adding borders. For example, headings can be bold and totals a different colour. Ctrl + 1 opens the Format Cells window.
3. Basic calculations: a formula starts with = followed by the function name and cell range.
2. Formatting data: changing the look of data by changing font size, colour and alignment and adding borders. For example, headings can be bold and totals a different colour. Ctrl + 1 opens the Format Cells window.
3. Basic calculations: a formula starts with = followed by the function name and cell range.
- SUM adds numbers, AVERAGE finds the mean, MIN shows the smallest value and MAX shows the largest.
| Formula | Result |
|---|---|
| =SUM(A1:A5) | 150 |
| =AVERAGE(A1:A5) | 30 |
| =MIN(A1:A5) | 10 |
| =MAX(A1:A5) | 50 |
Q.6 (7 marks)Charts
Charts are pictures that show data in a clear and easy way. They make data more interesting and easier to compare, and show trends, differences and patterns that are hard to see in a table.
Titles, labels and legends: a title tells what the chart is about, labels show what each axis or part represents, and a legend explains the colours or symbols used. Without them people may not understand the chart. They can be set from the Design tab of the chart tools.
- Bar chart: uses bars of different lengths; useful for comparing values.
- Pie chart: shows data as parts of a circle; shows how each part contributes to the whole.
- Line chart: connects points with lines to show changes over time, such as marks over months or sales during a year.
Titles, labels and legends: a title tells what the chart is about, labels show what each axis or part represents, and a legend explains the colours or symbols used. Without them people may not understand the chart. They can be set from the Design tab of the chart tools.
Marking Scheme
Chapter 1: Basic Digital Literacy
MARKING SCHEMESubjective: 30
| Question | Marks | Award marks for |
|---|---|---|
| Q.2 (i) | 2 | Two program names (1) + two places of use (1) |
| Q.2 (ii) | 2 | Row = horizontal, numbered (1) + column = vertical, lettered (1) |
| Q.2 (iii) | 2 | Column letter + row number (1) + two examples such as A1, B2 (1) |
| Q.2 (iv) | 2 | Open Excel, File, New, Blank Workbook |
| Q.2 (v) | 2 | Enter moves down (1) + Tab moves right (1) |
| Q.2 (vi) | 2 | Meaning (1) + importance: neat, easy to read, highlights data (1) |
| Q.3 (i) | 2 | Formula starts with = (1) + =SUM(A1:A5) (1) |
| Q.3 (ii) | 2 | Meaning (1) + example such as A to Z or smallest to largest (1) |
| Q.3 (iii) | 2 | Shows only matching data (1) + other rows hidden, not deleted (1) |
| Q.3 (iv) | 2 | Ctrl + Shift + L (1) + Alt + H + O + I (1) |
| Q.3 (v) | 2 | Definition (1) + use (1) |
| Q.3 (vi) | 2 | List income and expenses (1) + formulas give total and balance (1) |
| Q.4 | 7 | Definition and uses (2) + cell with address (2) + row (1.5) + column (1.5) |
| Q.5 | 7 | Data entry (2) + formatting (2) + four functions with example (3) |
| Q.6 | 7 | Meaning and use (1) + Bar, Pie, Line (3) + choosing chart (1.5) + titles, labels, legends (1.5) |
