MS Office Question Bank

MS Office Question Bank

MS Office Question Bank

Bellow is the Syllabus for Office Automation Course:

Computer Hardware Introduction

- Fundamentals to Computer

- Software and Hardware Definition

- Computer Language

- Input & Output Devices

- Parts of computers and their functions

- Secondary Storage Devices (CD, DVD, Pen Drive etc.)

- Computer Properties

- Hard Disk Properties

- Change Desktop Background

 

MS Word 2021 or Higher

- Introduction Of MS Word

- MS Word- How to Create a New Document,

- Open File, Using Save & Save as Option in MS Word

- Difference Between Save & Save as

- How to Print Particular Page or Paragraph in MS Word

- How to Cancel Print command

- Create Folder, Different Delete & Backspace key

- Using Pen drive & Antivirus Scan

- Difference Paste or Paste Shortcut

- Page Setup

- Font Setting

- Paragraph Setting

- Page Background

- Insert Table

- Picture

- Clipart

- Shape

- Smart Art

- Screenshot

- Hyperlink

- Bookmark

- Header & Footer

- End Note & Foot Note

- Insert Cover Page

- Blank Page

- Page Break

- Text Box

- Drop Cap

- Date & Time

- Object

- Equation

- Symbol

- View Menu- Ruler, Gridlines, Navigation Pane, Zoom

- Editing- Find, Replace, Select

- Clipboard- copy, cut, paste, Format Painter

- Protect the file

- Create PDF File

- Restrict Editing

- Spelling and Grammar

 

Advance Word

- Function Keys

- Tab Setting

-  Comment

- New Window

- Macro

- Mail Merge

- Envelopes

- Labels

- How to Compare two documents

- Track Changes

- Speed Checking

- Styles

- Table of Content

- Cross Reference

- Signature Line

 

Professional MS Excel 2021 or Higher

- Introduction of MS Excel

- Auto Fill

- nsert row and column

- Change row height and column

- Delete row and column

- Hide and unhide row column

- Fill Option

- Sheet (insert new sheet, rename, duplicate sheet,  change position, delete)

- Sort

- Custom short

- Filter

- Merge and center

- Wrap text

- Arrange window

- Split window

- Freeze pane

- Zoom option

- Page Layout

- Scale  to fit

- Sheet option

- Header and footer

- Watermark

- Protect sheet

- Protect Workbook

- Protect File

- Comment

- Remove Duplicate

- Chart 

- Auto sum

- Average formula

- Min and max

- LEN

- Change case (Upper, Lower, Proper)

- Product

- Count, Counta, Countblank

- Fact formula

- Power

- Sqrt

- Today

- Now

- Round, Roundup, Round down

- Even or odd

- Mod

- Quotient

- Countif

- And formula

- Or formula

- Discount

- Percentage

- Left/Right

- Goal seek

- Sumif


MS Power Point 2021 or Higher

 - Introduction of Power Point

- Short Commands of MS Power Point

- New presentation

- New slides

- Changing slides order

- Themes

- Photo album

- Edit Photo album

 - Slide number

-Insert video audio

- Transition

- Animation

- Clock project

- Create a clipart image

- Convert power point file to video 

 

Windows 10 or Higher

- Scanning

- Hide/Unhide files or folder

- Why computer speed go slow & than what will You do.

- Defragmenter

- Disk Cleanup     

- Fonts Installation

- WinZip

 

Advance Internet

- Theory of Internet

- Searching

- You Tube

- Downloading

- E-mail ID Creation

- Attachments

- Compose Mail

- Create Folder

- Change Profile Photo

- Change Password

- Forgot Password

- Signature Line

- Two step verification

- Delete Gmail ID

- Google Mobile App

- Google Map

- SSO ID Creation

- Different type of creation

- Update SSO ID

- Using app of SSO requirement portal Govt. Site

- On Line Form Filling

- Face book

- Instagram

- Digi Loker

- Ola Cab

- Register Railway ID

- Book Ticket

- Cancel Ticket

- Flight Ticket

- Roadways bus booking

- Result Searching

- www.123greeting.com

- www.online-convert.com

- www.udai.gov.in (check Aadhar validity)

 - www.wetransfer.com

- www.fromsmash.com

- www.speedtest.net

- www.epaper.patrika.com

 

Google Earth

- Google Meet

- Zoom Meeting

 

Computer Screen Sharing

- Team Viewer

- Any Desk

 

Online Mobile Recharge

- Airtel, Jio, Vodaphone etc


Duration: 1 Months
Reviewed by 150+ Students
(8 Reviews)
Admission Query