Sheet Tabs for MS Excel

Sheet Tabs. 
               File Tab : When clicked,  this button opens the File menu, from which you can open,  save,  print,  and exit as well as the Excel Options button that enables you to change Excel's default settings.

• Quick Access Toolbar : A small toolbar next to the File Tab contains shortcuts for some of the most common commands such as Save,  Undo,  and Redo buttons.  You also can customize quick access toolbar. 
• Ribbon: A combination of old versions menu bar and toolbar;  arranged into a series of tabs ranging from Home through View.  Each tab contains buttons,  lists and commands. 
• Name boc: Displayed the address of the current active cell where you work in the shows you the current cell's contents, 
• Worksheet area: This area contains all the cells of the current worksheet identified by column headings,  using letters along the top,  and row heading,  using numbers along the left edge with tabs for selecting new worksheets. 
• Sheet tabs : Excel 2010 contains 3 blank worksheet tabs by default.  Click on the intended table will go to the particular worksheet. 
• Status bar : Reports information about the worksheet and provides shortcuts for changing the view and the zoom. 
• Zoom control: Use to zoom the Excel screen in or  out by dragging the slider. 

Shortcut Keys 

Open for MS Excel

Open 
Click on the Start button, point to All Programs then Microsoft Office and click on Microsoft Office Excel 2010
Excel sheet consists of rows and columns.
               One sheet consists of 16,484 columns named as A,B,C.........,XFD and 10,48,576rows named as 1,2,3,....,,,.,...44354 Intersection of row and column is known as cell is labeled by giving the columnname followed by row name. For example : A67 is cell formed when A column intersected with 67" row. 

Introduction for MS EXCEL

Introduction 
             The Microsoft Office Excel 2010 is a member of the Microsoft Office 2010 suite of programs.  It is a powerful tool for analyzing,  sharing,  and managing information to help you make more informed decisions -
        The first impression when you open the program - brand -new Ribbon use interface being introduced to replaced the old menus,
As part of the new and improved Excel 2010 user interface,  the program includes all sorts of graphical improvements such as Live Preview,  Page Layout and full of pop-up galleries that make spreadsheet formatting and charting a real easy.
Objective :
After going through this unit,  you will be able to

• Understand the features of excel
• Navigation worksheets 
• Make different type of entries in a worksheet 
• Create text,  Numbers & data series
• Manipulate cells 
• Create small budgets/sales reports 

Assignments for MS Word

Assignments :

A)  Create a new document with the following text. 
                  Many people who use HTML to create We pages or other documents find notepad 3 useful tool for writing in HTML.  Because Notepad supports only very basic formatting,  you cannot accidently save special formatting in documents that need to remain pure text.  This is specially useful when creating HTML documents for a Web page because special characters or other formatting may not appear in your published Web page.

1. Change the Heading "HTML and Web Pages" to bold,    ,
2. Apply Alignment to contain so that the text is justified. 
3. Bold all occurrence of the word HTML in the document. 
4. Give each line spacing 1.5
5. Save the document as Testi. doc of your computer D:\drive own folder, 

B)  Open the document Text. doc created in the previous exercise and 

1. Save the Document as "Test2. doc"
2. Change the font of the Text to "Verdana"
3. Change the Line Spacing to 2.0 Line 
4. This Paragraph in the Square and suitable color. 
5. Center aligns in the Heading. 
6. Save the Document. 

C)  Creating the Following Table:

Display on the Customize status bar menu for MS Word

Display on the Customize statistics bar menu 

• The menu's option are endless (selected)  when 3 check mark appears next to them. 
• The items at the top of the menu (from Formatted Page Number to Word Count) display information about your document. 
• The options from Caps Lock down through Macro Recording are used to turn off or on those features. 

The last three option on the menu control whether the View or Zoom shortcuts appear on the status bar
Note : You can try to check or select the available options in the Customize Status Bar and see the changes to your documents 

Word Status Bar for MS Word

Word Status Bar 
               The Word status bar is the area at the bottom of the Word window that gives information and some controls on the current document.  It displays information about what page you are on,  line number on the page,  total words in the document, etc.  It also shows other information about which editing toggles you have turned on or you can turn it off if you don't need the information provided shows on the status bar Right-clicking the status bar produces the helpful Customize Status Bar menu.  The Customize Status Bar menu does two things :

• It controls what you see on the status bar,  informational toolbars as well as certain controls.  It let's you turn on or off some Word features. 

Make changes to the letters for MS Word

Make changes to the letters 

• From the Finish group, click the Finish & Merge icon and from the menu appears, select Edit Individual Documents...
• From the Merge to New Document dialog box displayed, make the appropriate selection. 
• Once finish, click OK. 
• Cake the appropriate changes in the new document that appears and save the documents