Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Office Automation Office Automation, Exams of Computer Science

Office Automation by Dr.P.Rizwan Ahmed

Typology: Exams

2017/2018
On special offer
30 Points
Discount

Limited-time offer


Uploaded on 10/28/2018

Dr.Rizwan.Ahmed
Dr.Rizwan.Ahmed 🇮🇳

3.3

(29)

17 documents

1 / 7

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Office Automation
(Computer Fundamentals, MS-Word 2010, MS-Excel 2010, MS-Access 2010, MS-
PowerPoint2010, Business Engineering and ERP)
By
Dr.P.Rizwan Ahmed, MCA., M.Sc.,M.A, M.Phil., Ph.D,
Head of the Department
Department of Computer Applications &
Post Graduate Dept. of Information Technology
Mazharul Uloom College, Ambur - 635 802
Vellore Dist. Tamil Nadu.
pf3
pf4
pf5
Discount

On special offer

Partial preview of the text

Download Office Automation Office Automation and more Exams Computer Science in PDF only on Docsity!

Office Automation

(Computer Fundamentals, MS-Word 2010, MS-Excel 2010, MS-Access 2010, MS-

PowerPoint2010, Business Engineering and ERP)

By

Dr.P.Rizwan Ahmed, MCA., M.Sc.,M.A, M.Phil., Ph.D,

Head of the Department

Department of Computer Applications &

Post Graduate Dept. of Information Technology

Mazharul Uloom College, Ambur - 635 802

Vellore Dist. Tamil Nadu.

CONTENTS Preface Acknowledgement

Chapter 1 Introduction to Computers

1.1 Introduction 1.2 Meaning and Definition 1.3Capabilities of Computer 1.4 Characteristics of a Computer 1.5 Block diagram of Computer 1.6 Generation of Computers 1.7 Difference between the Generations of Computers 1.8 Types of Computers / Classification of Computers 1.8.1 On the basis of working principle 1.8.2 On the basis of Size and Capacity 1.9 The Parts of a Computer System 1.10 Input Device 1.10.1 Types of Input Devices 1.10.1.1 Keyboard 1.10.1.2 Mouse 1.10.1.3 Scanners 1.10.1.4 Joystick 1.10.1.5 Light Pen 1.10.1.6 Touch Screen 1.10.1.7 Magnetic-ink character recognition (MICR) 1.10.1.8 Optical Mark Reader (OMR) 1.10.1.9 Optical Character Recognition (OCR) 1.10.1.10 Optical Bar Code Reader (OBR) 1.11 Output Devices 1.11.1 Classification of Output Devices 1.11.1.1 Dot Matrix Printer 1.11.1.2 Inkjet Printer 1.11.1.3 Laser Printers 1.11.2 LCD Monitor 1.12 Computer Languages 1.12.1 Classification of Programming Languages 1.12.2 Difference between machine, assembly and High-level language 1.13 Generation of Programming Language 1.14 Operating System

2.9.5 Inserting Rows and Columns 2.9.6 Resizing Rows and Columns 2.9.7 Merging and Splitting Cells 2.9.8 Sorting Table Data 2.9.9 Deleting Rows and Columns 2.9.10 Deleting Tables 2.10 Creating Outlines in Word 2.11 Mail Merge / Creating Customized Merge Documents 2.12 Adding reference to documents 2.13 Working with Complex Documents 2.13.1Section breaks 2.13.2 Creating a Table of Contents 2.14 Preparing a document for distribution Summary Review Questions Chapter 3 MS Excel 2010 3.1 Introduction 3.2 Starting Excel 2010 3.3 Creating Excel Worksheet 3.4 Entering and Editing Cell Entries 3.5 Working with Numbers 3.6 Inserting and deleting of cells, Rows and columns 3.7 Moving, Copying, Inserting and Deleting Worksheet 3.8 Changing Worksheet Layout 3.9 Other Formatting options / Formatting a Worksheet 3.10 Printing in Excel 3.11 Using Functions and Reference 3.12 Naming Ranges 3.13 Working and entering a Formula 3.14 Creating Charts 3.15 Using Custom and Special Effects 3.16 Elements of an Excel chart 3.17 Using Financial and Statistical Functions 3.18 Tracking and analyzing data with Excel 3.19 Auditing a Worksheet Summary Review Questions

Chapter 4 MS Access 2010 4.1 Introduction 4.2 Objectives of Access Database 4.3 Parts of Access Window 4.4 Starting Microsoft Access 4.5 Creating a new database 4.6 Creating table through design window 4.7 Queries 4.8 Creating a Form 4.9 Reports Summary Review Questions Chapter 5 MS PowerPoint 2010 5.1 PowerPoint 2010 5.2 Starting PowerPoint 5.3 Creating PowerPoint Presentation 5.3.1Creating a basic Presentation 5.3.1.1 Blank Presentation 5.3.1.2 Adding Text 5.3.1.3Insert a New Slide 5.3.1.4 Rearrange the order of slides 5.3.1.5 Delete a Slide 5.3.1.6Copy a Slide 5.3.1.7 Hide a Slide 5.3.1.8 Saving and Closing a Presentation 5.3.1.9 Closing a Presentation 5.3.1.10 Running a Presentation 5.4 Create a presentation Using template 5.5 Open an Existing Presentation 5.6 Building Presentation 5.7 Modifying Visual Elements 5.8 Formatting and Checking Text 5.9 Using Headers and Footers 5.10 Adding Objects 5.11 Applying Transitions 5.12 Animation Effects 5.13 Preparing Handouts Summary Review Questions

7.10.1 Formatting the Link 7.11 Adding Graphics to HTML documents 7.11.1 Image Attributes 7.12 Frames 7.12.1 Tag 7.12.2 Attributes Summary Review Questions