Auditor Excel Test

10 Questions | Attempts: 155
Share
SettingsSettings
Please wait...
  • 1/10 Questions

    Which of these can be done on a spreadsheet?

    • Calcukation
    • Organize Data
    • Analyze Data
    • All of the above
Please wait...
About This Quiz

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.

Auditor Excel Test - Quiz

Quiz Preview

  • 2. 

    What is the graphical representation of pivot table called?

    • Benford Chart

    • Whil Chart

    • Chrome Chart

    • Pivot Chart

    Correct Answer
    A. Pivot Chart
  • 3. 

    One of these is a challenge faced by traditional Audit

    • High Volume of Data

    • High Capital

    • High sampling risk

    • A and C

    Correct Answer
    A. A and C
  • 4. 

    Which of these is a tool used for analyzing data?

    • Audit Analyze

    • Pivot table

    • Audit table

    • Expak

    Correct Answer
    A. Pivot table
  • 5. 

    Which of these is not an advantage of Ms excel for Auditing?

    • Costly

    • Highly Flexible

    • Simpler than most CAAT tools

    • Huge list of functions

    Correct Answer
    A. Costly
  • 6. 

    What is CAAT?

    • Central Audit Array Tools

    • Computer Audit Assisted Term

    • Computer Assited Audit Technique

    • Complete Array of Audit Tools

    Correct Answer
    A. Computer Assited Audit Technique
  • 7. 

    A Pivot Chart provides which ofvthese?

    • Thoughness

    • Technicality

    • Flexibility

    • Speed

    Correct Answer
    A. Flexibility
  • 8. 

    The following are limitations of using MS Excel for auditing except?

    • Takes much longer to process large data

    • Cannot solve some advanced calculations

    • Limited Data size

    • Cannot log or document the Audit work done

    Correct Answer
    A. Cannot solve some advanced calculations
  • 9. 

    CAAT is developed for the following except?

    • To Audit with Ms Word

    • To Audit electronic Data

    • To Audit things that. can't be Audited manually

    • Option 4

    Correct Answer
    A. To Audit with Ms Word
  • 10. 

    Excel supports import of external data through

    • ODBC

    • DISBIC

    • COBOL

    • CART

    Correct Answer
    A. ODBC

Quiz Review Timeline (Updated): Mar 18, 2022 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 18, 2022
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 12, 2018
    Quiz Created by
    Timmy198
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.