Question 1

You cannot move or resize an object that has been copied from Excel and pasted into PowerPoint as a link.

Accepted Answer

A) True 
 B)False

Question 2

In the accompanying figure, the drop-down list is a list of choices for ordering a(n) ____ operation.

Accepted Answer

A)  searching 
B)  insertion 
C)  extraction 
D)  sorting 
A)  searching 
B)  insertion 
C)  extraction 
D)  sorting

Question 3

With Auto Fill, dragging the fill handle on a cell copies the cell's contents or continues a series of data into adjacent cells.

Accepted Answer

A) True 
 B)False

Question 4

Microsoft Office provides ____ integration methods.

Accepted Answer

A)  three 
B)  four 
C)  five 
D)  six 
A)  three 
B)  four 
C)  five 
D)  six

Question 5

To show how individual volume changes over time in relation to total volume, use a(n) ____.

Accepted Answer

A)  area chart 
B)  bar chart 
C)  column chart 
D)  line chart 
A)  area chart 
B)  bar chart 
C)  column chart 
D)  line chart

Question 6

Both options that allow linking in the Paste Options insert a(n) ____.

Accepted Answer

A)  object break 
B)  image break 
C)  line break 
D)  type break 
A)  object break 
B)  image break 
C)  line break 
D)  type break

Question 7

In the ____ window you can search for online pictures (or Clip Art) in Office.com, through the Bing search engine, or on your SkyDrive.

Accepted Answer

A)  Find Images 
B)  Insert Pictures 
C)  Add Clip Art 
D)  Add Images 
A)  Find Images 
B)  Insert Pictures 
C)  Add Clip Art 
D)  Add Images

Question 8

A(n) ____ identifies each data series in a chart, generally with a different color.

Accepted Answer

A)  axis 
B)  data point 
C)  data marker 
D)  legend 
A)  axis 
B)  data point 
C)  data marker 
D)  legend

Question 9

In the accompanying figure, use the Paste Options button labeled ____ if you want the pasted chart not to be linked to the source document but you want the pasted chart to assume the formatting of the destination document.

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 10

Discuss the use of an Excel template to create a workbook.

Accepted Answer

Excel templates are predesigned workbook

Question 11

In the accompanying figure, use the Paste Options button labeled ____  if you want a pasted chart to be linked to the source document but you do not want the pasted chart to take the formatting from the destination document.

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 12

As shown in the accompanying figure, item 5 points to the chart ____________________.

Accepted Answer

The answer of   As shown in the accompanying...

Question 13

You can add words to the dictionary of the spelling checker.

Accepted Answer

A) True 
 B)False

Question 14

An example of a(n) ____ chart is a column chart with a line chart.

Accepted Answer

A)  nested 
B)  combination 
C)  complex 
D)  exploded 
A)  nested 
B)  combination 
C)  complex 
D)  exploded

Question 15

In a pie chart, slices that are pulled away are said to be ____.

Accepted Answer

A)  identified 
B)  exploded 
C)  opened 
D)  extracted 
A)  identified 
B)  exploded 
C)  opened 
D)  extracted

Question 16

Critical Thinking Questions 
Case 1-1 
You are the manager of the Sales department for a local clothing store that has three locations. You have prepared a worksheet containing data about the sales figures for the company, which also has a chart to illustrate of the data. 
You want to use a shape style to change the look of your chart, but first you want see a Live Preview of how it will look. What do you do with the pointer to see a Live Preview? 
a. Hover the pointer over the shape style. 
b. Double-click the shape style. 
c. Right-click the shape style. 
d. Triple-click the shape style.

Accepted Answer

The answer of Critical Thinking Questions 
Case 1-1 
You are...

Question 17

In the accompanying figure, item ____ represents the horizontal axis.

Accepted Answer

A)  2 
B)  3 
C)  4 
D)  5 
A)  2 
B)  3 
C)  4 
D)  5

Question 18

The Find & Select button is found in the Editing group on the ____ tab on the Ribbon.

Accepted Answer

A)  HOME 
B)  PAGE LAYOUT 
C)  REVIEW 
D)  DATA 
A)  HOME 
B)  PAGE LAYOUT 
C)  REVIEW 
D)  DATA

Question 19

By default, when you copy an Excel report into Word, it will be formatted with the same theme applied to the source document. _________________________

Accepted Answer

A) True 
 B)False

Question 20

Charts are updated automatically in Excel whenever data changes.

Accepted Answer

A) True 
 B)False

You cannot move or resize an object that has been copied from Excel and pasted into PowerPoint as a link.

In the accompanying figure, the drop-down list is a list of choices for ordering a(n) ____ operation.

With Auto Fill, dragging the fill handle on a cell copies the cell's contents or continues a series of data into adjacent cells.

Microsoft Office provides ____ integration methods.

To show how individual volume changes over time in relation to total volume, use a(n) ____.

Both options that allow linking in the Paste Options insert a(n) ____.

In the ____ window you can search for online pictures (or Clip Art) in Office.com, through the Bing search engine, or on your SkyDrive.

A(n) ____ identifies each data series in a chart, generally with a different color.

In the accompanying figure, use the Paste Options button labeled ____ if you want the pasted chart not to be linked to the source document but you want the pasted chart to assume the formatting of the destination document.

Discuss the use of an Excel template to create a workbook.

In the accompanying figure, use the Paste Options button labeled ____ if you want a pasted chart to be linked to the source document but you do not want the pasted chart to take the formatting from the destination document.

As shown in the accompanying figure, item 5 points to the chart ____________________.

You can add words to the dictionary of the spelling checker.

An example of a(n) ____ chart is a column chart with a line chart.

In a pie chart, slices that are pulled away are said to be ____.

In the accompanying figure, item ____ represents the horizontal axis.

The Find & Select button is found in the Editing group on the ____ tab on the Ribbon.

By default, when you copy an Excel report into Word, it will be formatted with the same theme applied to the source document. _________________________

Charts are updated automatically in Excel whenever data changes.

Computer and Internet Basics

Computer Hardware

Computer Software

File Management and Digital Electronics

Windows 8 Getting Started With Windows 8

Word 2013 Creating Documents With Word 2013

Access 2013 Getting Started With Access 2013

Appendix Working in the Cloud

Internet Explorer 10 Getting Started With Internet Explorer 10

Office 2013 Getting Started With Microsoft Office 2013

Filters

Exam 11: Excel 2013 Getting Started With Excel 2013

You cannot move or resize an object that has been copied from Excel and pasted into PowerPoint as a link.

In the accompanying figure, the drop-down list is a list of choices for ordering a(n) ____ operation.

With Auto Fill, dragging the fill handle on a cell copies the cell's contents or continues a series of data into adjacent cells.

Microsoft Office provides ____ integration methods.

To show how individual volume changes over time in relation to total volume, use a(n) ____.

Both options that allow linking in the Paste Options insert a(n) ____.

In the ____ window you can search for online pictures (or Clip Art) in Office.com, through the Bing search engine, or on your SkyDrive.

A(n) ____ identifies each data series in a chart, generally with a different color.

In the accompanying figure, use the Paste Options button labeled ____ if you want the pasted chart not to be linked to the source document but you want the pasted chart to assume the formatting of the destination document.

Discuss the use of an Excel template to create a workbook.

In the accompanying figure, use the Paste Options button labeled ____ if you want a pasted chart to be linked to the source document but you do not want the pasted chart to take the formatting from the destination document.

As shown in the accompanying figure, item 5 points to the chart ____________________.

You can add words to the dictionary of the spelling checker.

An example of a(n) ____ chart is a column chart with a line chart.

In a pie chart, slices that are pulled away are said to be ____.

In the accompanying figure, item ____ represents the horizontal axis.

The Find & Select button is found in the Editing group on the ____ tab on the Ribbon.

By default, when you copy an Excel report into Word, it will be formatted with the same theme applied to the source document. _________________________

Charts are updated automatically in Excel whenever data changes.

Computer and Internet Basics

Computer Hardware

Computer Software

File Management and Digital Electronics

Windows 8 Getting Started With Windows 8

Word 2013 Creating Documents With Word 2013

Access 2013 Getting Started With Access 2013

Appendix Working in the Cloud

Internet Explorer 10 Getting Started With Internet Explorer 10

Office 2013 Getting Started With Microsoft Office 2013

Filters