College Computing:Exam 4

In the accompanying figure, the proper formula for calculating the total value in cell C15 is ____.

=G10+G11

The proper formula in Excel for calculating the percentage change between cells D3 and D2 is ____.

=(D3-D2)/D3

The proper formula in Excel for multiplying the value in cell B2 with the value in cell C2 is ____.

=B2*C2

In the accompanying figure, the values in columns E and G are in the ____ format.

Accounting

You can speed up the update of values in Excel linked to an Access table by updating the values manually in the ____ dialog box.

Edit Links

You should link an object to a PowerPoint slide when you are the only user of an object, and you want the object to be a part of your presentation.

False

All text formatted with the ____ style is imported into PowerPoint as a Level 1 item in a bulleted list.

Heading 2

To move to the top of an embedded Excel worksheet, enter [Ctrl] [ ____ ].

Home

In the accompanying figure, item 5 points to ____ text.

Level 2 heading

To embed an object in a PowerPoint presentation, you use the ____ command in the Text group on the INSERT tab.

Object

You can use the ____ command to embed Excel objects such as worksheets and charts into both Word and PowerPoint documents.

Object

The default theme in PowerPoint is the ____ theme.

Office

The accompanying figure represents a Word document in ____ view.

Outline

In the accompanying figure, item 1 points to the ____ button.

Promote

The table in the accompanying figure will be sorted by the ____ field.

Season

You can use [ ____ ][Tab] to promote headings in Outline view.

Shift

You normally break a link when you need to send a file to another user.

True

If a linked value did not update after making a change in a source file, click the FILE tab, click Edit Links to Files in the lower-right corner of the dialog box, and then click ____.

Update Values

You can use ____ to promote headings in Outline View.

[shift][tab]

When you embed a worksheet object in a PowerPoint slide, you generally want to show only the ____ that contain data.

cells

In the accompanying figure, item 3 points to a button that ____ the level of selected text.

demotes

To edit an embedded object, you ____ it.

double-click

A(n) ____ object in a PowerPoint file becomes a part of the PowerPoint file.

embedded

You can use source program tools to edit a(n) ____ object within a destination file.

embedded

An embedded object becomes a part of the PowerPoint file, which means that the file size of the PowerPoint presentation decreases.

false

When you double-click an embedded object, you can use the tools of the destination program to edit the object.

false

When you embed an object, you create a link to the source file.

false

You can export a Word outline into PowerPoint to automatically create slides without having to reenter information.

false

You can paste an Access table as a link in PowerPoint.

false

You cannot move or resize an object that has been copied from Excel and pasted into PowerPoint as a link.

false

In the accompanying figure, in order to calculate the value in cell E15, ____ numbers are added.

five

When you import slides into PowerPoint, you need to reset the ____ of the slides to conform to the PowerPoint slide design you have applied.

layout

If your presentation requires an object and you want to keep your presentation file size small, you should ____ the object's source file.

link

When you ____ an object to a PowerPoint slide, the object is still stored in the source file in the source program.

link

In the accompanying figure, because the Excel data is ____ an Access table, it will be updated when you update the Access table.

linked to

A value that you copy from Excel and paste into PowerPoint as a link is formatted as a(n) ____.

object

When you click the Demote button once while Body text is selected, the text moves to the right ____ tab stop(s) and changes from subtitle text to a Level 2 heading.

one

In the accompanying figure, the screen shown represents a ____ in Design view.

query

PowerPoint imports all text formatted with the Heading 1 style as a(n) ____.

slide title

In the accompanying figure, the drop-down list is a list of choices for ordering a(n) ____ operation.

sorting

You use linking when you want the linked information in the destination file to update when you change the ____ file.

source

Which of the following indicates the number of slides contained in a presentation?

status bar

In the accompanying figure, item 2 points to the level of the currently selected ____.

text

A block of text that is formatted with a heading style in Word is not included when it is imported into a PowerPoint presentation.

true

After updating an Access table, linked values in Excel will update automatically if you wait a few minutes.

true

You can copy an Access table from Access to PowerPoint.

true

You can integrate information into a PowerPoint presentation using the linking and embedding techniques you learned with Word, Excel, and Access.

true

You embed an object in a PowerPoint slide when you want to access the object in its source program, even if the source file is not available.

true

You frequently need to manage the links you create between files and programs.

true

You should link an object to a PowerPoint slide when you always want your object to include the latest information.

true