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 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/2020 in store 100PA. Which of the following would be cause for concern in using this data?
Image of a PivotTable with field name Date in the upper left corner. To the right of the field name is the date 9/14/2020. A small image in the shape of a funnel is to the right of the date 9/14/2020. There are two columns of data: Row Labels and Transaction Count.
Responses
There are no field names shown for the Store or Cashier Number fields.
There are no field names shown for the Store or Cashier Number fields.
There is an error symbol next to the date 9/14/2020.
There is an error symbol next to the date 9/14/2020.
The store number 100PA is shown twice.
The store number 100PA is shown twice.
All three cashiers are showing exactly the same number of transactions processed.
All three cashiers are showing exactly the same number of transactions processed.
There are only three cashiers.

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

Step: 3

blur-text-image

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

Oracle Database Foundations Technology Fundamentals For IT Success

Authors: Bob Bryla

1st Edition

0782143725, 9780782143720

More Books

Students also viewed these Databases questions

Question

What is the reversal journal entry for mark-to-market?

Answered: 1 week ago

Question

9. Describe the characteristics of power.

Answered: 1 week ago