MS Office Excel 2003 Advance - Pre Test

15 Questions | Total Attempts: 122

Settings
Please wait...
Microsoft Excel Quizzes & Trivia

Answer either True, False or I Dont Know


Questions and Answers
  • 1. 
    Columns in Ms Excel are labeled by number 1, 2, 3 and so on
    • A. 

      True

    • B. 

      False

    • C. 

      I Don't Know

  • 2. 
    You can rename and change color for Worksheet
    • A. 

      True

    • B. 

      False

    • C. 

      I Don't Know

  • 3. 
    You can use Data Tables to calculate and compare the outcome of different inputs of a formula.
    • A. 

      True

    • B. 

      False

    • C. 

      I Don't Know

  • 4. 
    You can import text from other sources into Excel without re-typing the data twice.
    • A. 

      True

    • B. 

      False

    • C. 

      I Don't Know

  • 5. 
    Goal Seek allow you to find the correct input to produce the desired outcome
    • A. 

      True

    • B. 

      False

    • C. 

      I Don't Know

  • 6. 
     Scenario Manager allow you to create, manipulate and save a number of different scenarios that use different input variables, producing different results
    • A. 

      True

    • B. 

      False

    • C. 

      I Don't Know

  • 7. 
    Solver allows you to find the best solution to complex problem that revolve around the manipulation of multiple variables and constraints
    • A. 

      True

    • B. 

      False

    • C. 

      I Don't Know

  • 8. 
    A Macrois a series of instructions that enables Excel 2003 to perform commands or actions for you
    • A. 

      True

    • B. 

      False

    • C. 

      I Don't Know

  • 9. 
    Password can be used to control security in Ms Excel 2003
    • A. 

      True

    • B. 

      False

    • C. 

      I Don't Know

  • 10. 
    You can create password for open and/or modify workbook
    • A. 

      True

    • B. 

      False

    • C. 

      I Don't Know

  • 11. 
    Worksheet and cell can be protect by using password and locked function.
    • A. 

      True

    • B. 

      False

    • C. 

      I Don't Know

  • 12. 
    Data Validation allows you to specify the type of data that is entered into a range of cells
    • A. 

      True

    • B. 

      False

    • C. 

      I Don't Know

  • 13. 
    You can use Text To Speech to read data back as you enter it.
    • A. 

      True

    • B. 

      False

    • C. 

      I Don't Know

  • 14. 
    When you save Ms Excel 2003 workbook, the format extension will be .xlsx
    • A. 

      True

    • B. 

      False

    • C. 

      I don't Know

  • 15. 
    The last cell for every worksheet in Ms Excel 2003 is located at cell IV65556.
    • A. 

      True

    • B. 

      False

    • C. 

      I Don't Know