Microsoft Excel 2007- Formulas And Function

25 Questions | Total Attempts: 362

Settings
Please wait...
Microsoft Excel Quizzes & Trivia

To my 1st year


Questions and Answers
  • 1. 
    This error is the most often the result of specifying a mathematical operation with one or more cells that contain text.
    • A. 

      #VALUE!

    • B. 

      #REF!

    • C. 

      #NUM!

    • D. 

      #NULL

  • 2. 
    This warning means that your formula referred to a cell that doesn’t exist, and thus the result cannot be displayed.
    • A. 

      #VALUE!

    • B. 

      #REF!

    • C. 

      #NUM!

    • D. 

      #NULL

  • 3. 
    Occurs if you insert a space instead of a comma between ranges used in function arguments.
    • A. 

      #VALUE!

    • B. 

      #REF!

    • C. 

      #NUM!

    • D. 

      #NULL

  • 4. 
    Occurs when invalid argument exist in an Excel function or a formula procedures a number that is too large or too small to be represented in the worksheet.
    • A. 

      #VALUE!

    • B. 

      #REF!

    • C. 

      #NUM!

    • D. 

      #NULL

  • 5. 
    The content of the cell cannot be displayed correctly as the cell column is too narrow.
    • A. 

      NAME?

    • B. 

      ####

    • C. 

      #DIV/o

    • D. 

      #N/A

  • 6. 
    A cell that contains the value o or is blank.
    • A. 

      NAME?

    • B. 

      ####

    • C. 

      #DIV/o

    • D. 

      #N/A

  • 7. 
    No value available appear, Technically, this is not an error value but a special value.
    • A. 

      NAME?

    • B. 

      ####

    • C. 

      #DIV/o

    • D. 

      #N/A

  • 8. 
    Excel doesn’t recognize a name, which formula cannot be computed if text is included.
    • A. 

      NAME?

    • B. 

      ####

    • C. 

      #DIV/o

    • D. 

      #N/A

  • 9. 
    It identifies a cell or range on a worksheet and tells MS Excel where to look for the values or data that you want to use in a formula.
    • A. 

      Relative References

    • B. 

      Absolute References

    • C. 

      References

    • D. 

      Mix References

  • 10. 
    It does not adjust the cell reference when you move or copy a formula.
    • A. 

      Relative References

    • B. 

      Absolute References

    • C. 

      References

    • D. 

      Mix References

  • 11. 
    It stores the exact location of the cell to which the formula refers while taking careful note of where those cells are located in relation to the cell that contains the formula.
    • A. 

      Relative References

    • B. 

      Absolute References

    • C. 

      References

    • D. 

      Mix References

  • 12. 
    These are combination of relative and absolute reference such as relative column and absolute row or column and relative row.
    • A. 

      Relative References

    • B. 

      Absolute References

    • C. 

      References

    • D. 

      Mix References

  • 13. 
    This function allows you to compute the periodic payment amount for a loan on a car, house, or Education plan.
    • A. 

      PMT Function

    • B. 

      RATE

    • C. 

      NPER

    • D. 

      PV

  • 14. 
    This function will give you the present value or the lump-sum amount that a series of payment is  worth right now.
    • A. 

      PMT Function

    • B. 

      RATE

    • C. 

      NPER

    • D. 

      PV

  • 15. 
    This function is the payment made each period; thus, it cannot change over the life of an annual.
    • A. 

      PMT Function

    • B. 

      RATE

    • C. 

      NPER

    • D. 

      PV

  • 16. 
    This function is the total number of payment period in a year
    • A. 

      PMT Function

    • B. 

      RATE

    • C. 

      NPER

    • D. 

      PV

  • 17. 
    This function will return the interest rate per period of an annuity. It calculated by iteration and can have zero or more solutions.
    • A. 

      PMT Function

    • B. 

      RATE

    • C. 

      NPER

    • D. 

      PV

  • 18. 
    It is to create a new file.
    • A. 

      Ctrl + N

    • B. 

      Ctrl + O

    • C. 

      Ctrl + Z

    • D. 

      Ctrl + H

  • 19. 
    It is used to close single file.
    • A. 

      Crtl + W

    • B. 

      Ctrl + O

    • C. 

      Ctrl + P

    • D. 

      Alt + F4

  • 20. 
    It is used to close application file.
    • A. 

      Crtl + W

    • B. 

      Ctrl + O

    • C. 

      Ctrl + P

    • D. 

      Alt + F4

  • 21. 
    It is used to save a file.
    • A. 

      Ctrl + S

    • B. 

      File>Save As

    • C. 

      Save Button

    • D. 

      All of the above

  • 22. 
    To open ms excel using cmd command, type:
    • A. 

      Type msexcel

    • B. 

      Type msexcel.exe

    • C. 

      Type excel.exe

    • D. 

      Type msexcel2007.exe

  • 23. 
    It is to undo your previous action.
    • A. 

      Ctrl + Z

    • B. 

      Ctrl + Y

    • C. 

      Ctrl + P

    • D. 

      Ctrl + Y

  • 24. 
    In Using Formulas, One of the most valuable features of excel is to:
    • A. 

      To store mathematical calculation

    • B. 

      Expression in individual cell

    • C. 

      To edit the text on the workspace

    • D. 

      None of the above

  • 25. 
    It is a data entry capable of performing mathematical and logical operations automatically.
    • A. 

      Data Entry

    • B. 

      Solution Program

    • C. 

      Formulas

    • D. 

      None of the above