Question 1

With which of the following can you fill a table cell? Select all the options that apply.

Accepted Answer

A)  Color 
B)  Picture 
A)  Color 
B)  Picture A

Question 2

Which of the following commands lets you add color to table cells?

Accepted Answer

A)  Shadow 
B)  Bevel 
C)  Shading 
D)  Glow 
A)  Shadow 
B)  Bevel 
C)  Shading 
D)  Glow C

Question 3

Which of the following statements about linked objects is not true?

Accepted Answer

A)  If a presentation contains a linked object,the presentation must be open in order to change the linked object. 
B)  If you want to edit a linked object,you need access to the source file. 
C)  If you want to edit a linked object,you need access to the source program. 
D)  You can open a linked object in its source file from within the PowerPoint presentation. 
A)  If a presentation contains a linked object,the presentation must be open in order to change the linked object. 
B)  If you want to edit a linked object,you need access to the source file. 
C)  If you want to edit a linked object,you need access to the source program. 
D)  You can open a linked object in its source file from within the PowerPoint presentation. A

Question 4

If you want to describe the values on the vertical axis,which of the following should you add?

Accepted Answer

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

Question 5

Which of the following alignment options places text,so it is next to the top edge of a table cell?

Accepted Answer

A)  Align Top 
B)  Align Bottom 
C)  Centered 
D)  Centered Vertically 
A)  Align Top 
B)  Align Bottom 
C)  Centered 
D)  Centered Vertically

Question 6

Abby wants the values of each data marker to appear on her chart.What should she add to the chart?

Accepted Answer

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

Question 7

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 8

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?

Accepted Answer

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

Question 9

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 10

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 11

In a pie chart,what is the box that identifies each slice of the pie chart by listing the category names next to the colors of each pie slice?

Accepted Answer

A)  Legend 
B)  Data series 
C)  Data labels 
D)  Data table 
A)  Legend 
B)  Data series 
C)  Data labels 
D)  Data table

Question 12

Which of the following alignment options places text,so the last character is next to the right edge of a table cell?

Accepted Answer

A)  Align Text Left 
B)  Align Text Right 
C)  Centered 
D)  Center Vertically 
A)  Align Text Left 
B)  Align Text Right 
C)  Centered 
D)  Center Vertically

Question 13

Which of the following alignment options places text,so it is the same distance from the top and bottom edges in a table cell?

Accepted Answer

A)  Align Top 
B)  Align Bottom 
C)  Centered 
D)  Centered Vertically 
A)  Align Top 
B)  Align Bottom 
C)  Centered 
D)  Centered Vertically

Question 14

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

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. 
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 15

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

Accepted Answer

A) True 
 B)False

Question 16

One way to draw attention to a data point or category in a pie chart is to explode the slice corresponding to that data point or category.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following alignment options places text,so the first character is next to the left edge of a table cell?

Accepted Answer

A)  Align Text Left 
B)  Align Text Right 
C)  Centered 
D)  Center Vertically 
A)  Align Text Left 
B)  Align Text Right 
C)  Centered 
D)  Center Vertically

Question 18

Although you can resize a row in a table,you might not need to because rows automatically resize to fit the font size of the text in them.

Accepted Answer

A) True 
 B)False

Question 19

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 20

Mia wants the cells in a table on a slide in her presentation to have a 3D effect.Which effect should she apply?

Accepted Answer

A)  Bevel 
B)  Reflection 
C)  Shadow 
D)  Border 
A)  Bevel 
B)  Reflection 
C)  Shadow 
D)  Border

With which of the following can you fill a table cell? Select all the options that apply.

Which of the following commands lets you add color to table cells?

Which of the following statements about linked objects is not true?

If you want to describe the values on the vertical axis,which of the following should you add?

Which of the following alignment options places text,so it is next to the top edge of a table cell?

Abby wants the values of each data marker to appear on her chart.What should she add to the chart?

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

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?

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?

In a pie chart,what is the box that identifies each slice of the pie chart by listing the category names next to the colors of each pie slice?

Which of the following alignment options places text,so the last character is next to the right edge of a table cell?

Which of the following alignment options places text,so it is the same distance from the top and bottom edges in a table cell?

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?

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

One way to draw attention to a data point or category in a pie chart is to explode the slice corresponding to that data point or category.

Which of the following alignment options places text,so the first character is next to the left edge of a table cell?

Although you can resize a row in a table,you might not need to because rows automatically resize to fit the font size of the text in them.

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

Mia wants the cells in a table on a slide in her presentation to have a 3D effect.Which effect should she apply?

Creating a Worksheet and a Chart.

Formulas, Functions, and Formatting.

Working with Large Worksheets, Charting, and What-If Analysis.

Financial Functions, Data Tables, and Amortization Schedules.

Working with Multiple Worksheets and Workbooks.

Creating Templates, Importing Data, and Working with SmartArt, Images, and Screenshots.

Working with Trendlines, Pivot Table Reports, PivotChart Reports, and Slicers.

Filters

Exam 6: Creating, Sorting, and Querying a Table.

With which of the following can you fill a table cell? Select all the options that apply.

Which of the following commands lets you add color to table cells?

Which of the following statements about linked objects is not true?

If you want to describe the values on the vertical axis,which of the following should you add?

Which of the following alignment options places text,so it is next to the top edge of a table cell?

Abby wants the values of each data marker to appear on her chart.What should she add to the chart?

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

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?

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?

In a pie chart,what is the box that identifies each slice of the pie chart by listing the category names next to the colors of each pie slice?

Which of the following alignment options places text,so the last character is next to the right edge of a table cell?

Which of the following alignment options places text,so it is the same distance from the top and bottom edges in a table cell?

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?

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

One way to draw attention to a data point or category in a pie chart is to explode the slice corresponding to that data point or category.

Which of the following alignment options places text,so the first character is next to the left edge of a table cell?

Although you can resize a row in a table,you might not need to because rows automatically resize to fit the font size of the text in them.

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

Mia wants the cells in a table on a slide in her presentation to have a 3D effect.Which effect should she apply?

Creating a Worksheet and a Chart.

Formulas, Functions, and Formatting.

Working with Large Worksheets, Charting, and What-If Analysis.

Financial Functions, Data Tables, and Amortization Schedules.

Working with Multiple Worksheets and Workbooks.

Creating Templates, Importing Data, and Working with SmartArt, Images, and Screenshots.

Working with Trendlines, Pivot Table Reports, PivotChart Reports, and Slicers.

Filters