HomeLearn Fast select Course
Change UnitChange SubjectLast Menu
CBSE-IX-Foundation of Information Technology .

11: MS-Excel 2007

 digibest Free NCERT Solutions with no signup needed page 2

Note: Please signup/signin free to get personalized experience.

Note: Please signup/signin free to get personalized experience.

10 minutes can boost your percentage by 10%

Note: Please signup/signin free to get personalized experience.

  
  • Qstn #14
    Write down the formula for adding values of cells A1 to A5.
    Ans : Formula for adding values of cells A1 to A5 would be =SUM(A1 : A5).
  • Qstn #15
    State difference between COUNT() and COUNTA() function.
    Ans : The only difference between the COUNT() and
    COUNTA() function is that the COUNTA() function computes the numbers as well as text entries, while the COUNT() function counts only numbers.
  • Qstn #16
    Hansika wants to apply MIN function on a cell range, but all the values in that range are of Boolean. What value will be returned by the MIN function?
    Ans : MIN function will return O(zero) in this case.
  • Qstn #17
    Why we cannot add titles to an embedded chart once chart is ready?
    Ans : Titles have not been entered in chart elements step. And, these cannot be added later once chart is ready.
  • Qstn #18
    Write down the importance of legend in charts.
    Ans : With the help of legend, each data series can be uniquely identified by assigning a unique color or pattern.
  • Qstn #19
    What will be the column names of the below statement?

    1. 26th column
    2. 28th column
    Ans :

    1. Z
    2. AB
  • #
    Section : B
    Short Answer Type Questions
  • Qstn #1
    What is the difference between a workbook and a worksheet?
    Ans : Differences between workbook and worksheet are as follows:
    Workbook Worksheet
    A workbook is an Excel file with one or more worksheets. A worksheet is a single spreadsheet of data.
    A workbook would be the entire binder, with everything in it. A worksheet would be like one section in that binder.
  • Qstn #2
    Write down the significance of electronic spreadsheets.
    Ans : Using electronic spreadsheets, large volume of data can be stored in worksheets. Worksheets can be managed, edited, viewed, retrieved and printed easily in desired format. Electronic spreadsheets support charts, which represent data pictorically.
  • Qstn #3
    Is it possible to remove a worksheet? State the process of doing it.
    Ans : Yes, it is possible to remove a worksheet. To remove a worksheet right-click on the Sheets tab of the sheet that you want to delete and choose Delete from pop-up menu, or choose Delete Sheet from the pop-up menu of Delete option on cells group under Home tab.
  • Qstn #4
    Define the meaning of formula.
    Ans : Formula plays a major role in spreadsheet making. If we all needed to do is to put text and numbers in rows and columns, just about any Word processing program would fill the bill. Formula allows us to perform calculations using values from any cells to have the result appear in the formula cell.
  • Qstn #5
    Suggest the appropriate functions for the following situations:

    1. For returning the minimum value out of a range A1 to C5.
    2. For determining whether the customer is eligible for discount or not from the bill amount stored in cell D5. A customer is eligible for discount if bill amount >5,000.
    Ans :

    1. = MIN(A1 : C5)
    2. = IF(D5>5,000, “Discount”, “NoDiscount”)
  • Qstn #6
    Suggest the appropriate function for the following situations:

    1. Selecting the maximum value out of a range A1 to B20.
    2. Calculating average of marks entered in cells E5, F5, G5, H5 and 15.
    3. Determining whether the student has passed (if scored > = 40) or not from the marks stored in cell J10.
    Ans :

    1. = MAX(A1 : B20)
    2. = AVG(E5:15)
    3. =IF(J10 >= 40, “Pass”, “Fail”)
  • Qstn #7
    Sana has entered 49+30 in a cell. The worksheet is not displaying 79 in the cell. Instead, 49+30 is getting displayed. Help, Sana in rectifying the problem.
    Ans : In Excel, every formula must start with an = (equal) sign.
    Since, Sana has not put = sign before 49+30, thus she is not able to see the desired result will be displayed if she will use = (49 + 30) formula.
  • Qstn #8
    What is the use of the COUNT() function in Excel?
    Ans : Excel’s COUNT() function can be used to total the number of cells in a selected range. The COUNT() function will add up the number of cells in a selected range that contains numbers.
next page