MS Office Tutorial
UNIT - 1
Introduction to Computer
Characteristics of Computer
Application of Computer
Application of Computer
Computer Generations
Types of Computer
Architecture of Computer
input devices
Output devices
Central Processing Unit
Computer Software and Hardware
Types of file and extension
Question & Answer
Computer Fundamental
Introduction to Computer
Characteristics of Computer
Application of Computer
Application of Computer
Computer Generations
Types of Computer
Architecture of Computer
input devices
Output devices
Central Processing Unit
Computer Software and Hardware
Types of file and extension
Question & Answer
UNIT - 2
Introduction to Operating System
Types of Operating System
Common DOS Commands
Operating systems for mobile phones
System Tools
Question & Answer
Operating system
Introduction to Operating System
Types of Operating System
Common DOS Commands
Operating systems for mobile phones
System Tools
Question & Answer
UNIT - 3
Introduction to MS Word
Element of MS Word Window
Creating Document
Saving Document
Undo and Repeat action
Moving text or Graphic Objects
Copying Text or graphic Objects
Find and Replace Text
Formatting Text
Change Text Case
Formatting Paragraph
Bullets and Numbering
Tab Setting
Working With Table
Creating Hyperlink
Insert Header and Footer
Question & Answer
MS Word
Introduction to MS Word
Element of MS Word Window
Creating Document
Saving Document
Undo and Repeat action
Moving text or Graphic Objects
Copying Text or graphic Objects
Find and Replace Text
Formatting Text
Change Text Case
Formatting Paragraph
Bullets and Numbering
Tab Setting
Working With Table
Creating Hyperlink
Insert Header and Footer
Question & Answer
UNIT - 4
Elements of Electronic Spread Sheet
Opening and Closing of Spread Sheet
Addressing of Cells
Printing of Spread Sheet
Saving Workbooks
Manipulation of Cells
Entering Data in Cell
Number and Date Series
Editing Worksheet Data
Inserting and Deleting Rows and Columns
Changing Cell Height and Width
Using Formulas
Function
basic mathematical operators
Working with chart
Conditional Formatting
Question & Answer
MS Excel
Elements of Electronic Spread Sheet
Opening and Closing of Spread Sheet
Addressing of Cells
Printing of Spread Sheet
Saving Workbooks
Manipulation of Cells
Entering Data in Cell
Number and Date Series
Editing Worksheet Data
Inserting and Deleting Rows and Columns
Changing Cell Height and Width
Using Formulas
Function
basic mathematical operators
Working with chart
Conditional Formatting
Question & Answer
UNIT - 5
Basic Concepts of presentation
Opening A Power Point Presentation
Saving A Presentation
Entering and Editing Text
Inserting And Deleting Slides in a Presentation
: Inserting Word Table or An Excel Worksheet
Adding Clip Art Pictures
Inserting Other Objects
Resizing and Scaling an Object
Viewing A Presentation
Choosing a Set Up for Presentation
Printing Slides And Handouts
Running a Slide Show
Transition and Slide Timings,
Automating a Slide Show
Question & Answer
MS Powerpoint
Basic Concepts of presentation
Opening A Power Point Presentation
Saving A Presentation
Entering and Editing Text
Inserting And Deleting Slides in a Presentation
: Inserting Word Table or An Excel Worksheet
Adding Clip Art Pictures
Inserting Other Objects
Resizing and Scaling an Object
Viewing A Presentation
Choosing a Set Up for Presentation
Printing Slides And Handouts
Running a Slide Show
Transition and Slide Timings,
Automating a Slide Show
Question & Answer
UNIT - 6
Introduction to the concepts of database management system
Creating a database
Creating a Table
Concepts of field
field types
entering data in a table
preview and print a table
changing row and column height
closing and opening of table
sorting of table
finding and replacing texts
using queries wizard
creating report from tables / queries from report wizard,
modifying a report
printing of report
creating a form using wizard
entry in the forms
basic of formatting of forms and reports
Question & Answer
MS Access
Introduction to the concepts of database management system
Creating a database
Creating a Table
Concepts of field
field types
entering data in a table
preview and print a table
changing row and column height
closing and opening of table
sorting of table
finding and replacing texts
using queries wizard
creating report from tables / queries from report wizard,
modifying a report
printing of report
creating a form using wizard
entry in the forms
basic of formatting of forms and reports
Question & Answer