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.
- 1.
A Pivot Chart provides which ofvthese?
- A.
Thoughness
- B.
Technicality
- C.
Flexibility
- D.
Speed
Correct Answer
C. Flexibility -
- 2.
Which of these is a tool used for analyzing data?
- A.
Audit Analyze
- B.
Pivot table
- C.
Audit table
- D.
Expak
Correct Answer
B. Pivot table -
- 3.
Which of these can be done on a spreadsheet?
- A.
Calcukation
- B.
Organize Data
- C.
Analyze Data
- D.
All of the above
Correct Answer
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
Correct Answer
A. Costly -
- 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
Correct Answer
B. Cannot solve some advanced calculations -
- 6.
Excel supports import of external data through
- A.
ODBC
- B.
DISBIC
- C.
COBOL
- D.
CART
Correct Answer
A. ODBC -
- 7.
What is the graphical representation of pivot table called?
- A.
Benford Chart
- B.
Whil Chart
- C.
Chrome Chart
- D.
Pivot Chart
Correct Answer
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
Correct Answer
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
Correct Answer
A. To Audit with Ms Word -
- 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
Correct Answer
C. Computer Assited Audit Technique -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 18, 2022Quiz Edited by
ProProfs Editorial Team -
Mar 12, 2018Quiz Created by
Timmy198
Back to top