Question 1

Deepak's presentation contains 10 sections. He wants to view only the slides in the eighth section.

Accepted Answer

A)  Delete all of the sections except the eighth section. 
B)  Collapse all of the sections except the eighth section. 
C)  Delete all of the slides except the slides in the eighth section. 
D)  Expand all of the sections except the eighth section. 
A)  Delete all of the sections except the eighth section. 
B)  Collapse all of the sections except the eighth section. 
C)  Delete all of the slides except the slides in the eighth section. 
D)  Expand all of the sections except the eighth section. B

Question 2

If you want to quickly resize the windows of two open presentations and place them side by side, which command could you use?

Accepted Answer

A)  Arrange All 
B)  Split Windows 
C)  Compare Windows 
D)  Switch Windows 
A)  Arrange All 
B)  Split Windows 
C)  Compare Windows 
D)  Switch Windows A

Question 3

When you edit the source file an a linked object on a slide, what happens to the linked object?

Accepted Answer

A)  Nothing because the linked object is not connected to the source file, only to the source program. 
B)  The changes are made in both the source file and in the linked object. 
C)  The changes are made in the source file, and then the file containing the linked object automatically opens so you can make the changes there as well. 
D)  Nothing because if you want to edit a linked object, you need to edit it in the destination file. 
A)  Nothing because the linked object is not connected to the source file, only to the source program. 
B)  The changes are made in both the source file and in the linked object. 
C)  The changes are made in the source file, and then the file containing the linked object automatically opens so you can make the changes there as well. 
D)  Nothing because if you want to edit a linked object, you need to edit it in the destination file. B

Question 4

When you enter a slide title in the Outline pane in Outline view, what happens when you press ENTER?

Accepted Answer

A)  The first item in a bulleted list on the slide is created. 
B)  The view changes to Normal view and the insertion point appears on the slide. 
C)  The slide is duplicated. 
D)  A new slide is created. 
A)  The first item in a bulleted list on the slide is created. 
B)  The view changes to Normal view and the insertion point appears on the slide. 
C)  The slide is duplicated. 
D)  A new slide is created.

Question 5

Which of the following are ways you can rotate text in a shape or text box? Select all the options that apply.

Accepted Answer

A)  Horizontal 
B)  Rotated 90 degrees so that it turns sideways and reads from top to bottom. 
C)  Rotated 270 degrees so that it turns sideways and reads from bottom to top. 
D)  Stacked so that the letters go from top to bottom, one below the other. 
E) None of the above 
A)  Horizontal 
B)  Rotated 90 degrees so that it turns sideways and reads from top to bottom. 
C)  Rotated 270 degrees so that it turns sideways and reads from bottom to top. 
D)  Stacked so that the letters go from top to bottom, one below the other. 
E) None of the above

Question 6

How can you align data in a table cell? Select all the options that apply.

Accepted Answer

A)  Horizontally 
B)  Upside down 
C)  In reverse 
D)  Vertically 
A)  Horizontally 
B)  Upside down 
C)  In reverse 
D)  Vertically

Question 7

Which of the following means to place a copy of an object from a source file in a destination file but maintain a connection to the source program so that you can edit the object in the destination file using the source program?

Accepted Answer

A)  Embed 
B)  Import 
C)  Link 
D)  Paste 
A)  Embed 
B)  Import 
C)  Link 
D)  Paste

Question 8

Antonio's presentation contains seven sections. He wants to move all of the slides in the fifth section up so they appear before the second section. Which of the following is the best way of accomplishing this? Select all options that apply.

Accepted Answer

A)  In Normal view, in the pane that contains the thumbnails, drag the section header of the fifth section up until a horizontal line following the pointer indicates that the section you are dragging appears above the section header of the second section. 
B)  In Slide Sorter view, in the pane that contains the thumbnails, drag the section header of the fifth section up until a horizontal line following the pointer indicates that the section you are dragging appears just below the section header of the second section. 
C)  In Normal or Slide Sorter view, select all of the slides in the fifth section, and then cut them using the Cut command. Click before the first slide in the second section in the pane that contains the thumbnails, and then use the Paste command. Then select the first slide that was in the second section originally, and insert a new section. Finally, delete the section header of the original fifth section. 
D)  In Normal or Slide Sorter view, right-click the section header of the fifth section, and then click Move Section Up on the shortcut menu. Repeat this two more times. 
A)  In Normal view, in the pane that contains the thumbnails, drag the section header of the fifth section up until a horizontal line following the pointer indicates that the section you are dragging appears above the section header of the second section. 
B)  In Slide Sorter view, in the pane that contains the thumbnails, drag the section header of the fifth section up until a horizontal line following the pointer indicates that the section you are dragging appears just below the section header of the second section. 
C)  In Normal or Slide Sorter view, select all of the slides in the fifth section, and then cut them using the Cut command. Click before the first slide in the second section in the pane that contains the thumbnails, and then use the Paste command. Then select the first slide that was in the second section originally, and insert a new section. Finally, delete the section header of the original fifth section. 
D)  In Normal or Slide Sorter view, right-click the section header of the fifth section, and then click Move Section Up on the shortcut menu. Repeat this two more times.

Question 9

What should you add to describe the data in a chart?

Accepted Answer

A)  A legend 
B)  A title 
C)  A chart style 
D)  An animation 
A)  A legend 
B)  A title 
C)  A chart style 
D)  An animation

Question 10

You can change the direction of text in a shape.

Accepted Answer

A) True 
 B)False

Question 11

Suppose you inserted a circle on a slide, then inserted a rectangle on top of the circle, and finally inserted a triangle on top of the rectangle. Which of the following commands would you use to have the circle move to the top layer on top of the triangle?

Accepted Answer

A)  Bring Forward 
B)  Bring to Front 
C)  Send Backward 
D)  Send to Back 
A)  Bring Forward 
B)  Bring to Front 
C)  Send Backward 
D)  Send to Back

Question 12

Which view shows the titles and text of the presentation as an outline?

Accepted Answer

A)  Normal view 
B)  Outline view 
C)  Slide Sorter view 
D)  Reading view 
A)  Normal view 
B)  Outline view 
C)  Slide Sorter view 
D)  Reading view

Question 13

Amir created a column chart from a data source that listed the sales for each of three sales reps over the course of six months. He wants the chart to compare the sales of each rep to the sales of the other two reps. But when he created the chart, the months appeared on the horizontal axis instead of the names of the sales reps. What can he do to change the chart so that the names of the sales reps appear on the horizontal axis?

Accepted Answer

A)  Change the chart type. 
B)  Change the chart layout 
C)  Use the Switch Row / Column command. 
D)  Switch the data labels. 
A)  Change the chart type. 
B)  Change the chart layout 
C)  Use the Switch Row / Column command. 
D)  Switch the data labels.

Question 14

Which of the following are ways you can rotate text in a table cell? Select all the options that apply.

Accepted Answer

A)  Horizontal 
B)  Rotated 90 degrees so that it turns sideways and reads from top to bottom. 
C)  Rotated 270 degrees so that it turns sideways and reads from bottom to top. 
D)  Stacked so that the letters go from top to bottom, one below the other. 
E)  None the above 
A)  Horizontal 
B)  Rotated 90 degrees so that it turns sideways and reads from top to bottom. 
C)  Rotated 270 degrees so that it turns sideways and reads from bottom to top. 
D)  Stacked so that the letters go from top to bottom, one below the other. 
E)  None the above

Question 15

You can divide slides into sections to help organize the slides.

Accepted Answer

A) True 
 B)False

Question 16

Which of these will you click on the Insert tab in the Text group to insert an equation?

Accepted Answer

A)  Signature Line 
B)  Object 
C)  Date & Time 
D)  Object Line 
A)  Signature Line 
B)  Object 
C)  Date & Time 
D)  Object Line

Question 17

Which of the following describes an object that is created in a source program and is edited in the destination file using the destination program?

Accepted Answer

A)  Embedded object 
B)  Created object 
C)  Linked object 
D)  Copied and pasted object 
A)  Embedded object 
B)  Created object 
C)  Linked object 
D)  Copied and pasted object

Question 18

How do you select everything on a slide except objects on the slide background?

Accepted Answer

A)  On the Home tab, click the Select button, and then click Select All. 
B)  Triple-click in the center of the slide. 
C)  Right-click a blank area of the slide, and then click Select All on the menu. 
D)  Click the Select All button in the status bar. 
A)  On the Home tab, click the Select button, and then click Select All. 
B)  Triple-click in the center of the slide. 
C)  Right-click a blank area of the slide, and then click Select All on the menu. 
D)  Click the Select All button in the status bar.

Question 19

To move a slide in Outline view, drag the slide icon.

Accepted Answer

A) True 
 B)False

Question 20

Marco has created a very large slide show covering a variety of topics. He wants to organize the slides in a more useful arrangement. Which of the following is the best solution to his problem?

Accepted Answer

A)  Ask the department manager to assign the project to someone more familiar with PowerPoint. 
B)  Delete at least 80 percent of the slides and focus on the content on the remaining 20 percent. 
C)  Break the slide show into at least three different presentation files and use hyperlinks to link to individual slides in each presentation. 
D)  Divide the slides into sections by topic and then reorganize the sections to meet his arrangement criteria. 
A)  Ask the department manager to assign the project to someone more familiar with PowerPoint. 
B)  Delete at least 80 percent of the slides and focus on the content on the remaining 20 percent. 
C)  Break the slide show into at least three different presentation files and use hyperlinks to link to individual slides in each presentation. 
D)  Divide the slides into sections by topic and then reorganize the sections to meet his arrangement criteria.

Deepak's presentation contains 10 sections. He wants to view only the slides in the eighth section.

If you want to quickly resize the windows of two open presentations and place them side by side, which command could you use?

When you edit the source file an a linked object on a slide, what happens to the linked object?

When you enter a slide title in the Outline pane in Outline view, what happens when you press ENTER?

Which of the following are ways you can rotate text in a shape or text box? Select all the options that apply.

How can you align data in a table cell? Select all the options that apply.

Which of the following means to place a copy of an object from a source file in a destination file but maintain a connection to the source program so that you can edit the object in the destination file using the source program?

Antonio's presentation contains seven sections. He wants to move all of the slides in the fifth section up so they appear before the second section. Which of the following is the best way of accomplishing this? Select all options that apply.

What should you add to describe the data in a chart?

You can change the direction of text in a shape.

Suppose you inserted a circle on a slide, then inserted a rectangle on top of the circle, and finally inserted a triangle on top of the rectangle. Which of the following commands would you use to have the circle move to the top layer on top of the triangle?

Which view shows the titles and text of the presentation as an outline?

Which of the following are ways you can rotate text in a table cell? Select all the options that apply.

You can divide slides into sections to help organize the slides.

Which of these will you click on the Insert tab in the Text group to insert an equation?

Which of the following describes an object that is created in a source program and is edited in the destination file using the destination program?

How do you select everything on a slide except objects on the slide background?

To move a slide in Outline view, drag the slide icon.

Marco has created a very large slide show covering a variety of topics. He wants to organize the slides in a more useful arrangement. Which of the following is the best solution to his problem?

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Managing Data With Data Tools

Filters

Exam 5: Generating Reports From Multiple Worksheets and Workbooks

Deepak's presentation contains 10 sections. He wants to view only the slides in the eighth section.

If you want to quickly resize the windows of two open presentations and place them side by side, which command could you use?

When you edit the source file an a linked object on a slide, what happens to the linked object?

When you enter a slide title in the Outline pane in Outline view, what happens when you press ENTER?

Which of the following are ways you can rotate text in a shape or text box? Select all the options that apply.

How can you align data in a table cell? Select all the options that apply.

Which of the following means to place a copy of an object from a source file in a destination file but maintain a connection to the source program so that you can edit the object in the destination file using the source program?

Antonio's presentation contains seven sections. He wants to move all of the slides in the fifth section up so they appear before the second section. Which of the following is the best way of accomplishing this? Select all options that apply.

What should you add to describe the data in a chart?

You can change the direction of text in a shape.

Suppose you inserted a circle on a slide, then inserted a rectangle on top of the circle, and finally inserted a triangle on top of the rectangle. Which of the following commands would you use to have the circle move to the top layer on top of the triangle?

Which view shows the titles and text of the presentation as an outline?

Which of the following are ways you can rotate text in a table cell? Select all the options that apply.

You can divide slides into sections to help organize the slides.

Which of these will you click on the Insert tab in the Text group to insert an equation?

Which of the following describes an object that is created in a source program and is edited in the destination file using the destination program?

How do you select everything on a slide except objects on the slide background?

To move a slide in Outline view, drag the slide icon.

Marco has created a very large slide show covering a variety of topics. He wants to organize the slides in a more useful arrangement. Which of the following is the best solution to his problem?

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Managing Data With Data Tools

Filters