MS Excel Trivia: Skills Test! Quiz

15 Questions | Total Attempts: 63

SettingsSettingsSettings
Please wait...
MS Excel Trivia: Skills Test! Quiz

.


Questions and Answers
  • 1. 
    Labels are aligned at the ________ edge of the cell.
    • A. 

      Left

    • B. 

      Right

    • C. 

      Top

    • D. 

      Bottom

  • 2. 
    Using the AutoSum button will place in the selected cell __________.
    • A. 

      The sum of values in the cell's column

    • B. 

      Nothing until you select a range of cells

    • C. 

      The sum of the cell's row unless you change the range

    • D. 

      A formula which will add values in the range Excel guesses you want to add

  • 3. 
    The default font keyed in a new workbook is:
    • A. 

      12 pt. Times New Romans

    • B. 

      10 pt. Arial

    • C. 

      12 pt. Bradley Hand ITC

    • D. 

      10 pt. Times New Roman

  • 4. 
    If you choose a larger font size, the height of the row is automatically made taller.
    • A. 

      True

    • B. 

      False

  • 5. 
    Which button allows you to copy cell formats from one cell to another?
    • A. 

      Enter

    • B. 

      Autofit

    • C. 

      Format painter

    • D. 

      Esc

  • 6. 
    A_______ is a group of cells that form a retangle on the screen.
    • A. 

      Label

    • B. 

      Workbook

    • C. 

      Worksheet

    • D. 

      Column

    • E. 

      Range

  • 7. 
    How do you know a range is active?
    • A. 

      It is highlighted on the screen.

    • B. 

      It has a marquee around it.

    • C. 

      The data changes to Bold to let me know it's active

    • D. 

      I'm psychic & I just Know!!

  • 8. 
    A range has an address called a range address.
    • A. 

      True

    • B. 

      False

  • 9. 
    An example of a range address.
    • A. 

      A1:B3

    • B. 

      A1;B3

    • C. 

      A1-B3

    • D. 

      A1=B3

    • E. 

      A1*B3

  • 10. 
    When you start to select a range of cells, you will see a thick white, cross-shaped pointer called a ________________.
    • A. 

      Cell selector

    • B. 

      Cell cross

    • C. 

      Selection pointer

    • D. 

      Range selector

  • 11. 
    Sheet3 is a copy of Sheet2. When you change values in Sheet 2 what will happen to the corresponding values in Sheet3?
    • A. 

      The values WILL change to match

    • B. 

      The values WILL NOT change to match

    • C. 

      The values are replaced with error value #REF

    • D. 

      The values are replaced with the error value #VALUE

  • 12. 
    It is possible to insert an image from a file into an Excel spreadsheet.
    • A. 

      True

    • B. 

      False

  • 13. 
    A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
    • A. 

      Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet

    • B. 

      Right click on the spreadsheet tab and select DELETE

    • C. 

      Right click on the spreadsheet and select INSERT - ENTIRE COLUMN

  • 14. 
    "Month 1, Month 2, Month 3" is an example of what?
    • A. 

      Series

    • B. 

      Function

    • C. 

      Formula

    • D. 

      Syntax

  • 15. 
    Which command reverses the last action performed?
    • A. 

      Undo

    • B. 

      Cut

    • C. 

      Redo

    • D. 

      Paste

Back to Top Back to top