M.c (11.16.2016)

M.c (11.16.2016)

• 1.
  MANAGERIAL COMPUTING  FORMATINGFEATURE OF MS. WORD  MAIL MERGE  WORKING MS EXCEL FUNCTION  CHARTS & GRAPHS PRESENTED BY: P.LAKSHMAN(160402100005) GUIDEDED BY: R.PRADEEP KUMAR PATNAIK 1
• 2.
  FORMATING FEATURE OFMS. WORD  MAIN SCREEN OF A MICROSOFT WORD.  PAGE SETUP AND MARGIN FORMATTING.  FORMATTING FONT.  FORMATTING SPACING.  PAGE HEADERS.  HANGING INDENT  CENTERING TEXT. 2
• 3.
  3 Font 1. Use 12-pointTimes New Roman or Courier. 2. Use italics sparingly for emphasis instead of bold, underlining, or all capital letters. 3. Eliminate bold text. Margins 1. Use 1-inch margins throughout the paper (top, bottom, sides). 2. Use a ragged right-hand margin (no right justification). Pagination 1. Use automatic pagination. Be sure to have at least two lines of a paragraph at the bottom of a page or at the top of a page. When headings are used, place at least two lines of text with the heading at the bottom of a page. (Avoid placing a heading at the bottom of the page with no other lines of the paragraph.) Spacing 1. Use double spacing throughout, including title page, references, and indented quotations. (Note: Word 2007 places extra space between paragraphs. You will need to adjust this by selecting the Page Layout menu. Then access Paragraph and Indents and Spacing. Under the Spacing heading, set the spacing option to 0 pt. before and 0 pt. after. Click OK.) 2. Use one space after each end punctuation mark. Be consistent throughout the document.
• 4.
  41. MAIN SCREENOF A MICROSOFT WORD.
• 5.
  52. PAGE SETUPANDMARGIN FORMATTING a. From the menu tab at the top of Word, select Page Layout. b. In the Page Layout menu, the margins button will allow you to change the margins to the correct format. c. Select Normal to set all margins to one inch.
• 6.
  63.FORMATTING FONT. a. Selectthe Home tab. b. From the Font menu, you may adjust the font, style, and size to the correct format
• 7.
  74.FORMATTING SPACING
• 8.
  85.PAGE HEADERS a. Clickon the Insert tab. b. Click on the Header tab. c. Click on the Blank header tab from the drop-down menu. This will put the curser inside the header. d. Click on the Page Number tab. e. Place the curser on the drop-down menu over Top of Page to bring up another drop-down menu. f. Click on Plain Number 3 on the drop-down menu (the third choice). This will place a page number inside the header at the right margin. g. Type the portion of the title to go in the header and add five spaces. Your header is complete. h. Click on Close Header and Footer on the far right.
• 9.
  96.HANGING INDENT
• 10.
  107.CENTERING TEXT. The screenshotbelow is an example of text that is centered and that is not centered. In order to center text highlight the text that requires centering and select the icon in the formatting toolbar as shown.
• 11.
  MAIL MERGE  Itis a powerful tool for writing and sending a personalized letter or e-mail to many different people at the same time.  we can also use it to create envelopes or labels with each recipient‘s information.  It imports data from another source such as “Excel”.  Then uses that data to replace placeholders throughout your message with the relevant information for each individual you are messaging.  You can use it to quickly create personalized messages for hundreds of people at once. 11
• 12.
  1. Starting Document 2.Select Starting Document 3. Select Recipients 4. Write Your Letter 5. Preview Your Letter 6. Complete The Merge STEPS OF MAIL MERGE 12 • LETTERS • E-MAIL MESSAGES • ENVELOPES • LABELS • DICTONARY • USE THE CURRENT DOCUMENT • START FROM TEMPLATE • START FROM EXISTING DOCUMENT • USE AN EXISTING LIST • SELECT FROM OUTLOOK CONTACTS • TYPE A NEW LIST • ADDRESS BLOCK….. • GREETING LINE…… • ELECTRONIC POSTAGE….. • MORE ITEMS……….
• 13.
  13MAIL MERGE
• 14.
  14MS EXCEL  MicrosoftExcel is a spreadsheet developed by Microsoft.  Windows, macOS, Android and iOS.  It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.  The first version of Excel was released in 1985.  The three main components of this package are  Electronic spreadsheet  Database management  Generation of Charts.
• 15.
  15  The optionsshown below is called as “MENU BAR”  The options shown below is called as “MENU BAR”  The alphabets A,B… are known as COLUMNS  The rows are numbered as 1,2,3…  Sheet1,Sheet2, Sheet3 are known as “WORKSHEET TABS” FUNCTION’S OF MS EXCEL
• 16.
  16FUNCTION’S OF MSEXCEL
• 17.
  17FUNCTION’S OF MSEXCEL
• 18.
  CHARTS & GRAPHS A graph or chart or diagram is a diagrammatical illustration of a set of data.  It can be placed within articles just like any other image.  Graphs must be accurate and convey information efficiently.  They should be viewable at different computer screen resolutions.  Ideally, graphs will also be aesthetically pleasing. 18
• 19.
  19CHARTS & GRAPHS Pie chart — good for showing how a whole is divided up.  Bar graph — good for showing how things compare to each other
• 20.
  20