Bim Final

Before you insert an outline into a presentation, you need to determine where you want the new slides to be placed.

. T

A(n) __________________ object provides an easy-to-use data entry screen.

ACESS FORM

The cell in which you are working is called the ____________________ cell

ACTIVE

A(n) ____________________ field automatically assigns a new number each time you add a record.

AUTONUMBER

Clicking the ____________________ button sums the adjacent cell range above or to the left.

AUTOSUM

A(n) ____________________ can be used to insert text or objects such as clip art, tables, or charts.

CONTENT PLACEHOLDER

___________________ View is a spreadsheet-like view of the data in a table.

DATASHEET

. In an electronic spreadsheet, you need to manually recalculate when you change the entries

F

A(n) Entrance animation causes an object visible on the slide to have an effect.

F

Charts are updated automatically in Excel whenever data changes

F

The Spell Checker checks the text in inserted pictures or objects.

F

You can create an individual text box by clicking the Data button in the Text group on the INSERT tab of the Ribbon.

F

____________________ is an exception to copyright and permits the public to use copyrighted material for certain purposes without obtaining prior consent from the owner.

FAIR USE

A(n) ____________________ is an equation in a worksheet

FORMULA

Referring to the accompanying figure, the page on the left is showing a(n) ____ page.

HANDOUT

If you use ___________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.

LAYOUT

The primary view that is used to write, edit, and design a presentation is ____________________ view.

NORMAL

A(n) ___________________ relationship describes when a record from one table is related to several records in another table.

ONE TO MANY

A(n) ____________________ key field contains unique data for each record.

PRIMARY

24. A(n) __________________ object allows a user to select a subset of data from one or more tables.

QUERY

A named range can begin with a letter or number

T

Every slide in a PowerPoint presentation has a background, the area behind the text and graphics

T

The Entrance and Exit animations cause an object to enter or exit the slide with a(n) effect

T

When you import a Microsoft Word or a Rich Text Format document into a presentation, PowerPoint creates an outline structure based on the styles in the document.

T

A(n) ___________________ is a fundamental building block of a relational database because this object stores all of the data.

TABLE_

The SmartArt text styles and effects include text shadows, reflections, glows, bevels, 3D rotations, and transformations.

__________F_______________

The Excel operator for division is ____.

a. /

. As shown in the accompanying figure, item ____ points to the Name box.

a. 1

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

a. Edit mode

To review a printout of a table before printing, on the ____ tab, click Print, and then click Print Preview.

a. FILE

Which two properties are required for every field?

a. Field Name and Data Type

To open the Insert Picture dialog box, click the ____ tab on the Ribbon and then click the Pictures button in the Images group.

a. INSERT

To begin checking the spelling in your presentation, click the ____ tab on the Ribbon and then click the Spelling button in the Proofing group.

a. REVIEW

____ View provides the most options for defining fields.

a. Table Design

Cells in the first or top row of a chart are ____ names and provide further information about the data.

a. category

. Use ____ colors for slide background and text to make the text readable.

a. contrasting

In the accompanying figure, the entry in cell B4 is a ____.

a. label

Animation tags identify the ____ in which objects are animated during slide show

a. order

In the accompanying figure, the leftmost TourSales is a ____ tab.

a. query

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

a. record

In the accompanying figure, the rightmost TourSales tab is a ____ tab.

a. report

. As shown in the accompanying figure, item 3 points to the ____.

a. sheet tab

In Excel, a worksheet is contained in a file called a ____.

a. workbook

. As shown in the accompanying figure, item ____ points to the cell pointer, which outlines the active cell.

b. 2

In ____ view, you have the option of saving your presentation to your computer or SkyDrive.

b. Backstage

Which of the following is NOT a data type?

b. Formula

The New Slide button is in the Slides group on the ____ tab.

b. HOME

Which data type stores Web addresses

b. Hyperlink

The pane on the left-hand side in the accompanying figure is the ____ pane.

b. Miniature

The Forms and Reports at the left side of the Access window in the accompanying figure are contained in the ____.

b. Navigation Pane

The ____ button resets slide placeholders to their default position, size, and text formatting.

b. Reset

____ view displays your presentation on the whole computer screen.

b. Slide Show

The accompanying figure shows a PowerPoint presentation in ____ view.

b. Slide Sorter

You can use the ____ slider on the status bar to enlarge your view of specific areas of your worksheet

b. Zoom

Entrance and Exit are ____.

b. animation categories

Which Access object provides an easy-to-use data entry screen?

b. form

In the accompanying figure, the entry in cell B15 is a ____.

b. formula

A(n) ____ is a built-in formula that uses arguments to calculate information.

b. function

Tables, queries, and forms are examples of Access ____.

b. objects

In the accompanying figure, the text "Click to add title" is the title ____.

b. placeholder

Possible paper orientations for printing a worksheet are landscape and ____.

b. portrait

Which of the following is NOT available to you as you start Access?

b. recalibrating an existing database

An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.

b. spreadsheet

In the accompanying figure, the numbers that appear under each of the slides are the ____ timings.

b. transition

In Presenter view, the next slide in the presentation appears in the ____ corner of the screen

b. upper-right

As shown in the accompanying figure, item ____ points to the formula bar.

c. 3

____ operators perform mathematical calculations such as adding and subtracting.

c. Arithmetic

Themes are found on the ____ tab.

c. DESIGN

PowerPoint uses ____ to create numerical charts.

c. Excel

You can preview the look of a design theme before committing to it using ____.

c. Live Preview

The presentation shown in the accompanying figure is in ____ view.

c. Normal

The ____ option helps fit the data on a single page without making changes to individual margins

c. Page Break View

Which is NOT true about Access

c. Reporting is limited to 20 saved reports.

Which data type stores only one of two values?

c. Yes/No

. Doug is looking to make sure that he can prioritize the points on his slides visually. What should he use to do this?

c. bulleted lists

Microsoft Access can best be described as ____ software.

c. database

All Excel formulas begin with the ____.

c. equal sign (=)

A specific category of data such as a customer's name, city, state, or phone number is called a(n) ____.

c. field

In the accompanying figure, CustomerRoster is a ____ tab

c. form

. As shown in the accompanying figure, item 2 points to the ____.

c. mode indicator

On the Ribbon, each set of primary commands is identified by a(n) ____.

c. tab

In the accompanying figure, Customers is a ____ tab.

c. table

Which Access object contains all of the raw data within the database

c. table

. What is the smallest font size Doug should use in the text on his slides?

d. 30 points

Excel recognizes an entry as a value if it is a number or it begins with ____.

d. All of the above.

With PowerPoint, you can import text, photographs, numerical data, and facts from files created in such programs as ____.

d. All of the above.

As shown in the accompanying figure, item 4 points to the ____.

d. New sheet button

Based on the chart in the accompanying figure, what data marker represents the smallest data point?

d. Quarter 1 - India

The ____ is fully customizable

d. Quick Access toolbar

The ____ organizes all of PowerPoint's primary commands.

d. Ribbon

____ below the worksheet grid let you switch from sheet to sheet in a workbook.

d. Sheet tabs

Which of the following keys will help you delete unwanted data in Edit mode?

d. [Backspace]

The Excel operator for exponent is ____.

d. ^

A content placeholder can be used to insert all of the following EXCEPT ____.

d. apps

Which is NOT a feature of Access reports?

d. easy-to-use data entry screen

In the accompanying figure, what chart item explains which color represents each quarter?

d. legend

. As shown in the accompanying figure, item 1 points to the ____.

d. sheet tab scrolling button

It is a good idea to limit each slide to six words per line and ____ lines per slid.

d. six

In the accompanying figure, the entry in cell B5 is a ____.

d. value

In Excel, the electronic spreadsheet you work in is called a ____.

d. worksheet