DIT Part-I MS-Office Solved Paper 2026 - Word Excel PowerPoint Access [1st Term]

TrickPk  Published on:   9/6/26

Also Read

Khyber Pakhtunkhwa Board of Technical & Commerce Education Peshawar - Diploma in Information Technology (Part-I) - 1st Term Examination 2026 - Paper: Introduction to MS-Office
Time Allowed: 03 Hours | Max Marks: 75 | Part-A 20 Minutes (15 Marks).

Part-A Q1 - Choose / Encircle Correct Answer (15)

i Microsoft Office Suite 2016 is an example of ______

Ans: c) Proprietary software - Owned by Microsoft, not open-source, requires license. Open-source example is LibreOffice.

ii ______ displays name of open document in MS Word

Ans: b) Title bar - Topmost bar shows document name like Document1 - Word. Ribbon has tabs, Status bar at bottom, Quick Access Toolbar has Save/Undo.

iii In MS Word ______ shows current page number and word count

Ans: b) Status bar - Bottom bar of Word window shows Page 1 of 10, Words: 250, Language, Zoom.

iv Which feature checks for spelling and grammatical errors?

Ans: b) Spelling & Grammar - Red underline for spelling, Blue/Green for grammar. Shortcut F7. Format Painter copies formatting, Autocorrect auto-fixes typos.

v To save a document for first time ______ command is used

Ans: a) Save As - First time both Save and Save As open Save As dialog to give name/location. After first save, Save just updates file.

vi ______ tab is used for adjusting margins, page orientation and paper size

Ans: c) Layout (Page Layout) - Layout tab > Page Setup group: Margins, Orientation (Portrait/Landscape), Size (A4, Letter), Columns.

vii Basic unit of spreadsheet where data is entered?

Ans: c) Cell - Intersection of Row and Column. Each cell has address like A1, B2. Row is horizontal, Column vertical, Worksheet is whole sheet.

viii To calculate sum of range in Excel ______ function is used

Ans: b) SUM - Example: =SUM(A1:A10) sums values from A1 to A10. AVERAGE gives average, COUNT counts numbers, MAX gives maximum.

ix Purpose of IF function in Excel

Ans: b) to perform conditional logic - Syntax: =IF(condition, value_if_true, value_if_false). Example: =IF(A1>=50,"Pass","Fail")

x Best layout for slide with text and picture?

Ans: b) Title and Content - This layout has title at top and one content box that can hold text and picture side by side. Two Content is also used for two objects.

xi ______ animation allows you to move objects along a specified path

Ans: b) Motion path - Under Animations > Add Animation > Motion Paths. Entrance is for appearing, Exit for disappearing, Transition is between slides.

xii Shortcut to create hyperlink in PowerPoint?

Ans: b) Ctrl + K - Same shortcut in Word, Excel, PowerPoint. Insert > Link > Hyperlink.

xiii First step to start working in Access?

Ans: c) Create a database - Open Access > Blank Database > Give name > Create. Then create tables, forms, queries.

xiv ______ data type best for long paragraphs in Access

Ans: b) Long Text - Long Text (formerly Memo) stores up to 1GB, for paragraphs, comments. Short Text only 255 characters. Number for numeric, Currency for money.

xv In Access to add fields and set data types ______ is used

Ans: b) Design view - Design view allows adding field names, data types, description, properties. Datasheet view shows data entry view, Form View shows forms.

Part-B - Attempt any 06 (05 Marks Each)

i Steps to use IF function in Excel with example

Purpose: IF checks condition and returns different values.
Syntax: =IF(logical_test, value_if_true, value_if_false)
Steps: 1) Select cell where result needed. 2) Type =IF( 3) Select condition cell, e.g., A1>=33 4) Comma, then "Pass" 5) Comma, then "Fail" 6) Close bracket and Enter.
Example: In B2 write =IF(A2>=50,"Pass","Fail"). If A2 is 65, result is Pass. If A2 is 30, result is Fail. Nested IF: =IF(A1>=80,"A",IF(A1>=60,"B","C"))

ii How to create a report using Report Wizard in Access?

Report Wizard is easiest way to create report. Steps: 1) Open Access database > Create tab > Report Wizard. 2) Select Table/Query from dropdown (e.g., Students). 3) Move fields from Available to Selected (e.g., Name, Marks) > Next. 4) Choose grouping level if needed > Next. 5) Choose sort order (e.g., Sort by Name) > Next. 6) Choose layout (Tabular/Columnar) and orientation (Portrait/Landscape) > Next. 7) Give report title > Finish. Report will be created showing data in printable format.

iii Steps for adding transition effects and animation to presentation

Transition (Between Slides): 1) Select slide in left pane. 2) Go to Transitions tab. 3) Choose transition from gallery (Fade, Wipe, Push, Split). 4) Set Duration and Sound from Timing group. 5) Click Apply To All to apply to all slides.
Animation (Inside Slide): 1) Select object (text, picture). 2) Go to Animations tab. 3) Choose animation from Entrance, Emphasis, Exit, Motion Path. 4) Set Start (On Click, With Previous), Duration, Delay from Timing group. 5) Use Animation Pane to reorder animations.

iv Steps to create a table in Access using Datasheet view

Datasheet view looks like Excel. Steps: 1) Open database > Create tab > Table. Table opens in Datasheet view with ID field auto-created. 2) Click Click to Add > Choose Data Type (Short Text, Number etc). 3) Type field name (e.g., Name) and press Enter. 4) Add more fields like Age, Class. 5) To rename ID field, double-click ID header. 6) Enter data directly in rows. 7) Press Ctrl+S to save > Give table name (e.g., tblStudents) > OK. Datasheet view is quick for data entry.

v Steps to save a document as PDF in MS Word

Steps: 1) Open document in Word. 2) Click File tab > Save As (or Export). 3) Choose location (This PC > Browse). 4) In Save as type dropdown, select PDF (*.pdf). 5) Give file name. 6) Choose Optimize: Standard (for printing) or Minimum size (for online). 7) Click Options if you want selected pages. 8) Click Save. Document will be saved as PDF that cannot be easily edited and can be opened on any device.

vi How to insert and delete rows or columns in Excel worksheet?

Insert Row: 1) Select row below where you want new row. 2) Right-click > Insert. Or Home tab > Cells group > Insert > Insert Sheet Rows. New blank row inserted.
Insert Column: Select column right side where you want new column > Right-click > Insert. Or Home > Insert > Insert Sheet Columns.
Delete Row/Column: Select row(s) or column(s) > Right-click > Delete. Or Home > Delete > Delete Sheet Rows/Columns.
Shortcut: Ctrl + Plus (+) to insert, Ctrl + Minus (-) to delete after selecting row/column.

vii Define table and steps to insert and format a table in PowerPoint slides

Define Table: Table is arrangement of data in rows and columns, used to display information clearly.
Steps to Insert Table: 1) Go to slide > Insert tab > Table > Select rows and columns (e.g., 3x4). Or Insert > Table > Insert Table dialog. 2) Table appears on slide.
Steps to Format Table: 1) Select table > Table Design and Layout tabs appear. 2) Table Design: Change Table Styles, Shading, Borders, Effects. 3) Layout: Insert/delete rows/columns, Merge cells, Change cell size, Alignment (center, left). 4) Right-click table > Format Shape for more options like fill color, border width.

viii Process of setting Primary Key and creating relationships in Access

Setting Primary Key: Primary Key uniquely identifies each record (e.g., StudentID). Steps: 1) Open table in Design view. 2) Select field you want as Primary Key (e.g., ID). 3) Right-click > Primary Key or click Primary Key icon in Tools group. Key symbol appears. Field must be unique and not null.
Creating Relationships: Relationships connect two tables via common field. Steps: 1) Close all tables. 2) Database Tools tab > Relationships. 3) Add tables (e.g., Students and Fees). 4) Drag Primary Key field from one table to matching Foreign Key field in other table. 5) Edit Relationships dialog appears > Check Enforce Referential Integrity > Create. Types: One-to-Many (most common), One-to-One, Many-to-Many. Relationship ensures data consistency.

Part-C - Attempt any 03 (10 Marks Each)

Q3 What is Query and purpose? How to use Query to filter and retrieve specific data?

What is Query? Query is a request to retrieve, filter, update, or analyze data from database tables. It is one of the most powerful features of Access. It allows you to ask questions to your database.
Purpose of creating Query: 1) To view only required fields from large table, 2) To filter records based on criteria (e.g., students with marks > 60), 3) To sort data, 4) To calculate (sum, average), 5) To combine data from multiple tables, 6) To update or delete data in bulk.
How to use Query to filter and retrieve: Steps: 1) Create tab > Query Design. 2) Add table(s) (e.g., Students). 3) Double-click fields you want (Name, Marks). 4) In Criteria row, type condition: For Marks field type >60, for Name field type "Ali", for date type Between #01/01/2024# And #31/12/2024#. 5) Run query by clicking Run (!) button. Example: SELECT Name, Marks FROM Students WHERE Marks > 60 will show only students who passed with >60 marks. You can also use AND, OR for multiple criteria.

Q4 Uses of MS PowerPoint? Steps to embed video or audio file

Uses of MS PowerPoint: 1) Creating presentations for education, business, seminars. 2) Creating photo slideshows. 3) Making training materials and tutorials. 4) Business proposals and sales pitches. 5) Creating certificates, posters, infographics. 6) Online webinars and video creation.

Steps to Embed Video: 1) Go to slide where you want video. 2) Insert tab > Video > Video on My PC (or Online Video). 3) Browse and select video file (MP4, WMV) > Insert. 4) Video appears on slide with playback tools. 5) Format tab to set size, Playback tab to set Start automatically or on click, trim video.
Steps to Embed Audio: 1) Insert tab > Audio > Audio on My PC. 2) Select audio file (MP3, WAV) > Insert. 3) Speaker icon appears. 4) Playback tab to set play options: Play in Background, Loop, Hide icon. Audio can be narration or background music.

Q5 What is a Macro in MS Word and how can it help in automatic tasks?

What is Macro? Macro is a small program that records a series of actions/keystrokes and saves them as a single command. It automates repetitive tasks. Macro uses VBA (Visual Basic for Applications) language.
How it helps in automatic tasks: Saves time, avoids repetitive work, reduces errors, ensures consistency.
Steps to Create Macro: 1) View tab > Macros > Record Macro. 2) Give macro name (e.g., FormatMyReport), assign shortcut key (e.g., Ctrl+Shift+F), choose where to store (All Documents). 3) Click OK > Recording starts. 4) Perform actions you want to automate (e.g., change font to Arial 12, bold heading, center align). 5) View tab > Macros > Stop Recording.
Steps to Run Macro: Press assigned shortcut key or View > Macros > View Macros > Select macro > Run. Example: If you daily format 10 reports same way, one macro can format in one click instead of 20 clicks.

Q6 What is a Graph or Chart in MS Excel? Different types and uses

What is Graph/Chart? Chart is graphical representation of worksheet data. It makes data easy to understand, compare, and analyze visually. Excel charts are linked to data, if data changes chart updates automatically.
Types of Charts and Uses:
1) Column Chart: Vertical bars, used to compare values across categories. Example: Sales of each month.
2) Bar Chart: Horizontal bars, similar to column but horizontal, good for long category names.
3) Line Chart: Shows trend over time, connects points with line. Example: Temperature change over days, Stock price.
4) Pie Chart: Circular chart divided into slices, shows proportion of whole. Use when you have few categories. Example: Market share, Budget distribution. Shows percentage.
5) Area Chart: Like line chart but area below line filled, shows magnitude of change.
6) Scatter (XY) Chart: Shows relationship between two numeric values, used for scientific data.
How to Create Chart: Select data range > Insert tab > Charts group > Choose chart type > Chart appears > Use Chart Design and Format tabs to change style, add Title, Data Labels, Legend.