Unit 1 of 1 · BCA Sem 1

Unit 1: Word processing, spreadsheets and presentations

Office Automation notes · PTU syllabus (UGCC2503)

7 min read13 topics18 exam questions
On this page
  1. Unit summary
  2. Introduction to office automation
  3. Word processing: resumes
  4. Word processing: assignments
  5. Word processing: newsletters
  6. Word processing: feedback forms and mail merge
  7. Excel: schedulers
  8. Excel: formulae and cell referencing
  9. Excel: performance analysis — sorting and conditional formatting
  10. Excel: pivot tables and data validation
  11. PowerPoint: slide layouts, multimedia, master layouts, animation and transitions
  12. Internet basics: e-mail setup
  13. Internet basics: blogging
  14. Internet basics: online banking
  15. Key terms
  16. Quick revision
  17. Important questions

Unit summary

Office automation means using software to create, store and share documents, data and presentations quickly and professionally. This unit covers Microsoft Word — resumes, assignments (styles, tables, bullets, hyperlinks, track changes), newsletters (columns, images, word art) and feedback forms with mail merge; Excel — schedulers, formulae and cell referencing, performance analysis with sorting and conditional formatting, pivot tables and data validation; PowerPoint — slide layouts, multimedia, master layouts, animation and transitions; and internet basics — e-mail setup, blogging and online banking.

After this unit you can

  • Format resumes, assignments, newsletters and mail-merged forms in Word
  • Build schedulers and analyse data in Excel using formulas, references, conditional formatting, pivot tables and validation
  • Design a presentation with layouts, master slides, multimedia, animation and transitions
  • Set up e-mail, create a blog and use online banking safely

PTU syllabus topics

  • Word: resume formatting
  • assignment creation (styles, tables, bullets, hyperlinks, track changes)
  • newsletter layout (columns, images, word art)
  • feedback forms (mail merge)
  • Excel: schedulers
  • formulae and cell referencing
  • performance analysis (sorting, conditional formatting)
  • pivot tables and data validation
  • PowerPoint: slide layouts
  • multimedia insertion
  • master layouts
  • animation and transitions
  • internet basics — email setup
  • blogging
  • online banking
1

Topic 1

Introduction to office automation

Office automation is the use of computers and software to create, store, process and share office information. It replaces manual paperwork and saves time.

ClassificationOffice suites and their uses
Office automation
  • Word processor

    Letters, resumes, reports — MS Word, Google Docs, LibreOffice Writer

  • Spreadsheet

    Calculation and analysis — MS Excel, Google Sheets

  • Presentation

    Slides — MS PowerPoint, Google Slides

  • Database

    Records — MS Access

  • E-mail and calendar

    Outlook, Gmail

  • Cloud storage

    OneDrive, Google Drive

ComparisonDesktop vs cloud office suites
Desktop (MS Office)
Cloud (Google Workspace, Microsoft 365 web)

Access

Installed on the computer

Browser, any device

Collaboration

Limited — share files

Real-time co-editing and comments

Cost

Licence

Free or subscription

Offline use

Full

Limited

Features

Most advanced

Simpler but improving

Key termsCommon interface elements
Ribbon
Tabs of commands (Home, Insert, Layout…)
Quick Access Toolbar
Save, Undo, Redo
Status bar
Page, word count, zoom
Backstage view
File menu — Save, Print, Share
Dialog launcher
Small arrow opening more options
Tell me / Search
Find any command by typing

Example

A college office: the admission letter is typed once in a word processor and personalised for 300 students with mail merge. Fee records are kept in a spreadsheet that totals them automatically. The orientation talk is given with presentation software, and notices are sent by email.

2

Topic 2

Word processing: resumes

A resume (CV) is a one- or two-page summary of your education, skills and experience.

ProcessCreating a resume in Word
  1. 1

    File → New → search "Resume" for a template, or start with a blank document

  2. 2

    Set margins (Layout → Margins → Narrow or Moderate)

  3. 3

    Add the name as a large heading, then contact details in one line

  4. 4

    Use headings — Objective, Education, Skills, Projects, Experience, Achievements

  5. 5

    Use bullet points with action verbs and numbers

  6. 6

    Align dates with a right tab stop

  7. 7

    Add borders or shading to section headings

  8. 8

    Proofread, check one-page length, save as PDF

Key termsResume formatting tools
Font and size
Calibri or Arial 10–12 pt; name 16–20 pt
Alignment
Left for text, right tab for dates
Paragraph spacing
Space before and after headings, line spacing 1.0–1.15
Bullets and numbering
Home → Bullets
Borders and shading
Home → Borders
Tables
Two-column layouts without visible borders
Page border and colours
Keep minimal and professional
Save as PDF
File → Save As → PDF keeps the layout
ComparisonResume dos and don'ts
Do
Don't

Content

Be concise; quantify results ("increased sales by 20%")

Write long paragraphs or personal details such as religion

Format

Consistent fonts and spacing; one page for freshers

Use many colours or clip art

Contact

Professional e-mail address

Nicknames

Check

Proofread and spell-check

Leave typing errors

Example

Example resume skeleton: Name — Phone — Email — LinkedIn; Objective (2 lines); Education (BCA, SBS Synetic College, 2023–26, CGPA); Technical skills (C, SQL, Excel); Projects; Certifications; Achievements.

3

Topic 3

Word processing: assignments

ProcessPreparing an assignment
  1. 1

    Set page size A4 and margins 1 inch

  2. 2

    Apply a title and heading styles

  3. 3

    Write text with 1.5 line spacing and justified alignment

  4. 4

    Add tables, figures and captions

  5. 5

    Insert page numbers, headers and footers

  6. 6

    Create references and a table of contents

  7. 7

    Review with track changes and comments

  8. 8

    Print or save as PDF

ComparisonStyles in Word
Use
How

Title and Heading 1, 2, 3

Structure a document; make the table of contents

Home → Styles gallery

Normal

Body text

Set font and spacing once

Modify a style

Change all headings at once

Right-click style → Modify

Themes

Consistent fonts and colours

Design → Themes

ClassificationAssignment features
Document features
  • Table of contents

    References → Table of Contents (uses heading styles)

  • Tables

    Insert → Table; merge cells, borders, shading, sort

  • Bullets and numbering

    Lists and multilevel lists

  • Hyperlinks

    Insert → Link (Ctrl+K): web page, file, e-mail, place in document

  • Footnotes and citations

    References → Insert Footnote; Citations (APA, MLA)

  • Headers, footers and page numbers

    Insert → Header & Footer

  • Page layout

    Orientation, columns, breaks

Tables, bullets and hyperlinks

Key termsWorking with tables
Insert
Insert → Table → drag to choose rows and columns
Edit
Insert rows and columns, delete, split or merge cells
Format
Table Design → styles, borders, shading
Layout
Alignment, cell size, AutoFit
Sort and formulas
Layout → Sort; Formula such as =SUM(ABOVE)
Convert
Text to table and table to text
Key termsLists and links
Bullets
Unordered lists
Numbering
Ordered steps
Multilevel list
Outline numbering 1, 1.1, 1.1.1
Hyperlink
Link to a web page, a file, an e-mail address or a bookmark
Bookmark and cross-reference
Jump to a place in the same document
Screen tip
Hover text for a link

Track changes and comments

ProcessReviewing a document with Track Changes
  1. 1

    Review → Track Changes (Ctrl+Shift+E)

  2. 2

    Edits appear as coloured insertions and deletions

  3. 3

    Add comments for suggestions

  4. 4

    The author reviews each change

  5. 5

    Accept or reject — one by one or all

  6. 6

    Turn off Track Changes and save the final copy

ComparisonTrack changes and comments
Track Changes
Comments

Records

Insertions, deletions, formatting

Notes and questions

Action

Accept or reject

Reply and resolve

Display

Simple markup, All markup, No markup

Margin balloons

Use

Editing

Feedback

Example

An automatic table of contents: apply the Heading 1 style to each chapter title and Heading 2 to each section. Then choose References → Table of Contents. Word builds the list with page numbers, and Update Table refreshes it after any change.

Exam tip

Use styles for headings, not manual bold and font size. Styles make the contents list and consistent formatting automatic.

4

Topic 4

Word processing: newsletters

A newsletter is a short periodical with columns, images and headlines.

ProcessCreating a newsletter
  1. 1

    Choose a newsletter template or set A4 layout

  2. 2

    Insert the masthead — title in WordArt or a text box

  3. 3

    Layout → Columns → two or three columns

  4. 4

    Add headlines with heading styles

  5. 5

    Insert pictures (Insert → Pictures) and wrap text around them

  6. 6

    Add text boxes and pull quotes

  7. 7

    Use drop caps and borders

  8. 8

    Insert a section break to change columns

  9. 9

    Check page balance and print or share as PDF

Newsletter design tools

Purpose
ColumnsLayout → Columns — newspaper-style text flow
Section break (continuous)Different column settings on one page
Pictures and online picturesIllustrations; text wrapping options — square, tight, behind text
WordArtDecorative heading text
Text boxFloating text for sidebars and quotes
Drop capLarge first letter of a paragraph
SmartArt and shapesDiagrams
Borders and shadingSeparate stories
Key termsLayout tips
Alignment
Keep images aligned with column edges
White space
Leave margins and gaps
Fonts
Two fonts at most
Consistency
Same heading style throughout
Balance
Spread pictures and text evenly

Example

A two-page class newsletter: set two columns from Layout → Columns, put the title in WordArt across the top, insert a photo with Square text wrapping, start the first article with a drop cap, and add a page border.

5

Topic 5

Word processing: feedback forms and mail merge

ClassificationFeedback forms in Word
Forms
  • Content controls (Developer tab)

    Plain text, drop-down list, combo box, date picker, check box

  • Tables

    Layout of labels and answers

  • Legacy form fields

    Older style text and check box

  • Protection

    Restrict editing so only fields can be filled

  • Online forms

    Microsoft Forms, Google Forms for digital collection

ProcessCreating a fill-in form
  1. 1

    Insert a table for labels and answers

  2. 2

    Enable the Developer tab (File → Options → Customize Ribbon)

  3. 3

    Insert content controls — text, drop-down, date, check box

  4. 4

    Set properties and placeholder text

  5. 5

    Review → Restrict Editing → Filling in forms

  6. 6

    Save as a template (.dotx)

Mail merge produces many personalised documents from one main document and a data source.

ProcessMail merge steps
  1. 1

    Mailings → Start Mail Merge → choose Letters, Labels, Envelopes or E-mail

  2. 2

    Select Recipients → Use an Existing List (Excel sheet) or type a new list

  3. 3

    Write the main document

  4. 4

    Insert Merge Field — «Name», «Class», «Address»

  5. 5

    Preview Results to check each record

  6. 6

    Finish & Merge → Edit Individual Documents or Send E-mail Messages

Parts of a mail merge

Role
Main documentCommon text and layout
Data sourceExcel, Access or Outlook contacts — one record per row, headers in row 1
Merge fieldPlaceholder replaced by data
RulesIF…THEN…ELSE for conditional text
OutputLetters, labels, envelopes, e-mails, directories

Example

A feedback letter "Dear «Name», thank you for attending «Event» on «Date»." merged with 100 rows of data gives 100 personalised letters.

6

Topic 6

Excel: schedulers

Excel stores data in a workbook of worksheets made of rows (1, 2, 3…) and columns (A, B, C…); the intersection is a cell (e.g., B3).

ProcessBuilding a scheduler (timetable or project planner)
  1. 1

    List tasks or subjects in one column and dates or time slots in the header row

  2. 2

    Enter start dates and durations

  3. 3

    Use formulas for end date =Start + Duration

  4. 4

    Use =TODAY() to track the current date

  5. 5

    Apply conditional formatting to colour overdue tasks

  6. 6

    Freeze panes to keep headings visible

  7. 7

    Add data validation to keep entries clean

  8. 8

    Print with titles repeated

TaskStart dateDaysEnd date (= B + C)Status
Design01-Jul506-JulDone
Coding06-Jul1016-JulIn progress
Testing16-Jul420-JulNot started
Key termsScheduler functions
TODAY() and NOW()
Current date and time
WORKDAY(start, days)
End date skipping weekends
NETWORKDAYS(start, end)
Working days between two dates
DATEDIF(start, end, "d")
Days, months or years between dates
Gantt chart
Stacked bar chart of start and duration
Freeze panes and print titles
Keep headings visible

Example

A task tracker: column A has the task, B the due date and C the status. In C2 enter =IF(B2<TODAY(),"Overdue","Pending") and drag it down with the fill handle. Conditional formatting turns every "Overdue" cell red.

7

Topic 7

Excel: formulae and cell referencing

A formula starts with = and combines values, cell references, operators and functions. Operators in formulas

Example
Arithmetic+ − * / ^ → =A1*B1
Comparison= > < >= <= <> → =A1>B1
Text join& → =A1&" "&B1
Range and union: and , → =SUM(A1:A5)
ComparisonTypes of cell references
Behaviour when copied
Example

Relative

Changes with the new position

A1 copied down becomes A2

Absolute

Stays fixed (use $ or press F4)

$A$1

Mixed

Row or column fixed

$A1 or A$1

Other sheet

Sheet name before the cell

Sheet2!B3

Example

Marks in B2:B6, maximum marks in D1: percentage =B2/$D$1 copied down keeps D1 fixed while B2 changes to B3, B4…

Commonly used functions

Purpose and example
SUMTotal — =SUM(B2:B6)
AVERAGEMean — =AVERAGE(B2:B6)
MAX and MINHighest and lowest
COUNT and COUNTANumbers and non-empty cells
IFDecision — =IF(B2>=40,"Pass","Fail")
Nested IF and IFSGrades — =IFS(B2>=90,"A",B2>=75,"B",B2>=40,"C",TRUE,"F")
COUNTIF and SUMIFConditional count and sum — =COUNTIF(C2:C20,"Pass")
VLOOKUP and XLOOKUPFind data in a table — =VLOOKUP(A2,Table,2,FALSE)
RANKPosition — =RANK(B2,B$2:B$20)
ROUNDRound — =ROUND(B2,0)
TextLEFT, RIGHT, MID, LEN, UPPER, CONCAT
DateTODAY, DAY, MONTH, YEAR
ProcessCorrecting formula errors
  1. 1

    #DIV/0! — divisor is zero or empty

  2. 2

    #NAME? — wrong function name

  3. 3

    #REF! — referenced cell deleted

  4. 4

    #VALUE! — wrong data type

  5. 5

    #N/A — lookup value not found

  6. 6

    ##### — column too narrow

  7. 7

    Use Formulas → Evaluate Formula and Trace Precedents

8

Topic 8

Excel: performance analysis — sorting and conditional formatting

ProcessAnalysing student performance
  1. 1

    Enter marks with headings

  2. 2

    Compute Total =SUM(), Percentage and Grade =IF()

  3. 3

    Rank students with RANK

  4. 4

    Sort by Total — largest first

  5. 5

    Filter to see only "Fail"

  6. 6

    Highlight with conditional formatting

  7. 7

    Create a column chart of subject averages

Sorting and filtering

Meaning
SortHome → Sort & Filter — ascending, descending or custom (multiple levels)
FilterShow only rows meeting a condition
Advanced filterComplex criteria in a separate range
SubtotalsGroup and total after sorting
Remove duplicatesData → Remove Duplicates
Key termsConditional formatting rules
Highlight cells rules
Greater than, less than, between, text contains, duplicate values
Top/bottom rules
Top 10, above average
Data bars
Bar length shows value
Colour scales
Red–yellow–green gradient
Icon sets
Arrows, traffic lights
Formula-based
=$E2="Fail" colours a whole row
Manage rules
Edit, delete, order

Chart types

Best for
Column and barComparing categories (subject-wise marks)
LineTrend over time (monthly sales)
PieShare of a whole (one series)
ScatterRelationship between two numbers
ComboTwo measures with different scales

Example

A marks sheet: with five subject marks in B2:F2, =SUM(B2:F2) gives the total, =AVERAGE(B2:F2) the average, =IF(MIN(B2:F2)>=40,"Pass","Fail") the result and =RANK(G2,$G$2:$G$31) the rank among 30 students. Conditional formatting highlights marks below 40 in red.

Exam tip

The $ signs in $G$2:$G$31 make the range absolute, so it does not shift when the formula is copied down.

9

Topic 9

Excel: pivot tables and data validation

A PivotTable summarises a large table in a few clicks without writing formulas.

ProcessCreating a PivotTable
  1. 1

    Make sure data has headings and no blank rows

  2. 2

    Click inside the data → Insert → PivotTable

  3. 3

    Choose a new or existing worksheet

  4. 4

    Drag fields into Rows, Columns, Values and Filters

  5. 5

    Change Sum to Count, Average or % in Value Field Settings

  6. 6

    Insert a slicer or timeline for interactive filtering

  7. 7

    Refresh when the source data changes

PivotTable areas

What goes in it
RowsCategories listed down — Region
ColumnsCategories across — Quarter
ValuesNumbers summarised — Sum of Sales
FiltersReport-level filter — Year

Sample PivotTable output

RegionQ1Q2Total
North120150270
South90110200
Grand total210260470
Key termsPivot features
Grouping
Group dates into months or years, numbers into ranges
Calculated field
New field using a formula
PivotChart
Chart linked to the pivot
Slicer
Button filter
Refresh
Right-click → Refresh

Data validation

Data validation (Data → Data Validation) restricts what can be typed into a cell. Types of validation

Example
Whole numberBetween 0 and 100 for marks
DecimalPercentage 0 to 1
ListDrop-down: Yes, No or a range of items
DateAfter 01-Apr-2026
Time and text lengthPhone number length 10
Custom formula=COUNTIF($A:$A,A2)=1 stops duplicates
Key termsValidation settings
Input message
Tip shown when the cell is selected
Error alert
Stop, Warning or Information when the value is invalid
Circle invalid data
Find old wrong entries
Dependent drop-downs
Choose a state then its cities using INDIRECT

Example

Summarise and control: from a list of 500 students, put Course in Rows and Marks in Values set to Average, and the PivotTable shows the average marks of each course at once. With data validation on the Marks column (whole number between 0 and 100), typing 105 is rejected with an error message.

10

Topic 10

PowerPoint: slide layouts, multimedia, master layouts, animation and transitions

ProcessCreating a presentation
  1. 1

    Plan the message — one idea per slide

  2. 2

    Choose a theme (Design tab)

  3. 3

    Add slides with layouts — Title, Title and Content, Two Content, Section Header

  4. 4

    Insert text, pictures, tables, charts and SmartArt

  5. 5

    Insert audio, video or screen recording

  6. 6

    Apply animations and transitions

  7. 7

    Rehearse timings

  8. 8

    Slide Show (F5) and export to PDF or video

Slide layouts

Used for
Title SlideOpening slide
Title and ContentBullets, table, chart, picture
Section HeaderDivide topics
Two Content and ComparisonSide-by-side points
Title Only and BlankCustom designs
Key termsInserting multimedia
Pictures and icons
Insert → Pictures, Icons
Audio
Record or insert music; Play across slides
Video
Embed from file or link; trim video
Screen recording
Insert → Screen Recording
Links and actions
Hyperlink to a slide or a website
Compress media
File → Compress Media to reduce size

Slide master

ClassificationSlide master (View → Slide Master)
Slide master
  • Slide master

    Fonts, colours and background for all slides

  • Layouts

    Each layout can be changed

  • Placeholders

    Title, text, date, footer, slide number

  • Logo

    Put once on master — appears on every slide

  • Themes

    Color and font sets

  • Handout and notes masters

    For printing

Example

To add the college logo to every slide, place it on the Slide Master, not on each slide.

Animation and transitions

ComparisonAnimation vs transition
Animation
Transition

Applies to

Objects on a slide (text, shape, picture)

Change from one slide to the next

Tab

Animations

Transitions

Types

Entrance, Emphasis, Exit, Motion path

Fade, Push, Wipe, Morph, Zoom

Timing

On click, With previous, After previous

Duration, sound, advance on click or time

Pane

Animation Pane

Apply to all

Key termsPresentation tips
Text
Six lines by six words at most; font 24 pt or more
Contrast
Dark text on a light background or the reverse
Visuals
One chart or picture beats a paragraph
Consistency
Same fonts and colours
Animation
Use sparingly
Practice
Rehearse Timings; keep 1–2 minutes per slide
Speaker notes
Notes pane for what to say
11

Topic 11

Internet basics: e-mail setup

E-mail (electronic mail) sends messages over the internet; an address has the form username@domain.

ProcessSetting up an e-mail account in an app
  1. 1

    Create the account (Gmail, Outlook, Yahoo) with a strong password and two-step verification

  2. 2

    Open the e-mail client (Outlook, Mail, Thunderbird) → Add account

  3. 3

    Enter the address and password

  4. 4

    The app finds the incoming and outgoing servers, or enter them manually

  5. 5

    Test by sending a message to yourself

  6. 6

    Add a signature and set up the folder structure

E-mail protocols

Role
SMTPSends mail (port 587 with TLS, 465 SSL)
IMAPReads mail and keeps it on the server — syncs across devices (port 993)
POP3Downloads mail to one device (port 995)
Key termsParts of an e-mail
To, Cc, Bcc
Main recipients, copy, hidden copy
Subject
Short clear title
Body
Message
Attachment
Files up to about 25 MB in Gmail
Signature
Name and contact
Folders and labels
Inbox, Sent, Drafts, Spam
Reply, Reply all and Forward
Answer one person, everyone, or send on
ClassificationE-mail etiquette and safety
Good practice
  • Write a clear subject and short message

  • Use a polite tone and proper greetings

  • Check attachments and recipients before sending

  • Avoid ALL CAPS

  • Never share passwords

  • Beware phishing — do not click suspicious links

  • Use two-step verification

Example

To, CC and BCC: a student emails an assignment to the teacher (To), copies the class representative (CC, visible to all) and sends a hidden copy to a personal address (BCC, not visible to the others). SMTP sends the message; IMAP or POP3 is used to receive it.

Exam tip

IMAP keeps mail on the server and syncs it across devices. POP3 downloads it to one device.

12

Topic 12

Internet basics: blogging

A blog is a website of regularly updated posts shown with the newest first.

ProcessCreating a blog
  1. 1

    Choose a topic and audience

  2. 2

    Pick a platform — Blogger, WordPress.com, Medium

  3. 3

    Sign in and create the blog with a title and address

  4. 4

    Choose a theme

  5. 5

    Write a post — title, text, images and links

  6. 6

    Add labels or tags and a description

  7. 7

    Preview and publish

  8. 8

    Share the link and reply to comments

Popular blogging platforms

Features
BloggerFree; Google account; simple
WordPress.comThemes and plugins; free and paid plans
MediumSimple writing and built-in readers
TumblrShort posts and media
Key termsBlogging terms
Post and page
Dated article versus fixed page
Category and tag
Group posts
Permalink
Permanent link of a post
Comments
Reader feedback
SEO
Titles and keywords that help search engines
Blogosphere
The community of blogs
Vlog and microblog
Video and short-text blogs

Example

Starting a blog: a student signs up on Blogger or WordPress, picks a title and template, writes a first post on "Five tips for first-year BCA students", adds a picture and labels (tags), and publishes. Readers can comment, and each new post appears at the top.

13

Topic 13

Internet basics: online banking

ClassificationOnline banking services
Internet and mobile banking
  • Account services

    Balance, mini-statement, e-statement, cheque book request

  • Fund transfer

    NEFT, RTGS, IMPS, UPI

  • Payments

    Bills, recharge, FASTag, taxes

  • Deposits and loans

    Open FD or RD, apply for a loan

  • Cards

    Block, set limits

  • Investments

    Mutual funds, insurance

NEFT, RTGS, IMPS and UPI

Details
NEFTBatch settlement, 24×7, any amount, no minimum
RTGSReal-time, minimum ₹2 lakh, large-value
IMPSInstant, 24×7, mobile and internet
UPIInstant payments through a VPA or QR code using a mobile app, 24×7
ProcessMaking an online fund transfer safely
  1. 1

    Visit the bank's official site or app only

  2. 2

    Log in with user ID and password, then OTP

  3. 3

    Add the beneficiary and wait for activation

  4. 4

    Choose the transfer mode and enter the amount

  5. 5

    Verify the details

  6. 6

    Confirm with OTP or MPIN

  7. 7

    Note the transaction reference and check the SMS

ClassificationSecurity tips for online banking
Safe banking
  • Never share OTP, PIN or CVV with anyone

  • Check the padlock and HTTPS in the address bar

  • Do not use public Wi-Fi for banking

  • Avoid clicking links in messages — beware phishing, vishing and fake apps

  • Use strong unique passwords and enable alerts

  • Log out after use

  • Report fraud at once — call 1930 or visit cybercrime.gov.in

Example

Choosing a payment method: paying a friend ₹500 at once → UPI. Sending ₹50,000 to a relative any time → IMPS or NEFT. Transferring ₹5 lakh for a property payment → RTGS, which is meant for ₹2 lakh and above and settles each transaction individually in real time.

Exam tip

Never share your OTP, PIN or password, and check for https and the padlock before logging in.

Key terms

Mail merge
Producing personalised documents from a template and a data list
Style
Saved set of formatting applied with one click
Track changes
Feature that records edits for review
Relative reference
Cell reference that changes when copied
Absolute reference
Reference fixed with $ signs
Conditional formatting
Formatting applied when a condition is met
PivotTable
Interactive summary of a data table
Data validation
Rules restricting what can be entered in a cell
Slide master
Template controlling the look of all slides
IMAP
Protocol that keeps e-mail on the server and syncs devices
UPI
Unified Payments Interface for instant mobile payments

Quick revision

  • Word: styles and headings → table of contents; Track Changes; columns and WordArt for newsletters; mail merge = main document + data source + merge fields.
  • Excel: = starts a formula; A1 relative, $A$1 absolute; IF, SUM, COUNTIF, VLOOKUP; conditional formatting; PivotTable (Rows, Columns, Values, Filters); data validation (list, whole number, custom).
  • PowerPoint: layouts, slide master for common elements, animation (objects) vs transition (slides).
  • E-mail: SMTP sends, IMAP syncs, POP3 downloads; blog platforms; NEFT, RTGS, IMPS, UPI; never share OTP.

Important exam questions

Practice questions written to the PTU exam pattern for this unit's syllabus: short answers (Section A style) and long answers (Sections B and C style).

Short-answer questions

  1. Q1.What is a style in Word? Why use it?
  2. Q2.What is mail merge? Name its components.
  3. Q3.Differentiate between relative and absolute cell references.
  4. Q4.Write a formula to give Pass or Fail for marks in B2 with passing marks 40.
  5. Q5.What is conditional formatting?
  6. Q6.What is a PivotTable?
  7. Q7.What is data validation? Give an example.
  8. Q8.Differentiate between animation and transition in PowerPoint.
  9. Q9.What is the slide master?
  10. Q10.Differentiate between IMAP and POP3.
  11. Q11.Name four online fund transfer modes.
  12. Q12.Mention two safety rules for online banking.

Long-answer questions

  1. Q1.Explain how to create a resume and an assignment in MS Word with the features used.
  2. Q2.Explain the steps to create a newsletter and a mail-merged feedback letter.
  3. Q3.Explain cell referencing and the commonly used Excel functions with examples.
  4. Q4.Explain sorting, conditional formatting, PivotTables and data validation in Excel with a performance-analysis example.
  5. Q5.Explain the steps to create a presentation with master layout, multimedia, animation and transitions.
  6. Q6.Explain e-mail setup, blogging and online banking with precautions.

Stuck on this unit?

Message SBS on WhatsApp for help with Office Automation, or to ask about studying BCA at Synetic.

WhatsApp us