Unit 1: Word processing, spreadsheets and presentations
Office Automation notes · PTU syllabus (UGCC2503)
On this page
- Unit summary
- Introduction to office automation
- Word processing: resumes
- Word processing: assignments
- Word processing: newsletters
- Word processing: feedback forms and mail merge
- Excel: schedulers
- Excel: formulae and cell referencing
- Excel: performance analysis — sorting and conditional formatting
- Excel: pivot tables and data validation
- PowerPoint: slide layouts, multimedia, master layouts, animation and transitions
- Internet basics: e-mail setup
- Internet basics: blogging
- Internet basics: online banking
- Key terms
- Quick revision
- 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
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.
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
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
- 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.
Topic 2
Word processing: resumes
A resume (CV) is a one- or two-page summary of your education, skills and experience.
- 1
File → New → search "Resume" for a template, or start with a blank document
- 2
Set margins (Layout → Margins → Narrow or Moderate)
- 3
Add the name as a large heading, then contact details in one line
- 4
Use headings — Objective, Education, Skills, Projects, Experience, Achievements
- 5
Use bullet points with action verbs and numbers
- 6
Align dates with a right tab stop
- 7
Add borders or shading to section headings
- 8
Proofread, check one-page length, save as PDF
- 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
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.
Topic 3
Word processing: assignments
- 1
Set page size A4 and margins 1 inch
- 2
Apply a title and heading styles
- 3
Write text with 1.5 line spacing and justified alignment
- 4
Add tables, figures and captions
- 5
Insert page numbers, headers and footers
- 6
Create references and a table of contents
- 7
Review with track changes and comments
- 8
Print or save as PDF
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
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
- 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
- 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
- 1
Review → Track Changes (Ctrl+Shift+E)
- 2
Edits appear as coloured insertions and deletions
- 3
Add comments for suggestions
- 4
The author reviews each change
- 5
Accept or reject — one by one or all
- 6
Turn off Track Changes and save the final copy
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.
Topic 4
Word processing: newsletters
A newsletter is a short periodical with columns, images and headlines.
- 1
Choose a newsletter template or set A4 layout
- 2
Insert the masthead — title in WordArt or a text box
- 3
Layout → Columns → two or three columns
- 4
Add headlines with heading styles
- 5
Insert pictures (Insert → Pictures) and wrap text around them
- 6
Add text boxes and pull quotes
- 7
Use drop caps and borders
- 8
Insert a section break to change columns
- 9
Check page balance and print or share as PDF
Newsletter design tools
| Purpose | |
|---|---|
| Columns | Layout → Columns — newspaper-style text flow |
| Section break (continuous) | Different column settings on one page |
| Pictures and online pictures | Illustrations; text wrapping options — square, tight, behind text |
| WordArt | Decorative heading text |
| Text box | Floating text for sidebars and quotes |
| Drop cap | Large first letter of a paragraph |
| SmartArt and shapes | Diagrams |
| Borders and shading | Separate stories |
- 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.
Topic 5
Word processing: feedback forms and mail merge
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
- 1
Insert a table for labels and answers
- 2
Enable the Developer tab (File → Options → Customize Ribbon)
- 3
Insert content controls — text, drop-down, date, check box
- 4
Set properties and placeholder text
- 5
Review → Restrict Editing → Filling in forms
- 6
Save as a template (.dotx)
Mail merge produces many personalised documents from one main document and a data source.
- 1
Mailings → Start Mail Merge → choose Letters, Labels, Envelopes or E-mail
- 2
Select Recipients → Use an Existing List (Excel sheet) or type a new list
- 3
Write the main document
- 4
Insert Merge Field — «Name», «Class», «Address»
- 5
Preview Results to check each record
- 6
Finish & Merge → Edit Individual Documents or Send E-mail Messages
Parts of a mail merge
| Role | |
|---|---|
| Main document | Common text and layout |
| Data source | Excel, Access or Outlook contacts — one record per row, headers in row 1 |
| Merge field | Placeholder replaced by data |
| Rules | IF…THEN…ELSE for conditional text |
| Output | Letters, 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.
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).
- 1
List tasks or subjects in one column and dates or time slots in the header row
- 2
Enter start dates and durations
- 3
Use formulas for end date =Start + Duration
- 4
Use =TODAY() to track the current date
- 5
Apply conditional formatting to colour overdue tasks
- 6
Freeze panes to keep headings visible
- 7
Add data validation to keep entries clean
- 8
Print with titles repeated
| Task | Start date | Days | End date (= B + C) | Status |
|---|---|---|---|---|
| Design | 01-Jul | 5 | 06-Jul | Done |
| Coding | 06-Jul | 10 | 16-Jul | In progress |
| Testing | 16-Jul | 4 | 20-Jul | Not started |
- 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.
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) |
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 | |
|---|---|
| SUM | Total — =SUM(B2:B6) |
| AVERAGE | Mean — =AVERAGE(B2:B6) |
| MAX and MIN | Highest and lowest |
| COUNT and COUNTA | Numbers and non-empty cells |
| IF | Decision — =IF(B2>=40,"Pass","Fail") |
| Nested IF and IFS | Grades — =IFS(B2>=90,"A",B2>=75,"B",B2>=40,"C",TRUE,"F") |
| COUNTIF and SUMIF | Conditional count and sum — =COUNTIF(C2:C20,"Pass") |
| VLOOKUP and XLOOKUP | Find data in a table — =VLOOKUP(A2,Table,2,FALSE) |
| RANK | Position — =RANK(B2,B$2:B$20) |
| ROUND | Round — =ROUND(B2,0) |
| Text | LEFT, RIGHT, MID, LEN, UPPER, CONCAT |
| Date | TODAY, DAY, MONTH, YEAR |
- 1
#DIV/0! — divisor is zero or empty
- 2
#NAME? — wrong function name
- 3
#REF! — referenced cell deleted
- 4
#VALUE! — wrong data type
- 5
#N/A — lookup value not found
- 6
##### — column too narrow
- 7
Use Formulas → Evaluate Formula and Trace Precedents
Topic 8
Excel: performance analysis — sorting and conditional formatting
- 1
Enter marks with headings
- 2
Compute Total =SUM(), Percentage and Grade =IF()
- 3
Rank students with RANK
- 4
Sort by Total — largest first
- 5
Filter to see only "Fail"
- 6
Highlight with conditional formatting
- 7
Create a column chart of subject averages
Sorting and filtering
| Meaning | |
|---|---|
| Sort | Home → Sort & Filter — ascending, descending or custom (multiple levels) |
| Filter | Show only rows meeting a condition |
| Advanced filter | Complex criteria in a separate range |
| Subtotals | Group and total after sorting |
| Remove duplicates | Data → Remove Duplicates |
- 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 bar | Comparing categories (subject-wise marks) |
| Line | Trend over time (monthly sales) |
| Pie | Share of a whole (one series) |
| Scatter | Relationship between two numbers |
| Combo | Two 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.
Topic 9
Excel: pivot tables and data validation
A PivotTable summarises a large table in a few clicks without writing formulas.
- 1
Make sure data has headings and no blank rows
- 2
Click inside the data → Insert → PivotTable
- 3
Choose a new or existing worksheet
- 4
Drag fields into Rows, Columns, Values and Filters
- 5
Change Sum to Count, Average or % in Value Field Settings
- 6
Insert a slicer or timeline for interactive filtering
- 7
Refresh when the source data changes
PivotTable areas
| What goes in it | |
|---|---|
| Rows | Categories listed down — Region |
| Columns | Categories across — Quarter |
| Values | Numbers summarised — Sum of Sales |
| Filters | Report-level filter — Year |
Sample PivotTable output
| Region | Q1 | Q2 | Total |
|---|---|---|---|
| North | 120 | 150 | 270 |
| South | 90 | 110 | 200 |
| Grand total | 210 | 260 | 470 |
- 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 number | Between 0 and 100 for marks |
| Decimal | Percentage 0 to 1 |
| List | Drop-down: Yes, No or a range of items |
| Date | After 01-Apr-2026 |
| Time and text length | Phone number length 10 |
| Custom formula | =COUNTIF($A:$A,A2)=1 stops duplicates |
- 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.
Topic 10
PowerPoint: slide layouts, multimedia, master layouts, animation and transitions
- 1
Plan the message — one idea per slide
- 2
Choose a theme (Design tab)
- 3
Add slides with layouts — Title, Title and Content, Two Content, Section Header
- 4
Insert text, pictures, tables, charts and SmartArt
- 5
Insert audio, video or screen recording
- 6
Apply animations and transitions
- 7
Rehearse timings
- 8
Slide Show (F5) and export to PDF or video
Slide layouts
| Used for | |
|---|---|
| Title Slide | Opening slide |
| Title and Content | Bullets, table, chart, picture |
| Section Header | Divide topics |
| Two Content and Comparison | Side-by-side points |
| Title Only and Blank | Custom designs |
- 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
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
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
- 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
Topic 11
Internet basics: e-mail setup
E-mail (electronic mail) sends messages over the internet; an address has the form username@domain.
- 1
Create the account (Gmail, Outlook, Yahoo) with a strong password and two-step verification
- 2
Open the e-mail client (Outlook, Mail, Thunderbird) → Add account
- 3
Enter the address and password
- 4
The app finds the incoming and outgoing servers, or enter them manually
- 5
Test by sending a message to yourself
- 6
Add a signature and set up the folder structure
E-mail protocols
| Role | |
|---|---|
| SMTP | Sends mail (port 587 with TLS, 465 SSL) |
| IMAP | Reads mail and keeps it on the server — syncs across devices (port 993) |
| POP3 | Downloads mail to one device (port 995) |
- 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
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.
Topic 12
Internet basics: blogging
A blog is a website of regularly updated posts shown with the newest first.
- 1
Choose a topic and audience
- 2
Pick a platform — Blogger, WordPress.com, Medium
- 3
Sign in and create the blog with a title and address
- 4
Choose a theme
- 5
Write a post — title, text, images and links
- 6
Add labels or tags and a description
- 7
Preview and publish
- 8
Share the link and reply to comments
Popular blogging platforms
| Features | |
|---|---|
| Blogger | Free; Google account; simple |
| WordPress.com | Themes and plugins; free and paid plans |
| Medium | Simple writing and built-in readers |
| Tumblr | Short posts and media |
- 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.
Topic 13
Internet basics: online 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 | |
|---|---|
| NEFT | Batch settlement, 24×7, any amount, no minimum |
| RTGS | Real-time, minimum ₹2 lakh, large-value |
| IMPS | Instant, 24×7, mobile and internet |
| UPI | Instant payments through a VPA or QR code using a mobile app, 24×7 |
- 1
Visit the bank's official site or app only
- 2
Log in with user ID and password, then OTP
- 3
Add the beneficiary and wait for activation
- 4
Choose the transfer mode and enter the amount
- 5
Verify the details
- 6
Confirm with OTP or MPIN
- 7
Note the transaction reference and check the SMS
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
- Q1.What is a style in Word? Why use it?
- Q2.What is mail merge? Name its components.
- Q3.Differentiate between relative and absolute cell references.
- Q4.Write a formula to give Pass or Fail for marks in B2 with passing marks 40.
- Q5.What is conditional formatting?
- Q6.What is a PivotTable?
- Q7.What is data validation? Give an example.
- Q8.Differentiate between animation and transition in PowerPoint.
- Q9.What is the slide master?
- Q10.Differentiate between IMAP and POP3.
- Q11.Name four online fund transfer modes.
- Q12.Mention two safety rules for online banking.
Long-answer questions
- Q1.Explain how to create a resume and an assignment in MS Word with the features used.
- Q2.Explain the steps to create a newsletter and a mail-merged feedback letter.
- Q3.Explain cell referencing and the commonly used Excel functions with examples.
- Q4.Explain sorting, conditional formatting, PivotTables and data validation in Excel with a performance-analysis example.
- Q5.Explain the steps to create a presentation with master layout, multimedia, animation and transitions.
- 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.
