Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The PivotTable shown below is being used to conduct a data audit.There are two fields under the Row Labels heading: Store and Cashier Number.The Transaction

The PivotTable shown below is being used to conduct a data audit.There are two fields under the Row Labels heading: Store and Cashier Number.The Transaction Count column is counting the transaction numbers that were processed for each cashier on 9/14/2020in store 100PA.Which of the following would be cause for concernin using this data?

image text in transcribed
A D 1 Date 9/14/2020 2 3 Row Labels Transaction Count 4 E 100PA 135 5 5500-100PA 45 6 5600-100PA 45 5700-100PA 45 110PA 135 O There are no field names shown for the Store or Cashier Number fields. O The store number 100PA is shown twice. O There are only three cashiers. O There is an error symbol next to the date 9/14/2020. O All three cashiers are showing exactly the same number of transactions processed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Financial Accounting

Authors: Richard Baker, Valdean Lembke, Thomas King, Cynthia Jeffrey

8th Edition

73526916, 978-0073526911

More Books

Students also viewed these Accounting questions

Question

2. Information that comes most readily to mind (availability).

Answered: 1 week ago

Question

3. An initial value (anchoring).

Answered: 1 week ago

Question

4. Similarity (representativeness).

Answered: 1 week ago