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 4

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 #2
    By default, a workbook in Excel contains how many worksheets?
    (a) 16 (b) 3 (c) 15 (d) 256
    digAnsr:   b
    Ans : (b) 3 worksheets are present in every workbook by default.
  • Qstn #3
    The simplest way to move data from one location to another in Excel is ..................
    (a) by Quick Access toolbar
    (b) using Cut and Paste
    (c) by the drag and drop method
    (d) Both (b) and (c)
    digAnsr:   d
    Ans : (d) We can move data using cut and paste and also drag and drop method is the easiest one.
  • Qstn #4
    The AutoFill can apply from
    (a) left to right (b) right to left
    (c) up to down (d) All of these
    digAnsr:   d
    Ans : (d) AutoFill can apply from any side.
  • Qstn #5
    The default page orientation in Excel is
    (a) Landscape (b) Horizontal
    (c) Portrait (d) None of these
    digAnsr:   c
    Ans : (c) The default page orientation in Excel is Portrait.
  • Qstn #6
    Word wrapping means
    (a) the text remains in the straight line
    (b) the text distributed in multiple lines
    (c) displays text vertically within a cell
    (d) displays the selected text in a different font style
    digAnsr:   b
    Ans : (b) Word wrapping distributes the text in multiple lines.
  • Qstn #7
    A term that is used in spreadsheet which forces a line break in a cell when the cell entry is too large to fit in the cell.
    (a) Wrap (b) Line Break
    (c) Cell Break (d) Multiline Cell
    digAnsr:   a
    Ans : (a) Wrap
  • Qstn #8
    The default alignment of text in a cell is
    (a) Left (b) Right
    (c) Centered (d) Justified
    digAnsr:   a
    Ans : (a) In Excel, by default the text is left aligned.
  • Qstn #9
    Absolute cell referencing occurs when ...............
    (a) formula is dragged but the cell references do not adjust.
    (b) spreadsheet is saved with “absolute” as file name.
    (c) formula is dragged and the cell reference adjusts automatically.
    (d) $ symbol is automatically added with each cell value.
    digAnsr:   a
    Ans : (a) Absolute cell referencing occurs when formula is dragged but the cell references do not adjust.
  • Qstn #10
    Find out the odd one
    (a) Absolute (b) Relative (c) Mixed (d) AutoFill
    digAnsr:   d
    Ans : (d) Absolute, relative and mixed all three are the types of cell referencing but AutoFill is not.
  • Qstn #11
    Cell address $B$5 in a formula means
    (a) it is a mixed reference
    (b) it is an absolute reference
    (c) it is a relative reference
    (d) None of the above
    digAnsr:   b
    Ans : (b) $ sign in a formula need to add before row number and column letter for absolute referencing.
  • Qstn #12
    While entering a formula, cell address B$5 represents
    (a) Absolute Referencing
    (b) Mixed Referencing
    (c) Relative Referencing
    (d) All of these
    digAnsr:   b
    Ans : (b) It represents mixed reference because we are using $ sign before 5 only. Hence, as we will drag this only B will change but 5 will remain same.
  • Qstn #13
    A cell range starting from first row, first column to fourth row and fifth column can be represented as
    (a) [A1 : E4] (b) [AO : E3]
    (c) [E4 : Al] (d) [E3 : AO]
    digAnsr:   a
    Ans : (a) [A1:E4] because row count starts from 1 and column count starts from A and first we write the starting cell address.
  • Qstn #14
    A cell range always has the symbol between the cell references.
    (a) ; (semicolon) (b) . (full stop)
    (c) .(comma) (d) :(colon)
    digAnsr:   d
    Ans : (d) A cell range always has the : (colon) symbol between the address of ranges.
  • Qstn #15
    If cell range A1 : A5 contain the numbers 20, 16, 5, 35 and 7 then = AVERAGE(A1 : A5, 50) will display.
    (a) 22.167 (b) 27.167
    (c) 10 (d) 40
    digAnsr:   a
    Ans : (a) 22.167
  • Qstn #16
    COUNTA (4, 78, False, 18) will return ...................
    (a) 2 (b) 3 (c) 4 (d) 5
    digAnsr:   c
    Ans : (c) Because the logical values and numbers directly
    provided as argument of COUNTA, a function will be counted.
next page