Current Affairs 6th Class

     Developing Charts   Excel enables the Chart Wizard that helps you create and view block diagrams. Using chart you can view any analytical data in visual form that provides you easy picture. Excel enables various types of chart, such as Bar Charts, Column Charts, Line Charts, Area Charts, Scatter Charts and Pie Charts.         To create and modify a chart:

• Select Insert  Chart menu option to display the Chart Wizard.
• Select a chart type
• Select a chart such as Bar chart and click the Next button to enter a Data Range, as shown in the following figure.
• Click the Data Range box, select the area you need for the chart and click the Next button, as shown in the following figure:
• Type the chart name in the Chart title text box and values for X in the Category (X) axis text box and Y in the Value (Y) axis text box.
• Click Finish to display the chart that you selected with my chart name.
• The chart has created.      

           Using formula you can performs arithmetic and logical operation. The formulas begin with an______ sign (A) +                                                                      (B) = (C) #                                                                      (D) @ (E) None of these     Answer: (b) Explanation Correct Option: (B) The formula begins with = sign. Incorrect Options: (A) Formula starts with an equal sign. Therefore, option (A) is incorrect. (C) Formula starts with an equal sign. Therefore, option (C) is incorrect.          Excel enables the Chart Wizard that helps you create and view block diagrams. Which one of the following is the correct step to open Chart Wizard? (A) Insert  Picture  Chart                     (B) Insert  Chart (C) File  Chart                                                                (D) Tools  Chart (E) None of these     Answer: (b) Explanation Correct Option: (B) When select Inset  Chart the Chart wizard will open that allows inserting chart in document. Incorrect Options: (A) Picture option does not contain chart option. (C) File menu does not contain chart option. (D) Tools menu does not contain chart option.         Steve works on excel sheet. He is managing some important data of sales department. Which of the following calculations Steve can perform in excel sheet? (A) Average                                        (B) Add (C) Count                                                             (D) All of these (E) None of these     Answer: (d) Explanation Correct Option: (B) Excel allows calculating add of given data. (A) Excel allows calculating average of given data. (C) Excel allows counting cell. Incorrect Options: Rest of the option is incorrect.   more...

     Printing worksheet   Printing provides the hard copy of your document. Before taking print you can also view the preview of your document. For this click the Print preview button.       To print the document:

• Select Start -> Programs -> Microsoft Office -> Microsoft Office Excel.
• Open the document that you want to print.
• Select File -> Print menu option to display the Print dialog box.
• Select a printer name from the Name list and click the OK button to print the document.

     Using Formulas and Calculations   This feature enables you to perform complex calculations easily. Using formula you can performs arithmetic and logical operation. Generally, the formulas begin with an equal (=) sign.        To add the contents of a cell:

• Select the cells, which you want to, add.
• Click Auto Sum to open the dropdown list and select sum to add the values of a cell, the sum will be displayed on the next cell.  

     To count the selected cell:

• Select the cells, which you want to count.
• Click Auto sum to open the dropdown list and select count to count the cell, the count will be displayed on the next cell.  

     Inserting, Deleting and Renaming Sheets   By default Excel enables only three sheets. You can insert, add and delete sheet in existing worksheet according to your requirements. To adding a new sheet    

• Click Insert  Worksheet menu.  

  To delete a sheet: 

• Click Edit  Delete sheet  menu option to display message box.
• Click the Delete button to show the dialog box.  

  To rename a sheet: 

• Click Format  Sheet  Rename menu.
• Specify a name such as my sheet at the base of the sheet.
• Click the OK button to accept the changed name.      

           Jack working on Excel sheet. He wants to open Conditional Formatting dialog box. Which one of the following step Jack need to perform to get same output? (A) Format Conditional Formatting (B) Format StyleConditional Formatting (C) Format  Cells Conditional Formatting (D) Format Sheet Conditional Formatting (E) None of these   Answer: (a) Explanation Correct Option: (A) Select Format Conditional Formatting to display the Conditioning Formatting dialog box. Incorrect Options: Rest of the options is incorrect.            Editing the style of text, numbers and the pages based on conditions are performed under______ option. (A) Formatting                                                  (B) Alignment (C) Customize                                                    (D) All of these (E) None of these     Answer: (a) Explanation Correct Option: (A) Formatting option allows you to edit style of text and numbers. Incorrect Options: Rest of the options is incorrect.          An Excel file which contains several worksheets is referred as a workbook. By default Excel enables only ____ sheets. (A) Two                                                                (B) Three (C) Four                                                                (D) Five (E) None of these     Answer: (b) Explanation Correct Option: (A) By default Excel enables only three sheets. Incorrect Options: Rest of the options is incorrect.  

      Formatting A Text and Numbers   Various formatting styles on Text and Numbers as per requirement are permitted by Excel. The document become more feasible, pleasing appearance also shows more values by using these formatting styles. You need to click a particular eel and starting typing to enter data in cell of worksheet. By pressing Tab and Arrow Keys of the keyboard you can enter the data.                                     How to Select Cell Or Cell Range If you want to perform any operation on data then you need to select cell or range of cells.        You need to follow the/allowing steps to select the cell or cells in a worksheet: 

• Firstly click the cell which you want to select and same in case of range of cells, you need to press and the document through mouse in the starting cell.
• Then move the mouse to destination or end cell and release it.  

     How to Do Text Alignment It allows you to align the Text of the document.         Implementation of Text is done in the following way:

• Firstly select the cells on which you need a text to be align.
• Then select Format  Cells  Alignment tab to open format cells dialog box, as shown in the following figure:
• Further you need to select the desired option to align text vertically or horizontally in the Text alignment area.
• Then click OK for accept the settings.    

     Implementation of Conditional Formatting Editing the style of Text, numbers and the pages based on conditions are performed under formatting option. If the contents in the Cells satisfied those conditions then the formatting will took effect. Therefore, there is no need to make any changes and check the conditions manually. (See Figure)            Implementation of Conditional formatting is done in the following manner: 

• To display the Conditional Formatting dialog box, select Format  Conditional Formatting, as shown in the following figure: (See Figure)
• Then select the type of condition from the  dropdown list according to the requirement.
• After that select the range of the cells which are needed.
• Then to add more conditions click Add.
• Finally to accept the changes click OK.  

       How to Format a Text As per the requirement you can format a Text, such as changing the font of Text from Arial to Times New Roman or by changing its size from 8 to more...

     How to Create New worksheet   To create a new worksheet on Excel, you required to open MS Excel, For opening an Excel sheet, you need to select Start then proceeding further to Programs then move to Microsoft Office and from there you need to select Microsoft Office Excel      For future uses Excel provide the facilities of saving a document. Saving a new file for the first time:

• You need to click File  Save as, to open the Save As dialog box. (See Figure. 6.5.1)
• Now select the exact location where you need to save the file.
• Then provide a name to the particular file in the File name textbox place.
• Finally click Save to save the particular file.  

           To save an existing file at different location you need to follow the following:

• Firstly open an existing file.
• Then click File  Save As to display the dialog box Save As.
• Further select the location where you need to save the particular file.
• Provide another name in the File name box, if you need to save/create at the same location another copy of same document.
• Finally click Save to save/create another copy of the same file at desired location where you need it.
• Ctrl + S shortcut key can also be used to save a file.  

        How to Open a File         In Microsoft Excel to open an existing file we need to follow as: (See Figure)

• Firstly select File Open menu option to display Open dialog box.
• Then select location such as E: drive, where you already saved a file from the Look in list.
• Thus select a particular file.
• Finally click Open to open the desired file you want to open.  

               An Excel file which contains several worksheets is referred as a workbook. Spreadsheet helps in____. (A) Preparing invoice                                      (B) Creating business planning (C) Financial accounting                                 (D) All of these (E) None of these     Answer: (d) Explanation Correct Option: (A) Spreadsheet helps in preparing invoice. (B) Spreadsheet helps in creating business planning. (C) Spreadsheet helps in financial accounting. Incorrect Options: Rest of the option is incorrect.          Rows and Columns are the main component of worksheets. Maximum numbers of columns you can enter in an Excel worksheet are____. (A) 256                                                                  (B) 254 (C) 556                                                                  (D) Unlimited (E) None of more...

    Introduction to Spreadsheet     Worksheet environment which is used to manage numbers and calculation or provides an electronic worksheet is known as Excel. An Excel file which contains several worksheets is referred as a workbook. The text, numbers and formulas which enters in Excel is permitted by Worksheet. By default three worksheet are presented in every workbook. It promotes number of features that allows you to generate formulas which are automatically updated when you change plot numeric date and data in charts. It contains grid which is made up of columns and rows, thus it used easily to perform mathematical calculations.        Applications related to worksheets are as:

• Financial accounting.
• Helps in solving complex engineering problems.
• Helps in inventory controls and formatting reports.
• Helps in creating business planning's.
• Helps in preparing Invoice.             

Rows and Columns are the main component of worksheets. A column and rows are The vertical and horizontal group of cells. Maximum numbers of columns you can enter in an Excel worksheet are 256. Whereas the maximum number of rows you can enter in that are 65,536 rows.  

    Introduction   HTML (Hyper Text Markup Language) language is developed by Tim Berner-Lee at Consiel European pour la Research Nuclear (CERN) to enable permit the researchers to share their research papers with the help of Internet. HTML is not a programming language, it is a markup language. Basically markup language is a set of markup tags. Normally HTML tags come in pair, such as\[\text{hi}\] and \[\text{/hi}\]. Each tag contains start and end tag. Start tag is called opening tag and end tag is called closing tag. The HTML 1.0 is the first version of HTML, whereas continuous growth of Web extended HTML growth in several other ways. World Wide Web (WWW) is the organization which did not specify the first version of HTML. This organization maintains the language and keeps involving it in proper direction. Latest version of HTML is HTML 4.01 which is in general uses and is the sub version of HTML4.0.   Designing Of Web Page A document that is suitable for the WWW and can be accessed through a web browser, such as Internet Explorer is called Web page. A standard structure for -ITML pages has been recommended by World Wide Web (WWW). Basically HTML sage coding always starts with the\[\text{htmltags}\]. The structure for an HTML page is always performed in between the opening and closing of \[\text{htmltags}\]. HTML pages are having different sections with different \[\text{htmltags}\]. These\[\text{htmltags}\] are as follows:     Tag for Opening and Closing     The whole HTML document comes under the\[\text{htmltag}\] which is used as a container. The entire content of the HTML page comes under the opening and closing of the\[\text{htmltags}\] . This\[\text{html tag}\] indicates the browser this is the starting of the document and the closing\[\text{htmltag}\] indicates that it's the ending of an HTML document. Syntax for the following is as:   \[\text{html}\] ......... Contents mentioned in the page .......... \[\text{/html}\]          \[\text{head Tag}\] Tag The information contains some certain headings regarding document comes under\[\text{headtag}\]. There are only few tags which are valid under the heading section.    These are as follows:                           \[\text{linktag :}\] It defines reference for the resource. \[\text{basetag :}\] For all the links present on a page it defines a base URL. \[\text{metatag :}\] It defines the Meta- Information such as keyword and descriptions for search  engines and refresh rates about the page. \[\text{scripttag :}\] The HTML page uses the script is defined by this tag. \[\text{styletag :}\] It defines the internal style sheet for HTML page.    \[\text{bodytag }\] The \[\text{bodytag}\] is used to describe the contents of the HTML document. The contents of HTML document may be a text, audio, video and images. All type of content comes under \[\text{bodytag}\].       HTML (Hyper Text Markup Language) language is developed by Tim more...

      Using Spell Check     Microsoft Word enables spelling and grammar checker which provides the facility to check the spelling and grammar in the document. The spelling and grammar checker be executed to check the spellings and grammar in the whole document by default. Word checks spelling and grammar as the text is being typed in the document. Wavy red underline indicates possible spelling errors. Wavy green underlines indicate every possible grammatical issue. (See Figure)                     To start the spelling and grammar checker:

• Select Tools  Spelling and Grammar to display the Spelling and Grammar dialog box, as shown in the following figure:
• Click Ignore Once to ignore the spelling mistake or Change to change the word with the suggested spelling.
• After completing the spelling and grammar checking in the whole document, a message box appears "spelling and grammar check is complete".
•  Click OK.                       

       

• Word processor is a type of stand-alone office machine, popular in the 1970s and 80s,
• MS Word 2010 is the latest version of Word.    

       

• Menu Bar: It is the list of main menu choices located below the title bar.
• Standard Tool Bar: It provides button for commonly used commands, which are located below the menu bar.
• Formatting Tool Bar: It provides buttons which are most commonly used for formatting commands, and located below standard toolbar.    

         

• Notepad is a well known text editor.
• Microsoft Word (MS Word) is one of the most widely and commonly used word processor package.
• Microsoft Word enables Formatting toolbar and Format menu that can be used for formatting the document.
• Wavy red underlines indicate possible spelling errors.
• Rulers display information about the left margin, right margin, top and bottom margins, and it also allows horizontal and vertical alignment of the text in a document.
• Microsoft Word enables a highlight tool that allows highlighting specific text.
• MS Word allows you to count number of pages, words, character (rro space), character (space), paragraph, and lines in a document.  

    Inserting Bullets and Numbers     Microsoft Word enables the feature to insert bulleted and numbered list in document.       To insert a bulleted list: 

• Select the text and click the Bulleted List button  on the formatting toolbar. To insert a numbered list: (See Figure)
• Select the text and click the Numbered List button on the formatting toolbar.

You can also change the bullet image and numbering format using the Bullets and Numbering dialog box.             To change the bullet image and numbering format:

• Select Format Bullets and Numbering or right-clicking within the list and select Bullets and Numbering from the shortcut menu to display the Bullets and Numbering dialog box, as shown in the following figure:
• To select a bullet style, click the Bulleted tab. Select the list style from one of the seven choices given or click Picture to choose a different icon. Click Numbered tab to choose a numbered list style.
• Click OK.  

     Removing Bullets and Numbering       To remove the numbers or bullets:

• Select the bulleted or numbered list.
• Select Format  Bullets and Numbering option to display the Bullets and Numbering dialog box and click none.
• Click OK.  

    Count word in a Document MS Word allows you to count number of Pages words, character (no space), Character (space), paragraph and lines in a Document. To apply word count: (See Figure) Select ToolsWord Count to display The Word Count Dialog box, as shown in the Flowing figure: The Word Count Dialog box displays all information including number of page, words, information (no space), character (space), paragraph and lines in a document.