Skill Subject · Information Technology
50 Important Questions & Answers
Based on the official CBSE Department of Skill Education curriculum (402 – Information Technology) for Session 2026‑27. Covers IT‑ITeS Industry, Data Entry & Keyboarding, Digital Documentation, Electronic Spreadsheet and Digital Presentation — built for high‑order competency practice and board exam preparation.
Unit 1
Introduction to IT–ITeS Industry
Q1–Q6Q1. What is meant by IT and ITeS? Give one example of each.
IT (Information Technology) refers to the use of computers, networking and other physical devices to create, process, store and exchange electronic data. Example: developing software applications.
ITeS (IT enabled Services) refers to services delivered over telecom networks or the internet using IT tools. Example: BPO (Business Process Outsourcing) services like customer support call centres.
ITeS (IT enabled Services) refers to services delivered over telecom networks or the internet using IT tools. Example: BPO (Business Process Outsourcing) services like customer support call centres.
Q2. Define BPO and BPM. How are they different?
BPO (Business Process Outsourcing): a company hires another company to perform a specific business task/process, e.g. payroll, customer care.
BPM (Business Process Management): a systematic, discipline-based approach to improve an organisation's business processes.
Difference: BPO is about outsourcing a task to a third party, while BPM is about managing and improving processes within the organisation itself.
BPM (Business Process Management): a systematic, discipline-based approach to improve an organisation's business processes.
Difference: BPO is about outsourcing a task to a third party, while BPM is about managing and improving processes within the organisation itself.
Q3. List any four sectors where IT is applied in everyday life.
- Banking (net-banking, ATMs, mobile banking)
- Healthcare (patient records, tele-medicine)
- Education (e-learning, digital classrooms)
- Government & Public Service (e-governance, online services like passport/Aadhaar)
Q4. "India is a leading hub for the IT-BPM industry." Justify with two reasons.
- Availability of a large, skilled and English-speaking workforce at competitive cost.
- Strong government support and infrastructure (SEZs, Digital India initiatives) that attracts global companies to set up operations in India.
Q5. How does IT help in the education sector? Give two examples.
IT enables digital content delivery, remote/online classes, easy record keeping of students, and access to a wide range of learning resources. Examples: smart classrooms with projectors, online examination and result portals.
Q6. Competency-based: Ravi wants a career as a Data Entry Operator. Name the industry sector he will be working in and one skill essential for this job role.
He will work in the IT-BPM (IT enabled Services) industry. An essential skill is fast and accurate typing speed (along with computer literacy and concentration skills).
Unit 2
Data Entry & Keyboarding Skills
Q7–Q14Q7. What are Home Keys? Name the home keys of the left and right hand.
Home keys are the base row keys on which fingers rest before typing, so fingers can quickly reach other keys.
Left hand: A, S, D, F | Right hand: J, K, L, ; (semicolon). The index fingers rest on F and J, which usually have a small raised bump for identification without looking.
Left hand: A, S, D, F | Right hand: J, K, L, ; (semicolon). The index fingers rest on F and J, which usually have a small raised bump for identification without looking.
Q8. What is the Numeric Keypad used for?
The numeric keypad is a set of keys on the right side of the keyboard, arranged like a calculator, used for fast entry of numeric data. It is very useful for data entry operators who need to type large volumes of numbers quickly.
Q9. Explain "Typing Ergonomics" and give two correct posture tips.
Typing ergonomics refers to correct posture and finger positioning while typing to avoid strain/injury and to improve speed and accuracy.
Tips: (1) Sit straight with feet flat on the floor; (2) Keep wrists straight and slightly raised above the keyboard, not resting on the desk while typing.
Tips: (1) Sit straight with feet flat on the floor; (2) Keep wrists straight and slightly raised above the keyboard, not resting on the desk while typing.
Q10. What is a Guide Key? Name any two guide keys.
Guide keys are keys with small tactile bumps that help a typist locate the home row correctly without looking at the keyboard. Examples: F key (left index finger) and J key (right index finger).
Q11. What is touch typing? Why is it important for a data entry operator?
Touch typing is the technique of typing without looking at the keyboard, using muscle memory to know the position of keys. It is important because it increases typing speed and accuracy, which are essential for a data entry operator's productivity.
Q12. What is the use of a Typing Tutor software? Name any one such software.
A Typing Tutor software helps a learner practice touch typing through structured lessons, tracks typing speed (WPM) and accuracy, and helps improve typing rhythm through repeated practice. Example: Rapid Typing Tutor.
Q13. How is typing speed calculated in a Typing Tutor?
Typing speed is generally calculated in Words Per Minute (WPM): (Total number of characters typed ÷ 5) ÷ time taken in minutes. Accuracy is calculated separately based on the number of correct vs incorrect keystrokes.
Q14. Competency-based: While typing, Simran keeps looking at the keyboard and her speed is very slow. Suggest two ways to improve her typing skills.
- Practice touch typing regularly using a typing tutor software so she learns the position of keys by memory.
- Practice correct finger placement on the home row keys and maintain proper typing ergonomics/posture during practice.
Unit 3
Digital Documentation (Word Processor)
Q15–Q28Q15. What is a Word Processor? Name any two word processing applications.
A word processor is a software application used to create, edit, format, save and print text documents. Examples: LibreOffice Writer and Microsoft Word.
Q16. Differentiate between "Save" and "Save As" options.
Save stores changes in the same file with the same name and location (overwrites the existing file).
Save As allows saving the document with a new name, in a new location, or in a different file format, keeping the original file unchanged.
Save As allows saving the document with a new name, in a new location, or in a different file format, keeping the original file unchanged.
Q17. What is the difference between Cut-Paste and Copy-Paste?
Cut-Paste: removes (deletes) the selected text/object from its original location and places it at a new location.
Copy-Paste: duplicates the selected text/object, keeping the original intact, and places a copy at the new location.
Copy-Paste: duplicates the selected text/object, keeping the original intact, and places a copy at the new location.
Q18. What is the use of "Find and Replace" option?
Find and Replace is used to search for a specific word or phrase in a document (Find) and automatically substitute it with another word or phrase (Replace) throughout the document, saving time compared to manual editing.
Q19. What are non-printing characters? Give one example.
Non-printing characters are formatting marks that are visible on screen (when enabled) but do not appear when the document is printed. They help in checking formatting. Example: paragraph mark (¶) shown at the end of each paragraph, or a dot for a space character.
Q20. Explain Superscript and Subscript with an example.
Superscript raises text slightly above the normal line, e.g. in x². Subscript lowers text slightly below the normal line, e.g. in H₂O. Both are used for mathematical/chemical notations and footnotes.
Q21. What is the difference between a Thesaurus and Spelling & Grammar check?
Spelling and Grammar check identifies and corrects spelling mistakes and grammatical errors in a document.
Thesaurus is a tool that suggests synonyms (and sometimes antonyms) for a selected word, helping improve vocabulary/word choice.
Thesaurus is a tool that suggests synonyms (and sometimes antonyms) for a selected word, helping improve vocabulary/word choice.
Q22. What is a Header and Footer? Why are they used?
A Header is the area at the top margin and a Footer is the area at the bottom margin of every page in a document. They are used to display repeating information such as document title, page numbers, date, or author name on every page.
Q23. How do you insert a table in a word processor and add a new row to it?
To insert a table: go to Table → Insert Table, specify the number of rows and columns, and click OK.
To add a new row: place the cursor in the last cell of the last row and press the Tab key, or right-click a row and choose Insert Row Above/Below.
To add a new row: place the cursor in the last cell of the last row and press the Tab key, or right-click a row and choose Insert Row Above/Below.
Q24. What is the difference between "Split Table" and "Merge Table"?
Split Table divides one table into two separate tables at the selected row.
Merge Table (or merge cells) combines two or more cells/tables into a single cell/table, removing the boundary between them.
Merge Table (or merge cells) combines two or more cells/tables into a single cell/table, removing the boundary between them.
Q25. What is Print Preview? Why should it be used before printing?
Print Preview shows how the document will look on paper before actually printing it. It should be used to check page layout, margins, and formatting so that errors can be corrected before wasting paper and ink.
Q26. What is Mail Merge? List its two essential components.
Mail Merge is a feature that combines a main document (with fixed content) with a data source (containing variable data like names and addresses) to automatically generate personalised copies of a document/letter for multiple recipients.
Essential components: (1) Main Document, (2) Data Source.
Essential components: (1) Main Document, (2) Data Source.
Q27. List the steps to perform Mail Merge to send letters to multiple customers.
- Create the main document (the letter with fixed content).
- Create/select the data source (e.g. list of names and addresses).
- Insert merge fields (like <<Name>>, <<Address>>) in the main document.
- Merge the data source with the main document.
- Preview, edit individual letters if needed, then print and save the merged letters.
Q28. Competency-based: Meena has prepared a fee-due letter and needs to send it to 100 parents with each parent's name and amount due. Which word processor feature should she use, and why?
She should use the Mail Merge feature. It allows her to create one main document (the fee letter) and link it to a data source containing each parent's name and due amount, automatically generating 100 personalised letters instead of typing each one manually — saving time and reducing errors.
Unit 4
Electronic Spreadsheet
Q29–Q43Q29. What is a Spreadsheet? Name one spreadsheet application.
A spreadsheet is an application software that arranges data in rows and columns (a grid of cells), used for calculations, data analysis and record keeping. Example: LibreOffice Calc (or MS Excel).
Q30. Define Cell, Cell Address and Range with examples.
Cell: the intersection of a row and a column where data is entered.
Cell Address: identifies a cell by its column letter and row number, e.g. B5.
Range: a group of contiguous cells, e.g. A1:A10 (column range) or A1:D1 (row range) or A1:D10 (row & column range).
Cell Address: identifies a cell by its column letter and row number, e.g. B5.
Range: a group of contiguous cells, e.g. A1:A10 (column range) or A1:D1 (row range) or A1:D10 (row & column range).
Q31. Differentiate between Label and Value in a spreadsheet.
Label: text data used for headings/descriptions (e.g. "Name", "Marks"); by default left-aligned and cannot be used in calculations.
Value: numeric data (numbers, dates) that can be used in calculations; by default right-aligned.
Value: numeric data (numbers, dates) that can be used in calculations; by default right-aligned.
Q32. What is a formula in a spreadsheet? Give an example.
A formula is an expression used to perform calculations on data in a spreadsheet. It always begins with an "=" sign. Example: =A1+B1 adds the values of cells A1 and B1.
Q33. List the commonly used basic functions in a spreadsheet with their purpose.
- SUM() — adds a range of numbers. e.g. =SUM(A1:A10)
- AVERAGE() — calculates the mean value. e.g. =AVERAGE(B1:B10)
- MAX() — finds the largest value in a range.
- MIN() — finds the smallest value in a range.
- COUNT() — counts the number of cells containing numeric data.
Q34. What is the difference between Relative and Absolute referencing? Give an example of each.
Relative Reference changes automatically when a formula is copied to another cell, based on its relative position. e.g. =A1+B1 copied one row down becomes =A2+B2.
Absolute Reference remains fixed regardless of where the formula is copied, denoted using the "$" sign. e.g. =$A$1+B1 — here A1 will not change on copying.
Absolute Reference remains fixed regardless of where the formula is copied, denoted using the "$" sign. e.g. =$A$1+B1 — here A1 will not change on copying.
Q35. What is Mixed Referencing? Give an example.
Mixed Referencing locks only the column OR only the row (not both) using a single "$" sign, e.g. $A1 (column fixed, row changes) or A$1 (row fixed, column changes). It is useful when only one part of the cell reference needs to stay constant while copying a formula.
Q36. What is the Fill Handle? State two uses of the fill handle.
The Fill Handle is a small square at the bottom-right corner of a selected cell, used to quickly copy content/formula or extend a series to adjacent cells.
Uses: (1) Creating a number/date series automatically (e.g. 1, 2, 3…); (2) Copying a formula quickly to multiple cells without retyping.
Uses: (1) Creating a number/date series automatically (e.g. 1, 2, 3…); (2) Copying a formula quickly to multiple cells without retyping.
Q37. How can you format a range of cells to display values with two decimal places?
Select the required range of cells → open Format Cells dialog box (Format → Cells) → choose Number category → set decimal places to 2 → click OK.
Q38. What is the importance/need of a chart in a spreadsheet?
A chart presents numeric data visually/graphically, making it easier to understand trends, compare values, and identify patterns at a glance, compared to reading raw numbers in a table.
Q39. Name any three types of charts supported by a spreadsheet application.
Bar Chart, Pie Chart, Line Chart (others accepted: Column Chart, Area Chart, XY/Scatter Chart).
Q40. What is the difference between SUM() and COUNT() functions?
SUM() adds up the numeric values in a given range and returns their total.
COUNT() counts how many cells in a given range contain numeric data — it does not add the values, it only counts them.
COUNT() counts how many cells in a given range contain numeric data — it does not add the values, it only counts them.
Q41. What mathematical operators are commonly used in spreadsheet formulas?
+ (addition), − (subtraction), * (multiplication), / (division), ^ (exponentiation/power). These are used along with cell addresses to build formulas, e.g. =(A1+B1)*C1.
Q42. Competency-based: A teacher has entered the marks of 40 students in cells B2:B41. Write the formula to find (a) the total marks and (b) the highest mark scored.
(a) Total marks: =SUM(B2:B41)
(b) Highest mark: =MAX(B2:B41)
(b) Highest mark: =MAX(B2:B41)
Q43. Competency-based: Rohit copied the formula =A1*B1 from cell C1 to cell C2, but he wants B1 to remain fixed for every row while A1 should change automatically. Which referencing should he use, and how should the formula be written?
He should use Absolute Referencing for cell B1 and keep A1 as relative. The formula should be written as =A1*$B$1 in C1, then copied down. This keeps B1 constant while A1 changes automatically for each row (A2, A3, etc.).
Unit 5
Digital Presentation
Q44–Q50Q44. What is a presentation? List any two characteristics of an effective presentation.
A presentation is a collection of slides used to communicate information/ideas to an audience using text, images, charts and multimedia.
Characteristics of an effective presentation: (1) Clear and concise content with a logical flow; (2) Visually appealing design with appropriate use of images/colour, not overcrowded with text.
Characteristics of an effective presentation: (1) Clear and concise content with a logical flow; (2) Visually appealing design with appropriate use of images/colour, not overcrowded with text.
Q45. Name any two workspace/views available in a presentation software and their use.
Normal View: used for creating and editing individual slides.
Slide Sorter View: shows thumbnails of all slides together, used to rearrange, delete or duplicate slides easily.
(Other valid views: Outline View, Notes View.)
Slide Sorter View: shows thumbnails of all slides together, used to rearrange, delete or duplicate slides easily.
(Other valid views: Outline View, Notes View.)
Q46. What is the difference between Slide Layout and Slide Master?
Slide Layout defines the arrangement of placeholders (title, content, image) on an individual slide.
Slide Master is a template slide that controls the formatting (fonts, colours, background, logo) applied to all slides in the presentation, so that changing the master updates every slide at once.
Slide Master is a template slide that controls the formatting (fonts, colours, background, logo) applied to all slides in the presentation, so that changing the master updates every slide at once.
Q47. What is Custom Animation? How is it different from Slide Transition?
Custom Animation applies motion effects to individual objects (text, images) within a slide, e.g. text flying in.
Slide Transition is the animation effect that occurs when moving from one slide to the next slide, e.g. fade or wipe effect between slides.
Slide Transition is the animation effect that occurs when moving from one slide to the next slide, e.g. fade or wipe effect between slides.
Q48. How do you insert and format a table in a presentation slide? (List steps)
- Go to Insert → Table, specify number of rows and columns.
- Click inside cells to enter/edit data.
- Select rows/columns to adjust column width and row height by dragging borders.
- Use the Table Design/Format options to apply borders and background colour.
Q49. What is the difference between Grouping and Ungrouping of objects in a presentation?
Grouping combines multiple objects (shapes, images) into a single unit so they can be moved, resized, or formatted together.
Ungrouping separates a grouped object back into its individual parts so each can be edited independently.
Ungrouping separates a grouped object back into its individual parts so each can be edited independently.
Q50. Competency-based: Anjali is preparing a 15-slide presentation for a school project and wants the same logo and font style to appear on every slide without applying it manually each time. Which feature should she use and why?
She should use the Slide Master feature. By adding the logo and font style once to the slide master, the formatting is automatically applied to every slide in the presentation, saving time and ensuring consistency throughout the deck.
