Question 1

When pressing which of these keys will a shape move up in the desired direction?

Accepted Answer

A)  UP ARROW 
B)  RIGHT ARROW 
C)  CTRL + UP ARROW 
D)  CTRL + LEFT ARROW 
A)  UP ARROW 
B)  RIGHT ARROW 
C)  CTRL + UP ARROW 
D)  CTRL + LEFT ARROW

Question 2

If you want to quickly change the colors of a chart on a slide and whether chart elements, such as a legend and data labels appear, which of the following can you do? Select all the options that apply.

Accepted Answer

A)  Change the chart title. 
B)  Apply a chart style. 
C)  Change the chart layout. 
D)  Add more data to the chart. 
A)  Change the chart title. 
B)  Apply a chart style. 
C)  Change the chart layout. 
D)  Add more data to the chart.

Question 3

When you insert a chart on a slide using the Charts button in a content placeholder or the Charts button on the Insert tab, which of the following opens so that you can enter the data for the chart?

Accepted Answer

A)  An Excel worksheet 
B)  A legend 
C)  A hyperlink to an Excel worksheet 
D)  A PowerPoint table 
A)  An Excel worksheet 
B)  A legend 
C)  A hyperlink to an Excel worksheet 
D)  A PowerPoint table

Question 4

If a text box contains many list items, you can format the text box so that the items appear in multiple columns.

Accepted Answer

A) True 
 B)False

Question 5

When you create a text box by clicking the Text Box button on the Insert tab and then drag on the slide, the text does not wrap in the box. Instead, the box gets wider to fit the text you type.

Accepted Answer

A) True 
 B)False

Question 6

Gregg wants to record audio simultaneously while giving a PowerPoint-based presentation. For this, he clicks on X > Record Slide Show > Record From Beginning… What can X in the procedure be?

Accepted Answer

A)  Format tab 
B)  Slide Show tab 
C)  Animations tab 
D)  Transitions tab 
A)  Format tab 
B)  Slide Show tab 
C)  Animations tab 
D)  Transitions tab

Question 7

To quickly change the elements displayed in a chart, you can change the chart layout.

Accepted Answer

A) True 
 B)False

Question 8

One of the slides in Darrell's presentation contains a title text box that is center-aligned horizontally and a table that is positioned so that its left edge is aligned with the left side of the title text box. He thinks the slide would look better if the table was centered horizontally on the slide. Which of the following will accomplish this? Select all the options that apply.

Accepted Answer

A)  Drag the table and make a guess about where to position it. 
B)  Click the Align button on the Drawing Tools Format tab, and then click Align Center. 
C)  Click the Align Text button on the Home tab. 
D)  Drag the table and position it when the Smart Guide appears to indicate that the center of the title text box and the center of the table are aligned. 
A)  Drag the table and make a guess about where to position it. 
B)  Click the Align button on the Drawing Tools Format tab, and then click Align Center. 
C)  Click the Align Text button on the Home tab. 
D)  Drag the table and position it when the Smart Guide appears to indicate that the center of the title text box and the center of the table are aligned.

Question 9

As you enter data in the Excel worksheet that opens when you insert a chart, you can see the chart change on the slide.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following is text in a chart that identifies the numeric value of each data marker?

Accepted Answer

A)  Data bars 
B)  Axis titles 
C)  Data labels 
D)  Legend 
A)  Data bars 
B)  Axis titles 
C)  Data labels 
D)  Legend

Question 11

Which portion of an audio clip will get trimmed if you click its start point under the Trim Audio dialog box and drag the two-headed arrow to a new position on it?

Accepted Answer

A)  Middle 
B)  Beginning 
C)  End 
D)  A desired section 
A)  Middle 
B)  Beginning 
C)  End 
D)  A desired section

Question 12

Choose the correct order you will click to increase the size a SmartArt shape.

Accepted Answer

A)  SmartArt shapes -> Format -> Shapes -> Larger 
B)  SmartArt shapes -> Shapes -> Graphics -> Larger 
C)  SmartArt shapes -> Design -> Shapes -> Larger 
D)  SmartArt shapes -> Shapes -> Reset Shapes -> Larger 
A)  SmartArt shapes -> Format -> Shapes -> Larger 
B)  SmartArt shapes -> Shapes -> Graphics -> Larger 
C)  SmartArt shapes -> Design -> Shapes -> Larger 
D)  SmartArt shapes -> Shapes -> Reset Shapes -> Larger

Question 13

Jia needs to change the order in which objects on a slide in her presentation animate. Which of the following is the best method to do this?

Accepted Answer

A)  After selecting an object with an animation applied to it, she can drag the object before or after the other objects on the slide. 
B)  After selecting an object with an animation applied to it, she can click the Move Earlier or Move Later button on the Animations tab. 
C)  She can change the effect options of each animation. 
D)  She can change the duration of each animation. 
A)  After selecting an object with an animation applied to it, she can drag the object before or after the other objects on the slide. 
B)  After selecting an object with an animation applied to it, she can click the Move Earlier or Move Later button on the Animations tab. 
C)  She can change the effect options of each animation. 
D)  She can change the duration of each animation.

Question 14

If a data label, title, or legend in a chart is difficult to read, you can format them as bold, but you cannot change the font size.

Accepted Answer

A) True 
 B)False

Question 15

If you need to add additional text to a slide and that text is not part of the title or the bulleted list, which of the following is the best choice?

Accepted Answer

A)  Insert SmartArt. 
B)  Insert a chart. 
C)  Insert a text box. 
D)  Insert a table. 
A)  Insert SmartArt. 
B)  Insert a chart. 
C)  Insert a text box. 
D)  Insert a table.

Question 16

In an Excel worksheet, what is the intersection of a row and a column called?

Accepted Answer

A)  Data box 
B)  Graphic 
C)  Text box 
D)  Cell 
A)  Data box 
B)  Graphic 
C)  Text box 
D)  Cell

Question 17

Which of the following is the space between the edge of the text and the edges of a text box or a shape that contains text?

Accepted Answer

A)  Margins 
B)  Leading 
C)  Paragraph spacing 
D)  Line spacing 
A)  Margins 
B)  Leading 
C)  Paragraph spacing 
D)  Line spacing

Question 18

Under which options will you select Hide during Show to hide audio during a slide show?

Accepted Answer

A)  Audio 
B)  Video 
C)  Playback 
D)  Volume 
A)  Audio 
B)  Video 
C)  Playback 
D)  Volume

Question 19

What will the Promote command do to a selected shape?

Accepted Answer

A)  Move it to a higher level. 
B)  Move it to a lower level. 
C)  Move it right. 
D)  Move it left. 
A)  Move it to a higher level. 
B)  Move it to a lower level. 
C)  Move it right. 
D)  Move it left.

Question 20

Which of the following is a series of data points on a line that represents the general direction in a series of data?

Accepted Answer

A)  Data table 
B)  Line chart 
C)  Gridline 
D)  Trendline 
A)  Data table 
B)  Line chart 
C)  Gridline 
D)  Trendline

When pressing which of these keys will a shape move up in the desired direction?

If you want to quickly change the colors of a chart on a slide and whether chart elements, such as a legend and data labels appear, which of the following can you do? Select all the options that apply.

When you insert a chart on a slide using the Charts button in a content placeholder or the Charts button on the Insert tab, which of the following opens so that you can enter the data for the chart?

If a text box contains many list items, you can format the text box so that the items appear in multiple columns.

When you create a text box by clicking the Text Box button on the Insert tab and then drag on the slide, the text does not wrap in the box. Instead, the box gets wider to fit the text you type.

Gregg wants to record audio simultaneously while giving a PowerPoint-based presentation. For this, he clicks on X > Record Slide Show > Record From Beginning… What can X in the procedure be?

To quickly change the elements displayed in a chart, you can change the chart layout.

As you enter data in the Excel worksheet that opens when you insert a chart, you can see the chart change on the slide.

Which of the following is text in a chart that identifies the numeric value of each data marker?

Which portion of an audio clip will get trimmed if you click its start point under the Trim Audio dialog box and drag the two-headed arrow to a new position on it?

Choose the correct order you will click to increase the size a SmartArt shape.

Jia needs to change the order in which objects on a slide in her presentation animate. Which of the following is the best method to do this?

If a data label, title, or legend in a chart is difficult to read, you can format them as bold, but you cannot change the font size.

If you need to add additional text to a slide and that text is not part of the title or the bulleted list, which of the following is the best choice?

In an Excel worksheet, what is the intersection of a row and a column called?

Which of the following is the space between the edge of the text and the edges of a text box or a shape that contains text?

Under which options will you select Hide during Show to hide audio during a slide show?

What will the Promote command do to a selected shape?

Which of the following is a series of data points on a line that represents the general direction in a series of data?

Getting Started With Excel

Formatting Workbook Text and Data

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Filters

Exam 3: Performing Calculations With Formulas and Functions

When pressing which of these keys will a shape move up in the desired direction?

If you want to quickly change the colors of a chart on a slide and whether chart elements, such as a legend and data labels appear, which of the following can you do? Select all the options that apply.

When you insert a chart on a slide using the Charts button in a content placeholder or the Charts button on the Insert tab, which of the following opens so that you can enter the data for the chart?

If a text box contains many list items, you can format the text box so that the items appear in multiple columns.

When you create a text box by clicking the Text Box button on the Insert tab and then drag on the slide, the text does not wrap in the box. Instead, the box gets wider to fit the text you type.

Gregg wants to record audio simultaneously while giving a PowerPoint-based presentation. For this, he clicks on X > Record Slide Show > Record From Beginning… What can X in the procedure be?

To quickly change the elements displayed in a chart, you can change the chart layout.

As you enter data in the Excel worksheet that opens when you insert a chart, you can see the chart change on the slide.

Which of the following is text in a chart that identifies the numeric value of each data marker?

Which portion of an audio clip will get trimmed if you click its start point under the Trim Audio dialog box and drag the two-headed arrow to a new position on it?

Choose the correct order you will click to increase the size a SmartArt shape.

Jia needs to change the order in which objects on a slide in her presentation animate. Which of the following is the best method to do this?

If a data label, title, or legend in a chart is difficult to read, you can format them as bold, but you cannot change the font size.

If you need to add additional text to a slide and that text is not part of the title or the bulleted list, which of the following is the best choice?

In an Excel worksheet, what is the intersection of a row and a column called?

Which of the following is the space between the edge of the text and the edges of a text box or a shape that contains text?

Under which options will you select Hide during Show to hide audio during a slide show?

What will the Promote command do to a selected shape?

Which of the following is a series of data points on a line that represents the general direction in a series of data?

Getting Started With Excel

Formatting Workbook Text and Data

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Filters