Bus245 week 6 Quiz: Reports and Data Gathering
*You have 1 hour and counting…to complete the quiz. This is a timed online quiz…the one hour timer just
begun. I must have solution within the hour. Best of luck!
Question 1. 1. (TCO 1) When creating a report, you should consider all of the following EXCEPT
(Points : 4)
who will use the report
the purpose of the report
data that should be considered confidential
number of records input into the report
Question 2. 2. (TCO 1) A report footer (Points : 4)
is used to print page numbers on the report.
prints group statistics at the end of the report.
prints grand totals at the end of the report.
All of the above
Question 3. 3. (TCO 1) Which report section would be used to summarize grouped field data? (Points :
4)
Detail
Group Header
Group Footer
Report Footer
Question 4. 4. (TCO 1) The selected image below shows
Image not shown do not worry about #4
(Points : 4)
Report View.
Layout View.
Design View.
Print View.
Question 5. 5. (TCO 1) Grouping data in a report will (Points : 4)
provide grand totals for your report.
let you organize and summarize your data.
make a report more attractive.
allow you to edit data in a record.
Question 6. 6. (TCO 1) When designing a report, make sure that your report (Points : 4)
has a date and time.
has grouped data.
is easy to understand.
uses all report sections.
Question 7. 7. (TCO 7) A pie chart is used to display (Points : 4)
continuous data.
discrete data.
percentages of a whole.
vertically stacked data.
Question 8. 8. (TCO 7) In addition to the detail field, the primary drop zone in a PivotTable design grid
is the (Points : 4)
column field.
filter field.
row field.
All of the above
Question 9. 9. (TCO 7) A Drill button is used to (Points : 4)
collapse and expand groups in a scatter chart.
filter data in an area chart.
hide information in a line chart.
provide detail data in a PivotTable.
Question 10. 10. (TCO 7) Based on the values in aggregate data, a calculated total field in a PivotTable
(Points : 4)
allows for grouped data.
generates a new field.
provides for Average, Standard Deviation, and Sum totals.
All of the above
