Question 1

In the Publish as section of the Publish as Web Page dialog box you can enable automatic ____________________ of the Web page every time a change is saved to the workbook.

Accepted Answer

The answer of In the Publish as section of the...

Question 2

Match between columns
                        Premises: Indicates that a link has to be updated manually by the user

Accepted Answer

The Answer of 3-D and M and template and ScreenTip is...

Question 3

Match between columns
                        Premises: Type of cell reference that refers to the same cell or range of cells on multiple worksheets in the same workbook

Accepted Answer

The Answer of link and A and source and template is...

Question 4

Match between columns
                        Premises: Saves information about currently opened workbooks

Accepted Answer

The Answer of workspace and source and template and link is...

Question 5

When creating and saving a custom template you may find it helpful to replace variable data values with ____________________ which will help you recognize the cells in which to enter new data.

Accepted Answer

The answer of When creating and saving a custom template...

Question 6

Match between columns
                        Premises: A connection between two files allowing information to be transferred from one file to the other

Accepted Answer

The Answer of destination and template and M and A is...

Question 7

Match between columns
                        Premises: Contains the information when two files are linked

Accepted Answer

The Answer of HTML and M and template and ScreenTip is...

Question 8

Match between columns
                        Premises: Contains text formats and formulas already built into it for your use

Accepted Answer

The Answer of MHTML and destination and A and hyperlink is...

Question 9

Match between columns
                        Premises: Receives the information when two files are linked

Accepted Answer

The Answer of link and template and workspace and A is...

Question 10

When you start Excel and see the blank workbook called Book1 you are actually using the ____________________ template.

Accepted Answer

The answer of When you start Excel and see the...

Question 11

Match between columns
                        Premises: Indicates a link that is updated automatically

Accepted Answer

The Answer of destination and hyperlink and ScreenTip and template is...

Question 12

Match between columns
                        Premises: A language used to write Web pages

Accepted Answer

The Answer of HTML and MHTML and source and template is...

Question 13

To use a template that you create the template file is typically placed in the ____________________ folder.

Accepted Answer

The answer of To use a template that you create...

Question 14

Match between columns
                        Premises: Appears when you place the pointer over a hyperlink

Accepted Answer

The Answer of 3-D and link and destination and MHTML is...

Question 15

Match between columns
                        Premises: Usually represented by colored words with underlines or images

Accepted Answer

The Answer of HTML and link and MHTML and source is...

Question 16

When you save a worksheet as a Web page it is converted to ____________________ a language used to write Web pages.

Accepted Answer

The answer of When you save a worksheet as a...

Question 17

Match between columns
                        Premises: File format in which the Single File Web Page format saves all the Web page elements

Accepted Answer

The Answer of 3-D and ScreenTip and source and A is...

Quiz 6: Excel: Managing Multiple Worksheets and Workbooks

In the Publish as section of the Publish as Web Page dialog box you can enable automatic ____________________ of the Web page every time a change is saved to the workbook.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

When creating and saving a custom template you may find it helpful to replace variable data values with ____________________ which will help you recognize the cells in which to enter new data.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

When you start Excel and see the blank workbook called Book1 you are actually using the ____________________ template.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

To use a template that you create the template file is typically placed in the ____________________ folder.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

When you save a worksheet as a Web page it is converted to ____________________ a language used to write Web pages.

Identify the letter of the choice that best matches the phrase or definition.