Auditor Excel Test

10 Questions

Settings
Please wait...
Auditor Excel Test

Excel is one of the most prominent tools used for auditing. It is widely used all over the world. It provides you a basic familiarity of using spread sheets, powerful data import features and lot more. What do you know about auditing with excel? Here is a quiz for you.


Questions and Answers
  • 1. 
    A Pivot Chart provides which ofvthese?
    • A. 

      Thoughness

    • B. 

      Technicality

    • C. 

      Flexibility

    • D. 

      Speed

  • 2. 
    Which of these is a tool used for analyzing data?
    • A. 

      Audit Analyze

    • B. 

      Pivot table

    • C. 

      Audit table

    • D. 

      Expak

  • 3. 
    Which of these can be done on a spreadsheet?
    • A. 

      Calcukation

    • B. 

      Organize Data

    • C. 

      Analyze Data

    • D. 

      All of the above

  • 4. 
    Which of these is not an advantage of Ms excel for Auditing?
    • A. 

      Costly

    • B. 

      Highly Flexible

    • C. 

      Simpler than most CAAT tools

    • D. 

      Huge list of functions

  • 5. 
    The following are limitations of using MS Excel for auditing except?
    • A. 

      Takes much longer to process large data

    • B. 

      Cannot solve some advanced calculations

    • C. 

      Limited Data size

    • D. 

      Cannot log or document the Audit work done

  • 6. 
    Excel supports import of external data through
    • A. 

      ODBC

    • B. 

      DISBIC

    • C. 

      COBOL

    • D. 

      CART

  • 7. 
    What is the graphical representation of pivot table called?
    • A. 

      Benford Chart

    • B. 

      Whil Chart

    • C. 

      Chrome Chart

    • D. 

      Pivot Chart

  • 8. 
    One of these is a challenge faced by traditional Audit
    • A. 

      High Volume of Data

    • B. 

      High Capital

    • C. 

      High sampling risk

    • D. 

      A and C

  • 9. 
    CAAT is developed for the following except?
    • A. 

      To Audit with Ms Word

    • B. 

      To Audit electronic Data

    • C. 

      To Audit things that. can't be Audited manually

    • D. 

      Option 4

  • 10. 
    What is CAAT?
    • A. 

      Central Audit Array Tools

    • B. 

      Computer Audit Assisted Term

    • C. 

      Computer Assited Audit Technique

    • D. 

      Complete Array of Audit Tools