Home
Posts

7th chapter 2nd computer

Ajeet Singh


A. Tick (✓) the correct option :

  1. The formula should start with an :
    Answer: a. equal to sign

  2. It is the vertical axis element in the chart.
    Answer: a. Y-Axis

  3. It is a predefined formula.
    Answer: c. Function

  4. The SUM function includes up to ______ arguments.
    Answer: b. 255

  5. This function returns the highest value from a supplied set of numeric data.
    Answer: c. MAX Function

  6. What do we call the area where Excel plots the data?
    Answer: b. Plot Area

  7. It shows the relationship of parts to a whole.
    Answer: a. Doughnut Chart

B. Fill in the blanks :

  1. Formula is also called ______.
    Answer: expression

  2. Every cell in a worksheet has a unique address, also called ______.
    Answer: cell reference

  3. The ______ function returns the highest value in a range whereas the ______ function returns the smallest value.
    Answer: MAX, MIN

  4. Column chart displays the categories along the ______ axis and values along the ______ axis.
    Answer: horizontal, vertical

  5. A ______ is a tiny, word-sized chart that can appear in a cell.
    Answer: sparkline

  6. Excel use ______ types of sparkline charts.
    Answer: three

C. Identify and name the types of the following charts used in Excel :

  1. Answer: Doughnut Chart
  2. Answer: 3D Surface Chart
  3. Answer: Pie Chart
  4. Answer: Column Chart (with Line – Combo Chart)

D. Answer the following questions :

  1. What are operators? How many types of operators are there?
    Answer:
    Operators are symbols used to perform calculations in Excel. There are mainly four types of operators: Arithmetic, Comparison, Text, and Reference operators.
  1. How can you edit a formula in Excel?
    Answer:
    Select the cell → click on the formula bar → make changes → press Enter. You can also double-click the cell to edit.
  1. Explain the order of calculation in Excel.
    Answer:
    Excel follows BODMAS rule: Brackets → Orders (powers) → Division → Multiplication → Addition → Subtraction.
  1. What do you mean by Functions in Excel?
    Answer:
    Functions are predefined formulas used to perform calculations like SUM, AVERAGE, MAX, etc.
  1. What is the use of the following functions? Give an example for each:

a. SUM
Answer: Adds numbers. Example: =SUM(A1:A5)

b. MAX
Answer: Finds highest value. Example: =MAX(A1:A5)

c. MIN
Answer: Finds smallest value. Example: =MIN(A1:A5)

d. AVERAGE
Answer: Finds average. Example: =AVERAGE(A1:A5)

e. SQRT
Answer: Finds square root. Example: =SQRT(25)

  1. What is the use of a chart? State its importance.
    Answer:
    Charts represent data visually. They make data easy to understand, compare, and analyze quickly.
  1. Explain the different components of a chart.
    Answer:
    Chart Title, Axes (X and Y), Plot Area, Chart Area, Legend, Data Series, Gridlines.
  1. Write the steps to change the chart style.
    Answer:
    Select chart → go to Design tab → choose Chart Styles → click desired style.
  1. What are Sparklines in a chart? How can you add them in the worksheet?
    Answer:
    Sparklines are small charts inside a cell.
    Steps: Select cell → Insert tab → choose Sparkline → select data range → OK.


Post a Comment