Spreadsheet–Functions and Chart

There is no content available!

To Access the full content, Please Purchase

  • Q1

    To copy the formula to all cells in the selected range, press:

    Marks:1
    Answer:

    F2

    Explanation:

    To copy the formula to all cells in the selected rages, press F2 and then press Ctrl + Enter.

    View Answer
  • Q2

    The AutoSum button is present on the:

    Marks:1
    Answer:

    Ribbon

    Explanation:

    AutoSum option is available on Ribbon in the Editing group of Home menu.

    View Answer
  • Q3

    The cell address in the formula is known as:

    Marks:1
    Answer:

    Cell reference

    Explanation:

    The cell address in the formula is known as cell reference. There are three types of cell references: Relative, Absolute and Mixed.

    View Answer
  • Q4

    A group of cells adjacent to each other forming a rectangular shape is referred to as

    Marks:1
    Answer:

    Range of cells

    Explanation:

    Range is a group or block of cells in a worksheet that have been selected or highlighted. When cells have been selected they are surrounded by a black outline or border.

    View Answer
  • Q5

    The type of reference in which either row or column remains fixed:

    Marks:1
    Answer:

    Mixed Reference

    Explanation:

    Mixed reference is a combination of relative and absolute reference. In this type of reference, either row or column has to remain fixed.

    View Answer