Excel Test - Fall 2012

30 Questions | Total Attempts: 111

SettingsSettingsSettings
Excel Quizzes & Trivia

Choose the correct answer and click on it to select. Check your answers then submit to the teacher when you are finished.


Questions and Answers
  • 1. 
    Excel's ___________ function allows you to add all of the numbers in a range of cells. 
    • A. 

      MIN

    • B. 

      MAX

    • C. 

      SUM

    • D. 

      ADD

  • 2. 
    The ___________ is a central location for managing workbooks with commands like Save, Print, and Open.. 
    • A. 

      Ribbon

    • B. 

      Office Button

    • C. 

      Screen Tip

    • D. 

      Share toolbar

  • 3. 
    When typing formulas or functions into a cell, it is important to:
    • A. 

      Begin the formula with an apostrophe

    • B. 

      Lock the data into the cell by pressing enter when you're done

    • C. 

      Type in lowercase

    • D. 

      Split and Merge

  • 4. 
    Excel opens a new workbook with _________ worksheets 
    • A. 

      One

    • B. 

      Two

    • C. 

      Three

    • D. 

      Five

  • 5. 
    To save a workbook using the shortcut keys, press 
    • A. 

      ALT + S

    • B. 

      CTRL + S

    • C. 

      SHIFT + S

    • D. 

      CTRL + F2

  • 6. 
     The ______________ is a blinking vertical line that indicates where the next typed character will appear.
    • A. 

      Insertion point

    • B. 

      Alignment tool

    • C. 

      Left-justified

    • D. 

      Right button

  • 7. 
    When you create a formula in a cell that meets only specified conditions it is called a ...
    • A. 

      Comma style formatting

    • B. 

      Point mode

    • C. 

      Conditional formula

    • D. 

      Unlimited

  • 8. 
    A saved workbook is referred to as a ____________. 
    • A. 

      Book

    • B. 

      Workbook

    • C. 

      Project

    • D. 

      File

  • 9. 
    The formula _____ multiplies the contents of cell B4 by 18.5 
    • A. 

      18.5 ^ B4

    • B. 

      =18.5 * B4

    • C. 

      =B4/18.5

    • D. 

      =B4**18.5

  • 10. 
    To alert Excel that you are entering a formula and not text, type a (n) ____________ before the formula 
    • A. 

      Ampersand (&)

    • B. 

      Equal sign (=)

    • C. 

      Number sign (#)

    • D. 

      Asterisk (*)

  • 11. 
    This is located on the Ribbon and is used to display the borders gallery
    • A. 

      Active cell

    • B. 

      Borders button

    • C. 

      Name box

    • D. 

      Forumula bar

  • 12. 
    A user wishes to remove a spreadsheet from a workbook.  Which is the correct way to delete the tab?
    • A. 

      Right click on the spreadsheet tab and select DELETE

    • B. 

      Double-click on the spreadsheet tab

    • C. 

      Access the Office Button

    • D. 

      Right click and rename

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

      Easy Access Toolbar

    • B. 

      Office Button

    • C. 

      Quick Access Toolbar

    • D. 

      Name box

  • 14. 
    The numbers on the left side of the Excel grid. 
    • A. 

      Row Heading

    • B. 

      Column Heading

    • C. 

      Headers

    • D. 

      Footers

  • 15. 
    The one into which you enter data and has a heavy border around it 
    • A. 

      Active cell

    • B. 

      Cell name

    • C. 

      Range

    • D. 

      Worksheet

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

      Cell

    • B. 

      Box

    • C. 

      Range

    • D. 

      Gridlines

  • 17. 
    Displays the lowest value for a range of cells 
    • A. 

      MAX

    • B. 

      MIN

    • C. 

      SUM

    • D. 

      LOW

  • 18. 
    The small black square located in the lower-right corner of the heavy border around the active cell 
    • A. 

      Name box

    • B. 

      Cell name

    • C. 

      Cell

    • D. 

      Fill handle

  • 19. 
     A printed version of a worksheet is called a ______________.
    • A. 

      Hard copy

    • B. 

      Soft copy

    • C. 

      File

    • D. 

      Digital copy

  • 20. 
     Displays the highest value for a range of cells
    • A. 

      LOW

    • B. 

      MAX

    • C. 

      MIN

    • D. 

      DIV

  • 21. 
    Instructs Excel to display additional spaces for decimals in a cell 
    • A. 

      Decrease Decimal Button

    • B. 

      Increase Decimal Button

    • C. 

      Accounting Style

    • D. 

      Comman Style Format

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

      Numbers

    • B. 

      Letters

    • C. 

      Triangles

    • D. 

      Circles

  • 23. 
    Which direction do rows run in a spreadsheet?
    • A. 

      Counter clockwise

    • B. 

      Horizontal

    • C. 

      Vertical

    • D. 

      Diagonal

  • 24. 
    To combine a group of cells together to make one big cell along with center the text in the cell, you would click  ____________ button.
    • A. 

      Merge

    • B. 

      Merge and align

    • C. 

      Merge and center

    • D. 

      Format cells

  • 25. 
    Type a formula that would divide B3 by E7.
Back to Top Back to top