MS Office at a Glance
A. Fill in the blanks:
1. Microsoft Office is designed to create a productive and an efficient work environment.
2. The Ribbon comprises of tabs, groups and commands.
3. Microsoft Word is a tool which is used to create professional looking documents.
4. MS Excel can be used for calculation, database management and preparation of charts.
5. Charts is a pictorial representation of data.
B. State true or false.
1. In case of MS Word, the default file name is Document1 whereas in MS Excel, the default file name is Book1. [T]
2. The user can not customise the Quick Access Tool Bar according to their individual requirements. [F]
3. A file in MS Excel is called a worksheet. [F]
4. Power Point is a multimedia application. [T]
5. Spreadsheet is a computer program that helps you to do drawing only. [F]
C. Write the short cut keys for the following:
1. To open an already existing file.
= Ctrl + O
2. Microsoft Word Help.
= F1
3. To select the entire text.
= Ctrl + A
4. To print a file.
= Ctrl + P
5. To cut any data from a slide.
= Ctrl + X
D. Match the following:
=
|
1. MS Word |
a. Desktop publishing application. [4] |
|
2. MS Power Point |
b. Database Management. [5] |
|
3. MS Excel |
c. Presentation Application. [2] |
|
4. MS Publisher |
d. Spreadsheet Application. [3] |
|
5. MS Access |
e. Word Processing Application. [1] |
E. Answer the following questions:
1. List the different components of MS Office.
= The different components of MS Office are MS Word, MS Excel, MS PowerPoint, MS Access, MS Outlook, MS Publisher, MS One-note etc.
2. What is the use of MS Word?
= MS Word is a word processing tool which can include text, graphics, table, Clip Art, borders shedding etc. These documents can be created, saved, edited and printed as when required.
3. write down the steps of using transactions to a slide.
= Step 1: Select any new in the status bar.
Step 2: Select transition Tab.
Step 3: Select any style from the Transition to This Slide group drop-down list.
Step 4: Use the Transitions Sound and use the duration.
4. Explain any three important features of MS Excel.
= Important features of MS Excel are -
Calculation: MS Excel has got many built-in formula for sum, average, minimum, etc. We can use those formula as per our needs.
Data sorting: Data sorting is the process of arranging data in some logical order. MS Excel allows us to sort data in ascending or descending order.
Create different charts: MS Excel allows us to create different charts as bar graph, pie-charts, line graph to analyse and compare data very easily.
5. List the components that are common in the windows of all the applications of MS Office.
= The components that are common in the windows of all the applications of MS officer are - title bar, Ribbon, quick access toolbar, status Bar, horizontal scroll bar, vertical scroll bar, minimise button, maximize, restore down button, close button.
6. What is spreadsheet?
= A file in MS Excel contains many pages which are called spreadsheet.
7. What do you mean by cell address?
= The intersection of row and column is called cell. It is referred by an address called as the cell address. For example B12 F33 AB5 etc.
8. What do you mean by Database Management?
= Database Management is extremely important when one has to deal with a large amount of data about hundreds or thousands of records. It helps us to create ,edit ,sort and filter data according to our needs.
9. Discuss any two components of MS Office 2010 window.
= Horizontal scrollbar: It helps us to scroll to the left or the right to see that which are currently not visible on the screen.
Vertical scrollbar: It helps you to scroll to the top or the bottom of the screen.