RESOURCES : MICROSOFT EXCEL QUIZ
 
    Please click in the text fields below and enter the information requested.
  • First Name:   


  • Last name:ll  


  • Email:  ll         

    Answer the questions below. 
    For each item, select an option. When finished, click the "Check Score" button.
    1. The name of the cell in the top left hand corner of the spreadsheet is:
      A.  AA
      B.  A1
      C.  AB
      D.  1
    2. Rows run ______ and Columns run _________.
      A.  Horizontally (sideways), Vertically (up and down)
      B.  Vertically, Horizontally
      C.  Horizontally, Diagonally (across the screen)
      D.  Vertically, Vertically
    3. How do you highlight all of column B?
      A.  Click on the gray letter B
      B.  Click on the gray number 2
      C.  Click on the gray SHEET 2 tab
      D.  Click on any cell in column B
    4. How do you enter text or numbers into cell C3?
      A.  Click on INSERT, WORKSHEET
      B.  Type the text or numbers into a document in MS Word and then copy it over to MS Excel
      C.  Just click on cell C3 and start typing
      D.  Click on INSERT, OBJECT
    5. How do you expand the width of a column to fit a long word that you typed in column B?
      A.  Click and hold between the gray letters A and B and then spread the column wider by moving your mouse to the right
      B.  Click and hold between the gray letters B and C and then spread the column wider by moving your mouse to the right
      C.  Click on INSERT, COLUMN
      D.  Click on INSERT, CELLS
    6. Which function do you use to add up a row of numbers?
      A.  =COUNT
      B.  =MAX
      C.  =AVERAGE
      D.  =SUM
    7. In the formula, =SUM(A1:A6), which cells are being added up?
      A.  A1+A6
      B.  A1+A2+A3+A4+A5+A6
      C.  A6+A1
      D.  A2+A3+A4+A5
    8. Which letter of the alphabet is typically associated with the hard drive?
      A.  A
      B.  B
      C.  C
      D.  D
    9. Which sequence of commands should you use to format a number in one particular cell as a currency (to add a $ symbol to the cell)?
      A.  FORMAT, CELLS
      B.  FORMAT, STYLE
      C.  FORMAT, AUTOFORMAT
      D.  VIEW, CUSTOM VIEWS
    10. What do you click in order to ask MS Excel to organize your data in either ascending or descending order?
      A.  DATA, CONSOLIDATE
      B.  DATA, FILTER
      C.  FILE, PAGE SETUP
      D.  DATA, SORT