Auditor Excel Test
Settings
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.
- 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
Back to top