Spread Sheet Application Set 5


Which tab is used for creating, formatting and editing a spreadsheet?
  
    (A) Data
    (B) Home
    (C) Insert
    (D) Review

Home

Which function is used to count the number of cells that contain numbers, in a range?
  
    (A) Count ()
    (B) Countif()
    (C) Sum()
    (D) Sumif()

Count ()

Which function is used to add the values in a range?
  
    (A) Count()
    (B) Sum()
    (C) ABS()
    (D) Sumif()

Sum()

which symbol is used to excute formulas in MS Excel?
  

    (A) "="
    (B) " ' "
    (C) "#"
    (D) " " "

=

Where does the result displays when a formula is entered in Excel?
  
    (A) Current Cell
    (B) Next Cell
    (C) Previous Cell
    (D) Formula Bar

Current Cell