Skip to main content

C-7 (L-3) MORE IN EXCEL

cls7 l-3
Answer these questions:

What are charts? Why do you use them?

 Charts refer to the the data which are represented in the form of pictures or drawing or graphs.
Charts are used to show the relationship between certain quantities and data values in the form of diagrams which are easy to understand.

Give some examples of charts. Write a short note on any one of the chart types.

Some examples of charts are:

  • Column
  • Line
  • Pie
  • Bar
  • Area
  • Stock
  • Bubble
  • Radar
    •
    Column: when data is given over a period of line or comparison is to be made among items.

    How is filtering of data different from sorting of data?

    Filter feature of Excel separate the information as required from the given set of list. It gives us the required information without making any changes in the order of the list.
    While, sorting of data means arranging the data is ascending or descending order for easy analysis.

    Write the steps to show simple filtering of data.

    The following are the steps to show simple filtering of data-
  • Click on data tab
  • Click on the filter option in the sort and filter group
  • Drop-down arrows are added in fast of the headings of all the selected columns
  • Click on the drop-down arrows present on the column heading country
  • A dropdown menu opens
  • By default, all the country of options in the filter drop-down menu hecked that is, there is a trick in all the boxes.
  • click on ok


    • What is conditional formatting?

    The advanced formatting feature that enables us to apply formatting to only those cell in the worksheet which satisfy a particular condition is called conditional formatting.
    Labels:

    Popular posts from this blog

    C-7 (L-2) FORMULAS AND FUNCTIONS IN MS EXCEL 2010

    FORMULAS - सूत्रों Formulas perform calculations on the data entered in the worksheet. सूत्र वर्कशीट में दर्ज किए गए डेटा पर गणना करते हैं। A formula starts with an equal sign (=) followed by numbers, math operators (such as + or - sign for addition or subtraction), and built-in Excel functions. एक सूत्र एक समान चिह्न (=) से शुरू होता है, उसके बाद संख्याएँ, गणित संचालक (जैसे + या - जोड़ या घटाव के लिए चिह्न), और अंतर्निहित एक्सेल फ़ंक्शन। Like a calculator, MS Excel can implement formulas that add, subtract, multiply, and divide. एक कैलकुलेटर की तरह, एमएस एक्सेल उन सूत्रों को लागू कर सकता है जो जोड़, घटाना, गुणा और भाग करते हैं। Point-and-click method - पॉइंट-एंड-क्लिक विधि To calculate using the point-and-click method, follow these steps: पॉइंट-एंड-क्लिक विधि का उपयोग करके गणना करने के लिए, इन चरणों का पालन करें: Select the cell and type the equal sign. सेल का चयन करें और बराबर चिह्न टाइप करें। Click on the first cell that should be included in the formula....
    Read more

    C-7 (L-1) COMPUTER SOFTWARE AND LANGUAGES

    What is Software? Software (सॉफ्टवेयर) क्या है? Software is defined as collection of computer programs containing the instructions about how, when and what a computer has to do. सॉफ़्टवेयर को कंप्यूटर प्रोग्रामों के संग्रह के रूप में परिभाषित किया गया है, जिसमें कंप्यूटर को कब, क्या और क्या करना है, इस बारे में निर्देश दिए गए हैं। What do you understand by customized software? आप Customized Software (अनुकूलित सॉफ्टवेयर) के वारे मे क्या समझते हैं? The software which is specially designed to fulfill the requirements of a particular individual or company, is known as customized software. These type of software are designed for railways, bank and hospitals. Software (सॉफ्टवेयर) जो विशेष रूप से किसी विशेष व्यक्ति या कंपनी की आवश्यकताओं को पूरा करने के लिए डिज़ाइन किया गया है, को Customized Software (अनुकूलित सॉफ्टवेयर) के रूप में जाना जाता है। इस प्रकार के सॉफ्टवेयर Railway (रेलवे), Bank (बैंक) और Hospital(अस्पतालों) के लिए डिज़ाइन किए गए हैं। What is known as the binary n...
    Read more