Question 1

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

The Switch Row / Column command in Excel allows you to change which data is displayed on the horizontal and vertical axes of a chart. By using this command, Amir can switch the rows and columns of his data source so that the sales reps' names appear on the horizontal axis instead of the months.

Question 2

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

Accepted Answer

Tables and charts are considered shapes in most programs and can be resized using the same methods as other shapes.

Question 3

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

Accepted Answer

The answer of To move a slide in Outline view,...

Question 4

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

Accepted Answer

When you enter a slide title in the Outline pane in Outline view and press ENTER, a new slide is created with the title as the slide title in the slide layout.

Question 5

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

Accepted Answer

You can change the colors of all elements in a chart at once by selecting the entire chart and choosing a new color scheme.

Question 6

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.

Accepted Answer

Options B, C, and D are correct because they describe valid methods for inserting slides from one presentation into another in most presentation software, such as Microsoft PowerPoint. Option B (Reuse Slides command) allows you to insert slides from another presentation or a template directly. Option C (copy and paste slides) is a common method for transferring content between presentations. Option D (dragging slides from one presentation to another in side by side view) is a practical approach when you have both presentations open simultaneously. Option A is incorrect because pasting a file onto a slide does not insert the slides from the file into the presentation.

Question 7

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

Accepted Answer

This is a feature available in most presentation software and can be used to emphasize important points during a presentation.

Question 8

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

Accepted Answer

The Outline view shows the titles and text of the presentation as an outline, making it easy for users to see the structure of their presentation and make any necessary changes. Normal view shows the slide itself with all its content, Slide Sorter view shows all slides in a grid, and Reading view presents the slides in a fullscreen mode optimized for reading onscreen.

Question 9

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?

Accepted Answer

If Fatima thinks a column chart would convey the data more clearly, then she should change the chart type from line chart to column chart. This would make the chart more effective in displaying the data.

Question 10

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

Accepted Answer

The answer of When you link an object to a...

Question 11

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

Accepted Answer

When you edit the source file of a linked object on a slide, the changes are made in both the source file and in the linked object. This is because the linked object is connected to the source file and any changes made in the source file will automatically be reflected in the linked object.

Question 12

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?

Accepted Answer

Double-clicking the embedded object will open the source program for editing.

Question 13

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.

Accepted Answer

By applying the Heading1 style to the paragraphs that you want to be slide titles, you can easily insert the outline in your presentation as PowerPoint will automatically convert them to slide titles.

Question 14

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

Accepted Answer

When you press TAB while the insertion point is in the line below a slide title in the Outline pane, a new bullet point is added to the bulleted list on the slide.

Question 15

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

Accepted Answer

When you embed an object in a presentation or document, it becomes part of the file and does not automatically update if the source file is changed.

Question 16

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?

Accepted Answer

Using the "Slides from Outline" feature will automatically create new slides in the PowerPoint presentation based on the headings and text in the Word document. This is the quickest and most efficient way to transfer the outline to a presentation.

Question 17

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

Accepted Answer

In Outline view, you can navigate from one slide to another using the navigation pane on the left side of the screen.

Question 18

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?

Accepted Answer

The "Distribute Rows" command will adjust the height of all the rows in a selected table so they are the same size without changing the overall height of the table. Option A, "Change Row Height", allows the user to adjust the height of one or more individual rows but would not ensure that they are all the same size. Option B, "Change Cell Size", is focused on adjusting the width and height of individual cells within a table, not the overall row height. Option C, "Distribute Columns", adjusts the width of all columns in a selected table to be the same size.

Question 19

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

Accepted Answer

The best tool to use to color text on a slide with yellow during a slide show is the highlighter. The pen and laser pointer are used for drawing and pointing, respectively, while the wand is used for selecting and manipulating objects.

Question 20

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

Accepted Answer

When you edit an embedded object, the changes are made only within the document that contains the embedded object. The source file remains unchanged because the embedded object is not dynamically linked to the source file; it is a copy of the original content.

Quiz 5: Generating Reports From Multiple Worksheets and Workbooks