Lab#7 Quiz

 

Name:__________________________________

 

Lab Section:____

 

 

Mark True or False for each question and tear this page at perforation and turn in to the lab instructor at the end of the lab.

 

  1. Rows are represented by numbers and columns by letters in spreadsheets.
  2.  

True False

  • The currency is a format used for values that represent money.
  •  

    True False

  • Summation formula should be used to sum cells that are not consecutive.
  •  

    True False

  • The collection of cells A3, D6, L12 is referred to as a series.
  •  

    True False

  • When a sum function is copied from one cell to another, the result displayed will always be the same.
  •  

    True False

  • Fill-down will fill a series of cells with the word down.
  •  

     

    True False

  • If you copy SUM(A1:A4) from Cell A5 into cell B5, B5 will contain SUM(B1:B5).
  •  

    True False

  • If you copy SUM(C1:D1) from cell E1 into cell E2, E2 will contain SUM(C2:D2).
  •  

     

    True False

  • ###### being displayed in a cell implies that the cell is too small.
  •  

    True False

  • By default all numeric fields have the currency format in Excel.
  •  

    True False