Unit Test — Cumulative exam Answers

25 verified answers1 views
1
Free Preview

Which is the best description of a hierarchical report?

A
a report with data in multiple columns
B
a report with one or more groups of records
C
a report with one or more reports within the main report
D
a report with records sorted in ascending or descending order
2
Free Preview

What is the function of a primary key in a table?

A
to uniquely identify each record in the table
B
to uniquely identify foreign keys in the table
C
to secure table data
D
to secure the foreign keys in the table
4

Where are options to add a border around the outside of a chart found?

A
Design tab in the Chart Layout gallery
B
Format tab in the Shape Styles group
C
Layout tab in the Background group
D
Insert tab in the Format gallery
5

What is the quickest way to remove all filters that have been applied to a worksheet?

A
Click each filter and select Clear Filter.
B
Click the Filter button in the Sort & Filter group.
C
Select the worksheet and click Clear Filter.
D
Select the worksheet and click Delete All Filters.
8

How do most database users perform data searches?

A
by using forms
B
by generating reports
C
by viewing tables
D
by performing calculations
13

What is the primary location of WordArt styles?

A
WordArt styles gallery
B
Picture command
C
Design tab
D
Format Painter tool
15

How are charts inserted into a PowerPoint slide?

A
Open the chart in Excel, click it, and drag it into the slide.
B
Double-click the chart in Excel, and click inside the slide to paste it into the presentation.
C
Use the Copy tool to copy the chart from Excel and the Paste tool to insert it into the slide.
D
Take a screenshot of the chart from Excel and paste it into the slide using the Paste tool.
16

Which characteristic of a relational database distinguishes it from a flat file?

A
A single table is accessed by a single user in a relational database.
B
A single table is accessed by many users in a relational database.
C
Several tables are linked together through common fields in a relational database.
D
Several tables are linked together through common users in a relational database.

Did you find these answers helpful?