Deck 5: Generating Reports From Multiple Worksheets and Workbooks

Question 1

Suppose a slide contains three ovals and you want to evenly space the ovals horizontally across the slide. After you select the three ovals, which command would you use to accomplish this?

A) Align and Distribute
B) Align Horizontally
C) Arrange Horizontally
D) Distribute Horizontally

Answer 1

D

Question 2

A slide contains two objects with animations applied. The first object animates when you advance the slide show. The second object animates automatically after the animation of the first object finishes. If you want the animation of the second object to start five seconds after the animation of the first object finishes, which of the following actions should you take?

A) Change the duration of the animation applied to the second object to five seconds.
B) Add a delay of five seconds to the animation applied to the second object.
C) Change how the first animation starts.
D) Change the direction of the animation applied to the second object.

Answer 2

B

Question 3

A slide in Gianna's presentation contains a bulleted list. She applied an entrance animation to the list. As each bulleted item appears, she wants the previous item to change to a lighter color. How can she do this?

A) Open the Effect Options dialog box for the selected animation, click the After animation arrow, and then select a color.
B) Open the Effect Options dialog box for the selected animation, and then select the Dim Text option.
C) On the Animations tab, click the Dim Text button in the Advanced Animation group.
D) Click the Recolor After button on the Animations tab.

Answer 3

A

Question 4

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

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

Question 5

Which of the following actions helps to identify the slides in a section?

A) Rename the sections.
B) Reorder the sections.
C) Add comments.
D) Expand the sections.

Question 6

In PowerPoint, what can you do with sections after you create them? Select all the options that apply.

A) Use them to create new databases.
B) Give them unique names.
C) Move slides into them.
D) Perform a mail merge.

Question 7

If you animate a list on a slide, which of the following is the default way is the first-level items appear?

A) One at a time
B) Two at a time
C) All at once
D) One word at a time

Question 8

Which of the following commands found on the Align menu evenly space objects horizontally or vertically relative to each other or the slide?

A) Distribute
B) Arrange
C) Space
D) Align

Question 9

If one of your slides contains multiple objects that are placed on top of each other, which of the following commands can you use to move the objects through the layers on the slide? Select all the options that apply.

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

Question 10

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?

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.

Question 11

When you use the Reuse Slides pane, you can insert slides from another presentation or from a SharePoint server. Which of the following is the name for the slides stored on a SharePoint server?

A) Slide gallery
B) Slide deck
C) Slide index
D) Slide library

Question 12

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

Question 13

During a slide show, all of the items in a bulleted list appear on the slide at the same time with the entrance animation effect Fly In applied. If you want each item in the list to appear one at a time, which effect option should you choose?

A) All at Once
B) As One Object
C) From Bottom
D) By Paragraph

Question 14

Deepak's presentation contains 10 sections. He wants to view only the slides in 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.

Question 15

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

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 16

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

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

Question 17

Ben wants to create a section where Slide 10 is the first slide in that section. Which slide thumbnail should he select before using the Add Section command?

A) Slide 9 (the slide before the new section starts)
B) Slide 10 (the slide that will start the new section)
C) Slide 11 (the slide after the new section starts)
D) Slides 9, 10, and 11

Question 18

You can add sounds to animations.

Question 19

When a section is collapsed, a number appears after the section name. What does this number indicate?

A) The slide number of the first slide in the section
B) The number of slides in the section
C) The slide number of the last slide in the section
D) The total time the presentation takes

Question 20

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?

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

Question 21

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?

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

Question 22

You can resize a table or chart the same way you resize a shape.

Question 23

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

Question 24

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

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 25

If you want to change the colors in a chart, you must change the color of each element one at a time.

Question 26

If you want to insert slides from another presentation into a new presentation that you are creating, which of the following methods can you use? Select all the options that apply.

A) Copy the other file from a File Explorer window, and then paste the file on a slide in the new presentation.
B) Use the Reuse Slides command.
C) Open the presentation containing the slides you want to insert, copy the slides you want to use, and then paste them into the new presentation.
D) Open both presentations in Normal or Slide Sorter view and arrange them in side by side windows. In the existing presentation, select the thumbnails of the slides you want to use, then drag them to the new presentation.

Question 27

You can highlight text and objects on the screen during a slide show using the mouse pointer as a highlighter.

Question 28

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

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

Question 29

One of the slides in Fatima's presentation contains a line chart. Fatima thinks a column chart would convey the data more clearly. Which of the following actions should she take?

A) Change the chart type.
B) Change the chart layout.
C) Format the vertical axis on the chart.
D) Switch the chart rows and columns.

Question 30

When you link an object to a slide, the object maintains a connection to the source file and program.

Question 31

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

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.

Question 32

When an object, such as a Word table or an Excel worksheet is embedded on a slide, how do you open the source program to edit it?

A) Right-click the embedded object, and then click Edit on the shortcut menu.
B) Right-click the embedded object, click the file name of the embedded object on the shortcut menu, and then click Open.
C) Double-click the embedded object.
D) Click the object to select it, and then click Edit on the Data tab.

Question 33

If you typed the outline of a presentation in a Word document and applied the Word Heading1 style to the paragraphs that you want to be slide titles, you can insert the outline in your presentation.

Question 34

If the insertion point is in the line below a slide title in the Outline pane, what happens when you press TAB?

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 35

When you change the source file of an embedded object, the change also appears in the embedded object on the slide.

Question 36

Jonathan's colleague gave him an outline in a Word document. The outline is formatted with Word Heading styles. Jonathan needs to add the outline text to his presentation. Which of the following is the best way for him to do this?

A) Click the New Slide arrow on the Home tab, and then click Slides from Outline.
B) Open the Word document and the PowerPoint presentation and arrange the windows side by side. Then copy the text for each slide title and for each bulleted list to new slides that he creates.
C) Open the Word document and the PowerPoint presentation and arrange the windows side by side. Then create a new slide, type the title and the bulleted list on the slide using the Word document as a source, and repeat this for each new slide.
D) Click the Object command on the Insert tab.

Question 37

You can navigate from one slide to another in Outline view, just as you can in Normal view.

Question 38

Which of the following commands will change the height of all of the rows in a selected table so that they are the same size while maintaining the height of the table?

A) Change Row Height
B) Change Cell Size
C) Distribute Columns
D) Distribute Rows

Question 39

If you want to color text on a slide with yellow during a slide show, what tool do you use?

A) Pen
B) Highlighter
C) Laser Pointer
D) Wand

Question 40

When you edit an embedded object, what happens to the source file?

A) Nothing because the embedded object is not linked to the source file, only to the source program.
B) The changes are made in both the embedded object and in the source file.
C) The changes are made in the embedded object, and then the source file automatically opens so you can make the changes there as well.
D) Nothing for now, but the next time you open the source file, you will be asked if you want to update it.

Question 41

To change the orientation of slides in a presentation, you can choose Design > Slide Size > Custom Slide Size.

Question 42

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

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.

Question 43

To change the slide orientation, click Design tab > Slide Size > Custom Slide Size > Slide Size dialog box > Select options under Orientation > Select options under Notes, Handouts & Outline > OK.

Question 44

Issa wants to create handouts by exporting to Word. For this, she clicks on Export > Create Handouts pane > Create Handouts button > Send to Microsoft Word > X > Add slides to Microsoft Word document > Paste > OK. Which of the following should Step X be in this procedure?

A) Add Header
B) Add Footer
C) Change File Type
D) Select a Page Layout

Question 45

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?

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

Question 46

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?

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

Question 47

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

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

Question 48

Which of the following are ways that you can format a table border? Select all the options that apply.

A) Change the color.
B) Change the style.
C) Change the weight.
D) Change the height.

Question 49

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

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

Question 50

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

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.

Question 51

How do you combine table cells?

A) Copy them.
B) Split them.
C) Merge them.
D) Link them.

Question 52

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.

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 53

Which of the following is a connection between a source file and a destination file so that changes made to the object in the source file also appear in the object in the destination file?

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

Question 54

You can change the direction of text in a shape.

Question 55

Which of the following are methods for changing the width of a column in a table on a slide? Select all the options that apply.

A) Click in the Table Column Width box on the Table Tools Layout tab, and then type the new column width in inches.
B) Click the first cell in a column, type the new column width in inches, and then press ENTER.
C) Drag the column divider line to the right of the column you want to resize.
D) Double-click the column divider line to the right of the column you want to resize.