Prepare for the Class 10 ICT Chapter 1: Digital Literacy Test 5, a comprehensive Full Unit Test designed for students of Computer Tech. This test covers Chapter 1 of Information and Communication Technology (ICT) and is part of our chapter-wise test series for the Punjab Board Annual Examination 2027. Developed according to the new syllabus issued by PECTAA Punjab, this Class 10 ICT practice test helps students evaluate their subject knowledge, strengthen digital literacy concepts, and improve their exam preparation. Explore our Punjab Board 2027 Model Papers and chapter-wise tests to prepare confidently for the upcoming board examinations.
Information and Communication Technology
Chapter 1: Basic Digital Literacy | Board Standard Paper – Test 5
| 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. In a budget, formulas quickly find:
(A) Only colours(B) Only dates(C) Only names(D) Total income, total spending and remaining balance
Correct Answer: D
2. To AutoFit all columns at once, first press this key combination to select the entire sheet:
(A) Ctrl + A(B) Ctrl + S(C) Ctrl + 1(D) Ctrl + L
Correct Answer: A
3. Which of the following is a cell address?
(A) BB(B) B2(C) 2B(D) B+2
Correct Answer: B
4. Every formula begins with:
(A) A colon (:)(B) An exclamation mark (!)(C) A plus sign (+)(D) An equal sign (=)
Correct Answer: D
5. Charts are:
(A) Long tables of numbers(B) Shortcut keys(C) Pictures that show data in a clear and easy way(D) Types of formulas
Correct Answer: C
6. Pressing the Tab key moves you to:
(A) The top of the sheet(B) The previous row(C) The next cell below(D) The next cell on the right
Correct Answer: D
7. After filtering, the rows that do not match the condition are:
(A) Moved to the top(B) Deleted forever(C) Hidden but not deleted(D) Copied to a new sheet
Correct Answer: C
8. Shopkeepers can make reports of their:
(A) Marks(B) Homework(C) Sales(D) Attendance
Correct Answer: C
9. Typing information into the cells of a spreadsheet is called:
(A) Data entry(B) Filtering(C) Charting(D) Sorting
Correct Answer: A
10. A pie chart helps us see:
(A) Spelling mistakes(B) Changes over months(C) How each part contributes to the whole(D) Cell addresses
Correct Answer: C
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)
- 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.
- What is the use of the Enter key and the Tab key during data entry?
Ans: Pressing Enter moves to the next cell below, and pressing Tab moves to the next cell on the right. Both make data entry quick.
- Differentiate between a row and a column.
Ans:
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 Holds one type of data, such as all names - Why are rows and columns important in a spreadsheet?
Ans: A row holds all information about one person or item and is useful when many entries are recorded one after another. A column keeps one type of data, so data looks organized and is easy to compare. Columns are important for sorting, filtering and calculations.
- Which key combination opens the Format Cells window? What can we see in it?
Ans: Ctrl + 1 opens the Format Cells window, where we can format cells and see a preview.
- What is a spreadsheet?
Ans: A spreadsheet is 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.
Q.3: Write short answers to any FOUR parts. (4 × 2 = 8)
- What can a cell hold? How much data can a single spreadsheet hold?
Ans: A cell can hold numbers, words or formulas. A single spreadsheet can hold thousands of rows and columns of data.
- What is data entry? Write two examples of data that can be entered.
Ans: Data entry means typing information into the cells of a spreadsheet. We can type numbers, words or formulas. Examples: student names, marks, prices of items.
- 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.
- 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 - Define the title, labels and legend of a chart.
Ans: A title tells what the chart is about. Labels show what each axis or part represents. A legend explains the colours or symbols used in the chart.
- Write the steps to create a new blank workbook in Microsoft Excel.
Ans:
- Open Microsoft Excel.
- Click File (top-left).
- Select New.
- Click Blank Workbook. The new file is created.
SUBJECTIVE – PART IIMarks: 14
Attempt any TWO questions. (2 × 7 = 14)
Q.4: Explain how formulas and functions work in a spreadsheet. Describe SUM, AVERAGE, MIN and MAX with an example. (7)
Ans: Spreadsheets can do many kinds of calculations automatically. This saves time and reduces errors.
- Formula: we type an equal sign (=) followed by the function name and cell range, such as =SUM(A1:A5). The spreadsheet calculates the answer right away. A formula can also use cell addresses directly, such as =A1+B1+E1.
- Functions: SUM adds numbers, AVERAGE finds the mean, MIN shows the smallest value and MAX shows the largest.
- Useful points: =SUM(A1,A5) and =SUM(A1:A5) give different results. Values of another sheet are used with the ! sign, e.g. =SUM(Sheet2!A1:A5). The AutoSum (Σ) button gives totals in seconds. When a formula is copied and pasted, its cell addresses change according to the source and destination.
| Formula | Result |
|---|---|
| =SUM(A1:A5) | 150 |
| =AVERAGE(A1:A5) | 30 |
| =MIN(A1:A5) | 10 |
| =MAX(A1:A5) | 50 |
Q.5: What is meant by organizing data? Explain sorting and filtering in detail with examples. (7)
Ans: When we have a lot of data in a spreadsheet, it is hard to find what we need. Sorting and filtering help us work with data quickly and clearly.
- Sorting: arranging data in a specific order. Text can be sorted from A to Z or Z to A, and numbers from smallest to largest or largest to smallest. It helps us find information easily and see patterns. Example: sorting a list of students by their names or marks. It is very helpful in reports, lists and records where order is important.
- Filtering: showing only the data that meets certain conditions. The spreadsheet hides the data we do not need. Example: showing only students who scored above 80 marks. The other rows are hidden, but they are not deleted. Ctrl + Shift + L applies or removes filters, and custom filters can be used on several columns at the same time to narrow down data efficiently.
Q.6: Explain the practical uses of spreadsheets: making a budget plan and creating data reports. (7)
Ans: Spreadsheets are useful in daily life, school and work. People use them to record data, make budgets and prepare reports. They save time and help organize large amounts of information.
- Budget plan: a budget plan helps us manage money wisely. We list all sources of income and all types of expenses, and use formulas to find total income, total spending and the remaining balance. Colours and borders make the budget neat, for example highlighting important expenses or marking savings in a different colour. It helps families and businesses control spending and save money.
- Data reports: a data report presents information in an organized form. We enter data, perform calculations, and use charts or tables to make clear reports that help people understand results and make better decisions. Teachers prepare reports of students’ marks and shopkeepers prepare reports of their sales. Sorting, filtering and charts make reports detailed and easy to read.
Page 2 of 2
www.786Times.com | An Education Project in Punjab
