Auditor Excel Test

10 Questions | Total Attempts: 119

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