Excel Test - Fall 2015

38 Questions | Total Attempts: 179

SettingsSettingsSettings
Please wait...
Excel Test - Fall 2015

Read and answer each question carefully.


Questions and Answers
  • 1. 
    The cell into which you are currently entering data; it has a heavy border around it
    • A. 

      Name box

    • B. 

      Cell

    • C. 

      Active cell

    • D. 

      Gridlines

  • 2. 
    The small green square located in the lower right corner of the active cell
    • A. 

      Option handle

    • B. 

      Autofill

    • C. 

      Status bar

    • D. 

      Range

  • 3. 
    The ________________ allows you to add all the numbers in a range of cells.
    • A. 

      MIN function

    • B. 

      SUM function

    • C. 

      MAX function

    • D. 

      ADD function

  • 4. 
    Provides easy access to frequently used commands
    • A. 

      Easy Access Toolbar

    • B. 

      Office Button

    • C. 

      Quick Access Toolbar

    • D. 

      Name Box

  • 5. 
    Excel opens a new workbook with ________ worksheet(s).
    • A. 

      One

    • B. 

      Two

    • C. 

      Three

    • D. 

      Five

  • 6. 
    The numbers on the left side of the grid are
    • A. 

      Row Headings

    • B. 

      Column Headings

    • C. 

      Headers

    • D. 

      Footers

  • 7. 
    The Name Box displays the active cell reference.
    • A. 

      True

    • B. 

      False

  • 8. 
    How are columns designated in Excel?
    • A. 

      Letters

    • B. 

      Numbers

    • C. 

      Triangles

    • D. 

      Combination of letters and numbers

  • 9. 
    This means the cell's content is positioned at the far left in the cell
    • A. 

      Justified

    • B. 

      Right-aligned

    • C. 

      Center-aligned

    • D. 

      Left-aligned

  • 10. 
    The basic unit of a worksheet into which you enter data is called a __________________.
    • A. 

      Cell

    • B. 

      Box

    • C. 

      Range

    • D. 

      Gridline

  • 11. 
    When you enter text or numbers into a cell, it appears in the cell as well as in the formula toolbar
    • A. 

      True

    • B. 

      False

  • 12. 
    You can select an entire row by pressing Ctrl + spacebar
    • A. 

      True

    • B. 

      False

  • 13. 
    This indicates the beginning of a formula
    • A. 

      /

    • B. 

      \

    • C. 

      +

    • D. 

      =

  • 14. 
    This indicates the lowest value in a range of cells
    • A. 

      MAX

    • B. 

      MIN

    • C. 

      AVG

    • D. 

      SUM

  • 15. 
    Adds all values in a range of cells
    • A. 

      MAX

    • B. 

      MIN

    • C. 

      AVG

    • D. 

      SUM

  • 16. 
    Opens an existing file or workbook
    • A. 

      Ctrl O

    • B. 

      Ctrl N

    • C. 

      Crtl R

    • D. 

      Ctrl P

  • 17. 
     Creates a new workbook in Excel
    • A. 

      Ctrl O

    • B. 

      Ctrl N

    • C. 

      Ctrl P

    • D. 

      Ctrl E

  • 18. 
    Saves a workbook
    • A. 

      Ctrl O

    • B. 

      Ctrl S

    • C. 

      Ctrl W

    • D. 

      Ctrl K

  • 19. 
    Closes a workbook in Excel
    • A. 

      Ctrl U

    • B. 

      Ctrl E

    • C. 

      Ctrl W

    • D. 

      Ctrl Z

  • 20. 
    Which key do you press if you need help with something in Excel?
    • A. 

      F1

    • B. 

      F2

    • C. 

      F3

    • D. 

      F4

  • 21. 
    Which key do you press if you want to run spell check?
    • A. 

      F4

    • B. 

      F5

    • C. 

      F6

    • D. 

      F7

  • 22. 
    To move to the next cell on the right you can...
    • A. 

      Press Tab

    • B. 

      Use the directional right arrow

    • C. 

      Press Enter

    • D. 

      You press Tab or use the directional right arrow

  • 23. 
    Use this keyboard shortcut to move to cell A1 regardless of where you are on the spreadsheet.
    • A. 

      Ctrl Home

    • B. 

      Ctrl End

    • C. 

      Ctrl F7

    • D. 

      Ctrl O

  • 24. 
    To preview and print a workbook you use
    • A. 

      Ctrl H

    • B. 

      Ctrl P

    • C. 

      Ctrl U

    • D. 

      Ctrl B

  • 25. 
    To undo a command you can click Undo on the Quick Access Toolbar or press 
    • A. 

      Ctrl I

    • B. 

      Ctrl X

    • C. 

      Ctrl Z

    • D. 

      Ctrl M

Related Topics
Back to Top Back to top