Question 1 4 points Captions are snippets of text that numbe

Question 1 (4 points)

Captions are snippets of text that number and identify pictures, equations, tables, charts, and other items in your document.

Question 1 options:

Save

Question 2 (4 points)

The ____ is also referred to as a works cited page

Question 2 options:

Bookmark

Bibliography

Citation

Table of Contents

Save

Question 3 (4 points)

Parameter queries increase efficiency

Question 3 options:

Save

Question 4 (4 points)

You use a query to ask MS Access a question.

Question 4 options:

Save

Question 5 (4 points)

A table of contents can be created based on ____ styles already applied within a documen

Question 5 options:

Printing

Hyperlink

Index

Heading

Save

Question 6 (4 points)

Before you present your slides, you should use the ____ Show command to verify your current settings and to specify additional settings.

Question 6 options:

Practice

Present

View

Setup

Save

Question 7 (4 points)

An advange of using Ring Topology is _____

Question 7 options:

Each packet of data must pass through all the computers between source and destination. This makes it slower than Star Topology

Each computer has equal access to resources.

If one workstation or port goes down, the entire network gets affected.

Network is highly dependent on the wire which connects different components.

Save

Question 8 (4 points)

The following is an example of what type of chart?

Question 8 options:

Surface Chart

Combination Chart

Pie Chart

Scatter Chart

Save

Question 9 (4 points)

You can use the ____ feature to prepare addressed envelopes for a group or mass mailing.

Question 9 options:

Mass Mailing

Envelope Merge

Group Mail

Mail Merge

Save

Question 10 (4 points)

Once created, you can save a photo album (or any presentation file) as a video in a(n) ____ format.

Question 10 options:

.avi

.dvd

.vid

.wmv

Save

Question 11 (4 points)

Visually highlighting values that identify departments that are performing especially well, or highlighting departments that are under-performing is an example of

Question 11 options:

View

Action Query

Conditional Formatting

Arrange

Save

Question 12 (4 points)

Refers to a set of actions that can be run automatically, and on demand

Question 12 options:

Tracing

Goal Seek

Records

Macros

Save

Question 13 (4 points)

Pre-set portions of content that you can use/reuse in your document

Question 13 options:

Building Blocks

Wildcard

Single Character

MAPI

Save

Question 14 (4 points)

A ____ lets you rearrange worksheet data so you can analyze it in a variety of ways.

Question 14 options:

Chart

Sparkline

Watch Window

Pivot Table

Save

Question 15 (4 points)

Embedding an object is what occurs when you choose to insert something from another application into another.

Question 15 options:

Save

Question 16 (4 points)

Which is the most commonly used data model in database management today?

Question 16 options:

relational

multidimensional

object oriented

network

Save

Question 17 (4 points)

What is a DBMS?

Question 17 options:

a structured collection of records or data

a complex set of software programs that control the organization, storage, management, and retrieval of data in a database

a theory describing how a database is structured and used

a database that conforms to the relational model

Save

Question 18 (4 points)

Which of the following characters is NOT allowed in a macro name?

Question 18 options:

underscore

lowercase letter

space

number

Save

Question 19 (4 points)

Subtotals allow you to summarize a range of data with the following functions: ___________.

Question 19 options:

AVERAGE, MAX, MIN, MEDIAN, SUM

COUNT, AVERAGE, MAX, MIN, MEDIAN

COUNT, AVERAGE, MEDIAN, SUM

COUNT, AVERAGE, MAX, MIN, SUM

Save

Question 20 (4 points)

In which programming language are Excel macros created?

Question 20 options:

Visual Basic for Macros (VBM)

Visual Basic for Applications (VBA)

C++

BASIC

Save

Question 21 (4 points)

Bulleted text on slides should ___________.

Question 21 options:

always be in complete sentences

be no more than seven words long

be only one word long

be no more than fifteen words long

Save

Question 22 (4 points)

___________ are effects that determine how slides progressively show up on the screen.

Question 22 options:

Animations

Movies

Custom Effects

Transitions

Save

Question 23 (4 points)

What do you select in the Office Theme menu in PowerPoint?

Question 23 options:

Slide Layouts

Slide Backgrounds

Slide Theme Colors

Slide Animations

Save

Question 24 (4 points)

How do you crop and adjust the height and width of a picture you have inserted into a document?

Question 24 options:

Choose Picture Styles from the Format ribbon.

Choose Picture Shape from the Format ribbon.

Choose Adjust from the Format ribbon.

Choose Size from the Format ribbon.

Save

Question 25 (4 points)

A bibliography is a list of ___________.

Question 25 options:

additional information provided in the text of a document

all the sources used to gather information for a document

only those sources referenced in the citations of a document

objects, such as charts or pictures, included in a document

Save

	True
	False

Solution

Question 7: Each computer has equal access to resources.

Question 8: Combination Chart

Question 9: mail merge

Question 10: .vid

Question 11: Conditional Formatting

Question 16: relational

Question 17: a complex set of software programs that control the organization, storage, management and retrieval of data in database.

Question 18: space

Question 20: Visual Basic for Applications (VBA)

Question 22: Transitions

Question 23: Slide Theme Colors

Question 25: all the sources used to gather information for a document