0 Comments

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

Order Solution Now

Categories: