level up excel class 7

-

 

A. Tick ($\checkmark$) the correct option.

  1. Which of these helps you to arrange the order of the data alphabetically?

    • Answer: c. Sorting

  2. Which chart is displayed in the cells of the worksheet?

    • Answer: d. Sparklines

  3. Which chart is made by connecting the dots representing data?

    • Answer: c. Line

  4. Which symbols represent data in a chart?

    • Answer: c. Data Marker

  5. Which component shows the heading of the chart?

    • Answer: c. Chart Title 

      B. Fill in the blanks.

      1. Custom List is also known as user-defined sorting.

      2. Bar chart depicts the data categorically. (Note: Column charts or Bar charts are standard for categorical data depictions; specifically, Bar charts display data horizontally across categories).

      3. Sparklines are miniatures of charts that are inserted in the cells of Excel sheet.

      4. Gridlines are horizontal and vertical lines in the plot area.

      5. Legend defines the data series with a unique colour or pattern.

C. State True or False.

1.      Conditional formatting allows you to format cells based on certain conditions or criteria.

o    Answer: True

2.      Charts make the data look more complicated.

o    Answer: False

3.      You cannot change the title of a chart.

o    Answer: False

4.      In Sparklines, you need to define the location and range of data.

o    Answer: True

5.      You can add chart elements as per your requirements.

o    Answer: True


D. Match the following:

  1. Chart Title           c. It is the heading of the chart that shows what a chart is representing.

  2. Data Series         d. It is the set of data of the worksheet that you want to depict through charts.

  3. Data Table           e. It is the table that contains the values for each data series displayed below the chart.

  4. Chart Area            b. It is the area that contains the charts and all the other elements of the chart like plot, title and legend.

  5. Data Marker          a. It is any symbol like bar, circle, dot or slice that is used to represent data in a chart.

E. Answer the following questions.

  1. Define a chart.

    • A chart is a graphical representation of data in a worksheet. It makes it easier to analyze, compare, and understand numeric data and trends visually rather than looking at raw numbers.

  2. Why do you use conditional formatting in Excel?

    • Conditional formatting is used to automatically format cells (such as changing cell color or font style) based on specific conditions or criteria, making it easier to spot trends, highlights, and anomalies in data.

  3. What is the significance of data series and data table?

    • Data Series: Represents the group of related data points or values plotted in a chart (e.g., a row or column of numbers).

    • Data Table: Displays the numeric data values corresponding to each data series directly below the chart, providing clear reference values.

  4. Define Sparklines.

    • Sparklines are miniature charts that fit inside a single cell of an Excel worksheet, providing a quick visual summary of data trends alongside the numbers.

  5. What is the significance of using pie charts?

    • Pie charts are significant for showing proportions or percentages of a whole. They display data as slices of a circle, making it easy to see how individual parts contribute to the total.

  6. Differentiate between sorting and filtering.

    • Sorting arranges data in a specific order (such as ascending or descending alphabetically or numerically).

    • Filtering temporarily hides rows of data that do not meet certain criteria, allowing you to focus only on the specific data you want to view.

  7. Write the steps to add Sparklines in an Excel sheet.

    • Step 1: Select the empty cell or cells where you want to insert the Sparkline.

    • Step 2: Click on the Insert tab on the Ribbon.

    • Step 3: Choose the desired Sparkline type (e.g., Line, Column, or Win/Loss) from the Sparklines group.

    • Step 4: In the dialog box that appears, select the range of data cells you want to represent.

    • Step 5: Click OK.

  8. What are the uses of gridlines and legend in a chart?

    • Gridlines: Horizontal and vertical lines within the plot area that help guide the eye and make it easier to read and measure data values against the axes.

    • Legend: A key that identifies the different data series in a chart, matching each color or pattern to its corresponding category or series name.

  9. Write the difference between pie chart and doughnut chart.

    • A pie chart displays data as solid circular slices representing proportions of a total.

    • A doughnut chart is very similar to a pie chart, but it has a blank hollow center (like a ring or doughnut) and can support multiple data series as concentric rings.

  10. Write a difference between bar chart and column chart.

    • A bar chart displays data using horizontal bars to compare items across categories.

    • A column chart displays data using vertical columns to show data comparisons over time or across categories.

Comments

Post a Comment

Popular posts from this blog

TYPES OF HARDWARE CLASS IX

-
                 Types of Hardware (chap-2) 1. Hardware- Hardware refers to physical parts of the computer that can be touched physically. For example monitor, keyboard, hard drive etc. 2. Classification of Hardware-      1. CPU (Central Processing Unit)      2. Memory- A. Primary Memory (Internal Memory)         a. ROM (Read Only Memory)          b. RAM (Random Access Memory      3. Secondary Memory (Auxiliary Memory)          All Storage devices like hard disk, CD, DVD, pen drive etc.      4. Input Devices and  Output Devices 3. Memory in a Computer System- a. Main Memory or primary memory or internal memory- The memory that holds data and instructions during processing. It is temporary memory. b. Auxiliary or secondary or external memory- The memory that can store data or files for later use i.e. permanentl...
Read more

CLASS X SYLLABUS 2026-27

-
Image
Computer_Applications_SecP1X_2026-27.pdf   https://cbseacademic.nic.in/web_material/CurriculumMain27/SecPart1/Computer_Applications_SecP1X_2026-27.pdf CHAPTER 1                                     INTERNET BASICS      Internet - Internet is a global network of computer networks that enables information to be exchanged. In internet, most computers are not connected directly to the internet. Rather they are connected to smaller networks, which in turn are connected through gateways to the internet backbone. Internet is not governed by any particular body. It is coordinated by many volunteer organizations.   Advantages of Internet-  • Greater access to information reduces research times.  • Useful communication links  • Global reach enables one to connect to anyone on the internet.  • Easy communication with other people.  • Publishing documents on the...
Read more

Computer Applications Class IX Types of Software (Chap 3)

-
Image
  HARDWARE- Hardware represents the physical and tangible components of the computer i.e. the components that can be seen and touched. Input devices, output devices, CPU, floppy disk, hard disk, CD, DVD etc. are examples of computer hardware.  ● SOFTWARE- software represents the set of programs that govern the operation of computer system and make the hardware run.  ● SOFTWARE can be classified broadly into two categories.  1. System Software- refers to the programs that control internal computer operations and make best use of the hardware. The system software can further be classified into following categories: Operating system Language processor Utilities or Utility Software  2. Application Software- is the set of programs necessary to carry out operations for a specified application. These are the programs written by programmers to enable computer to perform a specific task such as processing words, inventory control, handling calculations and figures, medic...
Read more