Study

Excel Application

  •   0%
  •  0     0     0

      Back   Restart
  • List any 6 components of a chart
    Chart Area, Category Axis, Value Axis, Data Series, Category Name, Plot Area ,Legend, Chart Title, Grid lines
  • The row and column references can change when we copy formula to another cell. It is the default cell reference
    Relative reference
  • The Auto sum button ( ∑ ) is present in the editing group of ___ tab.
    HOME
  • It identifies the location of a cell or a group of cells in a worksheet.
    cell reference or cell address
  • The feature automatically adds the numbers in the selected cells.
    AutoSum
  • The predefined formula that performs specific calculation is known as a __
    Function
  • Symbol used to add text/string values is ___
    &
  • Pictorial representation of the data in the cells is known as a ___
    Chart
  • The order in which the operators are to be evaluated in a formula in MS Excel is known as
    Operator Hierarchy
  • The row and column references do not change when we copy formula as the reference points to a fixed cell address.
    Absolute Referencing
  • Shortcut key to create a new workbook
    ctrl+N
  • The group of contiguous cells is known as ____
    Cell Range
  • when a formula refers to its own cell value directly or indirectly. It is referred as ___ reference
    Circular
  • The ___ sign is used for absolute referencing
    $
  • List any 6 types of charts
    Column chart, Line chart, Pie chart, Bar chart, Area chart, Scatter chart ,Surface chart ,Radar Combo chart ,Stock chart
  • The process of linking or joining text values in a series is called ___
    Concatenation
  • If the row reference is relative, the column reference will be absolute and vice versa.
    Mixed Reference
    • Your experience on this site will be improved by allowing cookies.