Question 1

With Excel, you can adjust the width of one or more columns by using the mouse.

Accepted Answer

A) True 
 B)False

Question 2

You can export a Word outline into PowerPoint to automatically create slides without having to reenter information. _________________________

Accepted Answer

A) True 
 B)False

Question 3

Discuss the difference between a relative cell reference and an absolute cell reference. Include the following information in your answer: how the two types of cell addresses are designated, what happens when each type of cell reference is copied, and when it is appropriate to use each type of reference.

Accepted Answer

A relative cell reference is used when t

Question 4

What is meant by the format of a cell?

Accepted Answer

The format of a cell determines how the

Question 5

All functions begin with the formula prefix ____.

Accepted Answer

A)  @ (at symbol) 
B)  = (equals sign) 
C)  # (number symbol) 
D)  + (plus sign) 
A)  @ (at symbol) 
B)  = (equals sign) 
C)  # (number symbol) 
D)  + (plus sign)

Question 6

Dragging a chart object to a new location on the worksheet will change the data in the worksheet.

Accepted Answer

A) True 
 B)False

Question 7

A chart sheet is a sheet in a workbook that contains only a chart, which is linked to the workbook data.

Accepted Answer

A) True 
 B)False

Question 8

When you use the Copy and Paste commands, by default an object copied from one program to another program retains the ____ of the original object.

Accepted Answer

A)  address 
B)  formatting 
C)  record 
D)  link to the source 
A)  address 
B)  formatting 
C)  record 
D)  link to the source

Question 9

PowerPoint imports all text formatted with the Heading 2 style as a level 1 item in a(n) ____________________ list.

Accepted Answer

The answer of PowerPoint imports all text formatted with the...

Question 10

Explain the use of the fill handle to fill cells with sequential information.

Accepted Answer

Often, you need to fill cells with seque

Question 11

The ____________________ number format adds dollar signs and two decimal places to the data.

Accepted Answer

The answer of The ____________________ number format adds dollar signs...

Question 12

As shown in the accompanying figure, item 1 points to the ____.

Accepted Answer

A)  insertion point 
B)  mode indicator 
C)  Enter button 
D)  active cell 
A)  insertion point 
B)  mode indicator 
C)  Enter button 
D)  active cell

Question 13

An embedded object becomes a part of the PowerPoint file, which means that the file size of the PowerPoint presentation decreases . _________________________

Accepted Answer

A) True 
 B)False

Question 14

Which keyboard shortcut turns on Edit mode?

Accepted Answer

A)  [F1] 
B)  [F2] 
C)  [F4] 
D)  [F8] 
A)  [F1] 
B)  [F2] 
C)  [F4] 
D)  [F8]

Question 15

You can use source program tools to edit a(n) ____ object within a destination file.

Accepted Answer

A)  dynamic 
B)  embedded 
C)  static 
D)  de-referenced 
A)  dynamic 
B)  embedded 
C)  static 
D)  de-referenced

Question 16

Excel recognizes an entry as a value if it is a number or it begins with ____.

Accepted Answer

A)  + 
B)  = 
C)  $ 
D)  All of the above. 
A)  + 
B)  = 
C)  $ 
D)  All of the above.

Question 17

You can change the ____ of labels and values in cells to be left, right, or center.

Accepted Answer

A)  font 
B)  font size 
C)  cell style 
D)  alignment 
A)  font 
B)  font size 
C)  cell style 
D)  alignment

Question 18

When a Word object is ____ in Excel, the Word Ribbon and tabs appear within the Excel window.

Accepted Answer

A)  embedded 
B)  copied 
C)  linked 
D)  pasted 
A)  embedded 
B)  copied 
C)  linked 
D)  pasted

Question 19

A(n) ____ is a built-in formula that uses arguments to calculate information.

Accepted Answer

A)  label 
B)  function 
C)  template 
D)  indicator 
A)  label 
B)  function 
C)  template 
D)  indicator

Question 20

You can use a named range instead of a cell address in a formula.

Accepted Answer

A) True 
 B)False

With Excel, you can adjust the width of one or more columns by using the mouse.

You can export a Word outline into PowerPoint to automatically create slides without having to reenter information. _________________________

What is meant by the format of a cell?

All functions begin with the formula prefix ____.

Dragging a chart object to a new location on the worksheet will change the data in the worksheet.

A chart sheet is a sheet in a workbook that contains only a chart, which is linked to the workbook data.

When you use the Copy and Paste commands, by default an object copied from one program to another program retains the ____ of the original object.

PowerPoint imports all text formatted with the Heading 2 style as a level 1 item in a(n) ____________________ list.

Explain the use of the fill handle to fill cells with sequential information.

The ____________________ number format adds dollar signs and two decimal places to the data.

As shown in the accompanying figure, item 1 points to the ____.

An embedded object becomes a part of the PowerPoint file, which means that the file size of the PowerPoint presentation decreases . _________________________

Which keyboard shortcut turns on Edit mode?

You can use source program tools to edit a(n) ____ object within a destination file.

Excel recognizes an entry as a value if it is a number or it begins with ____.

You can change the ____ of labels and values in cells to be left, right, or center.

When a Word object is ____ in Excel, the Word Ribbon and tabs appear within the Excel window.

A(n) ____ is a built-in formula that uses arguments to calculate information.

You can use a named range instead of a cell address in a formula.

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

With Excel, you can adjust the width of one or more columns by using the mouse.

You can export a Word outline into PowerPoint to automatically create slides without having to reenter information. _________________________

What is meant by the format of a cell?

All functions begin with the formula prefix ____.

Dragging a chart object to a new location on the worksheet will change the data in the worksheet.

A chart sheet is a sheet in a workbook that contains only a chart, which is linked to the workbook data.

When you use the Copy and Paste commands, by default an object copied from one program to another program retains the ____ of the original object.

PowerPoint imports all text formatted with the Heading 2 style as a level 1 item in a(n) ____________________ list.

Explain the use of the fill handle to fill cells with sequential information.

The ____________________ number format adds dollar signs and two decimal places to the data.

As shown in the accompanying figure, item 1 points to the ____.

An embedded object becomes a part of the PowerPoint file, which means that the file size of the PowerPoint presentation decreases . _________________________

Which keyboard shortcut turns on Edit mode?

You can use source program tools to edit a(n) ____ object within a destination file.

Excel recognizes an entry as a value if it is a number or it begins with ____.

You can change the ____ of labels and values in cells to be left, right, or center.

When a Word object is ____ in Excel, the Word Ribbon and tabs appear within the Excel window.

A(n) ____ is a built-in formula that uses arguments to calculate information.

You can use a named range instead of a cell address in a formula.

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