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
