Question 1

____ are descriptions which do not regularly appear as part of a worksheet's data.

Accepted Answer

A)  Comments 
B)  Tracked changes 
C)  Custom views 
D)  Themes 
A)  Comments 
B)  Tracked changes 
C)  Custom views 
D)  Themes

Question 2

-A(n) ____________________, as shown in the accompanying figure, indicates a comment.

Accepted Answer

The answer of  
-A(n) ____________________, as shown in the...

Question 3

The ____________________ prefix is a standard prefix for email hyperlinks.

Accepted Answer

The answer of The ____________________ prefix is a standard prefix...

Question 4

Each copy of a workbook to be merged must have a different ____.

Accepted Answer

A)  password 
B)  path 
C)  file name 
D)  number of worksheets 
A)  password 
B)  path 
C)  file name 
D)  number of worksheets

Question 5

After clicking the View Side by Side button, the arrangement of workbooks on your screen depends on how previous Excel windows were arranged.

Accepted Answer

A) True 
 B)False

Question 6

Turning off track changes also turns off sharing and saves the workbook.

Accepted Answer

A) True 
 B)False

Question 7

The ____________________ check box in the Select Changes to Accept or Reject dialog box allows you to specify individual users from whom to review changes.

Accepted Answer

The answer of The ____________________ check box in the Select...

Question 8

____ are used in XML files to describe data items.

Accepted Answer

A)  Tabs 
B)  Tables 
C)  Tags 
D)  Tips 
A)  Tabs 
B)  Tables 
C)  Tags 
D)  Tips

Question 9

Saving on SkyDrive to distribute workbooks by necessity differs from saving on SkyDrive when saving your own files.

Accepted Answer

A) True 
 B)False

Question 10

When Excel recognizes that another user has modified a shared workbook, Excel displays a dialog box indicating that the workbook has been updated with changes saved by other users.

Accepted Answer

A) True 
 B)False

Question 11

You can press ____ to display the Hyperlink dialog box.

Accepted Answer

A)  CTRL+B 
B)  CTRL+H 
C)  CTRL+I 
D)  CTRL+K 
A)  CTRL+B 
B)  CTRL+H 
C)  CTRL+I 
D)  CTRL+K

Question 12

You can click the ____ button in the Custom Views dialog box to delete a custom view.

Accepted Answer

A)  Delete 
B)  Show 
C)  Add 
D)  Remove 
A)  Delete 
B)  Show 
C)  Add 
D)  Remove

Question 13

When you save a workbook in an accessible location on SkyDrive, you need to make a workbook available to others.

Accepted Answer

A) True 
 B)False

Question 14

Excel keeps a change history with each shared workbook.

Accepted Answer

A) True 
 B)False

Question 15

A(n) ____________________ is faded text overlaid on the worksheet, used to convey something about the state of the worksheet, often an indicator of status, such as Draft or Confidential.

Accepted Answer

The answer of A(n) ____________________ is faded text overlaid on...

Question 16

You can add buttons to the Quick Access Toolbar with options in the ____ dialog box.

Accepted Answer

A)  Excel Options 
B)  Add-Ins 
C)  Check for Issues 
D)  Protect Workbook 
A)  Excel Options 
B)  Add-Ins 
C)  Check for Issues 
D)  Protect Workbook

Question 17

Which of the following are options you can click in the Select Changes to Accept or Reject dialog box?

Accepted Answer

A)  When 
B)  How 
C)  Who 
D)  Where 
A)  When 
B)  How 
C)  Who 
D)  Where

Question 18

Case 11-1
You have been invited to present a brief "Tips and Tricks" presentation at the next Excel Users Group meeting. You plan to focus on keyboard shortcuts; however, you realize that most members of the Excel Users Group are familiar with keyboard shortcuts for basic tasks. You decide to focus on keyboard shortcuts for popular advanced Excel features.
-Many members of the group have, in previous meetings, expressed an interest in annotating worksheet cells with comments; therefore, you decide to add to your "Tips and Tricks" presentation an example of inserting a comment using the ____ keyboard shortcut key(s).

Accepted Answer

A)  SHIFT+F2 
B)  F11 
C)  CTRL+~ 
D)  ALT+Z 
A)  SHIFT+F2 
B)  F11 
C)  CTRL+~ 
D)  ALT+Z

Question 19

You can add a new comment by clicking the Insert Comment command on a shortcut menu.

Accepted Answer

A) True 
 B)False

Question 20

The ____ prefix is a standard prefix for email hyperlinks, which Excel adds automatically.

Accepted Answer

A)  sendto: 
B)  forwardto: 
C)  mailto: 
D)  none of the above 
A)  sendto: 
B)  forwardto: 
C)  mailto: 
D)  none of the above

____ are descriptions which do not regularly appear as part of a worksheet's data.

-A(n) ____________________, as shown in the accompanying figure, indicates a comment.

The ____________________ prefix is a standard prefix for email hyperlinks.

Each copy of a workbook to be merged must have a different ____.

After clicking the View Side by Side button, the arrangement of workbooks on your screen depends on how previous Excel windows were arranged.

Turning off track changes also turns off sharing and saves the workbook.

The ____________________ check box in the Select Changes to Accept or Reject dialog box allows you to specify individual users from whom to review changes.

____ are used in XML files to describe data items.

Saving on SkyDrive to distribute workbooks by necessity differs from saving on SkyDrive when saving your own files.

When Excel recognizes that another user has modified a shared workbook, Excel displays a dialog box indicating that the workbook has been updated with changes saved by other users.

You can press ____ to display the Hyperlink dialog box.

You can click the ____ button in the Custom Views dialog box to delete a custom view.

When you save a workbook in an accessible location on SkyDrive, you need to make a workbook available to others.

Excel keeps a change history with each shared workbook.

A(n) ____________________ is faded text overlaid on the worksheet, used to convey something about the state of the worksheet, often an indicator of status, such as Draft or Confidential.

You can add buttons to the Quick Access Toolbar with options in the ____ dialog box.

Which of the following are options you can click in the Select Changes to Accept or Reject dialog box?

You can add a new comment by clicking the Insert Comment command on a shortcut menu.

The ____ prefix is a standard prefix for email hyperlinks, which Excel adds automatically.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Filters

Exam 12: Collaboration Features for Workbooks

____ are descriptions which do not regularly appear as part of a worksheet's data.

-A(n) ____________________, as shown in the accompanying figure, indicates a comment.

The ____________________ prefix is a standard prefix for email hyperlinks.

Each copy of a workbook to be merged must have a different ____.

After clicking the View Side by Side button, the arrangement of workbooks on your screen depends on how previous Excel windows were arranged.

Turning off track changes also turns off sharing and saves the workbook.

The ____________________ check box in the Select Changes to Accept or Reject dialog box allows you to specify individual users from whom to review changes.

____ are used in XML files to describe data items.

Saving on SkyDrive to distribute workbooks by necessity differs from saving on SkyDrive when saving your own files.

When Excel recognizes that another user has modified a shared workbook, Excel displays a dialog box indicating that the workbook has been updated with changes saved by other users.

You can press ____ to display the Hyperlink dialog box.

You can click the ____ button in the Custom Views dialog box to delete a custom view.

When you save a workbook in an accessible location on SkyDrive, you need to make a workbook available to others.

Excel keeps a change history with each shared workbook.

A(n) ____________________ is faded text overlaid on the worksheet, used to convey something about the state of the worksheet, often an indicator of status, such as Draft or Confidential.

You can add buttons to the Quick Access Toolbar with options in the ____ dialog box.

Which of the following are options you can click in the Select Changes to Accept or Reject dialog box?

You can add a new comment by clicking the Insert Comment command on a shortcut menu.

The ____ prefix is a standard prefix for email hyperlinks, which Excel adds automatically.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Filters