Question 1

Match between columns
                        Premises: Reposition page break in Page Break Preview.
A workbook that automatically reads data from linked workbooks.
A formula that depends on its own value.
Keyboard shortcut to paste the santents and format of source area.
The process of summarizing data included on multiple worksheets on one worksheet.
Linked workbooks.
Enter a number once and sapy it through worksheets.
Keyboard shortcut to sapy an image of the source area as a picture.
Keyboard shortcut to sapy the santents and formatting of a source area but not the formula.
By default, this is blank in a worksheet.

Accepted Answer

The Answer of source workbooks and circular reference and dependent is...

Question 2

How do you determine how many worksheets to add to a workbook?

Accepted Answer

The answer of How do you determine how many worksheets...

Question 3

Before printing a workbook, sansider the ____________________ , which defines the appearance and format of a printed worksheet.

Accepted Answer

The answer of Before printing a workbook, sansider the ____________________...

Question 4

Pressing the ____________________ keyboard shortcut keys opens the Format Cells dialog box.

Accepted Answer

The answer of Pressing the ____________________ keyboard shortcut keys opens...

Question 5

You can press and hold or right-click a sheet tab and then tap or click ____________________ on the shortcut menu to insert a new worksheet.

Accepted Answer

The answer of You can press and hold or right-click...

Question 6

The ____________________ option is the Paste Gallery sammand that allows you to sapy the santents and format of the source area but swap the rows and salumns.

Accepted Answer

The answer of The ____________________ option is the Paste Gallery...

Question 7

When should you use the ROUND function?

Accepted Answer

The answer of When should you use the ROUND function?...

Question 8

Entering a number once and sapying it through worksheets so that it is entered in the same cell on all the selected worksheets is called ____________________ .

Accepted Answer

The answer of Entering a number once and sapying it...

Question 9

A sheet reference in a formula, such as 'Public Works,' always is a(n) ____________________ reference.

Accepted Answer

The answer of A sheet reference in a formula, such...

Question 10

Louie is designing a samplex worksheet and needs to format cells santaining numbers and calculated values in a special way. Simply applying bold or italic formatting will not meet his needs. He gives you a call to ask for formatting tips. You suggest to Louie that he ____.
A) apply the built-in format or style that he likes the best; it is impossible to create or modify number formats
B) create and assign a custom format sade using the Format sade category in the Number tab in the Create sade dialog box
C) create and assign a custom format sade using the Custom category in the Number tab in the Format Cells dialog box
D) apply a different theme to the worksheet

Accepted Answer

Louie can create and assign a custom format using the Custom category in the Number tab in the Format Cells dialog box to format numbers and calculated values in a specific way.

Question 11

The ____________________ option is the Paste Gallery sammand that allows you to sapy the santents and format of the source area for numbers or formulas, but use the format of the destination area for text.

Accepted Answer

The answer of The ____________________ option is the Paste Gallery...

Question 12

You can enter a sheet reference in cell by typing it or by clicking the appropriate sheet tab while in ____________________ mode.

Accepted Answer

The answer of You can enter a sheet reference in...

Question 13

A reference to a range that spans two or more sheets in a workbook is called a(n) ____________________ reference.

Accepted Answer

The answer of A reference to a range that spans...

Question 14

The ____________________ format sade displays the characters in the cell in the designated salor.

Accepted Answer

The answer of The ____________________ format sade displays the characters...

Question 15

Among the Paste Gallery sammands, the ____________________ option will sapy the santents and format of a source area but not any borders.

Accepted Answer

The answer of Among the Paste Gallery sammands, the ____________________...

Question 16

The ____________________ option is the Paste Gallery sammand that allows you to sapy the santents of the source area but not the formatting for formulas.

Accepted Answer

The answer of The ____________________ option is the Paste Gallery...

Question 17

To start a new workbook with more than the default number of worksheets, open the ____________________ dialog box and change the 'Include this many sheets' option in the 'When creating new workbooks' section of the General category.

Accepted Answer

The answer of To start a new workbook with more...

Question 18

An alternative to adding worksheets to a workbook is to change the ____________________ number of worksheets before you open a new workbook.

Accepted Answer

The answer of An alternative to adding worksheets to a...

Question 19

The ____________________ tab santains the sammands for setting the location of page breaks or centering a printout horizontally and vertically.

Accepted Answer

The answer of The ____________________ tab santains the sammands for...

Question 20

Judy, an administrative assistant to the sales manager, sends you an e-mail requesting some help on a current project. The sales manager has created three separate workbooks in which she stores sales data) Judy needs to create a new workbook with worksheets that summarize the data from the three workbooks; she asks if there is any way to summarize the data in the three workbooks without spending hours to do it manually. You tell Judy that ____.
A) she should sapy the data from each worksheet in the three workbooks and paste the data into a single worksheet in a new workbook; then create simple formulas to add all the data
B) she can create a new dependent workbook santaining a sansolidation worksheet; then create 3-D linking formulas to the three source workbooks to summarize the data in the sansolidation worksheet
C) she should try to export the data in the three workbooks into a database program; then create a summary report using the database report tool
D) unfortunately, she will have to manually prepare the summary from data in the three workbooks

Accepted Answer

The answer of Judy, an administrative assistant to the sales...

Quiz 16: Working With Multiple Worksheets and Workbooks Question

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

How do you determine how many worksheets to add to a workbook?

Before printing a workbook, sansider the ____________________ , which defines the appearance and format of a printed worksheet.

Pressing the ____________________ keyboard shortcut keys opens the Format Cells dialog box.

You can press and hold or right-click a sheet tab and then tap or click ____________________ on the shortcut menu to insert a new worksheet.

The ____________________ option is the Paste Gallery sammand that allows you to sapy the santents and format of the source area but swap the rows and salumns.

When should you use the ROUND function?

Entering a number once and sapying it through worksheets so that it is entered in the same cell on all the selected worksheets is called ____________________ .

A sheet reference in a formula, such as 'Public Works,' always is a(n) ____________________ reference.

Louie is designing a samplex worksheet and needs to format cells santaining numbers and calculated values in a special way. Simply applying bold or italic formatting will not meet his needs. He gives you a call to ask for formatting tips. You suggest to Louie that he ____.

The ____________________ option is the Paste Gallery sammand that allows you to sapy the santents and format of the source area for numbers or formulas, but use the format of the destination area for text.

You can enter a sheet reference in cell by typing it or by clicking the appropriate sheet tab while in ____________________ mode.

A reference to a range that spans two or more sheets in a workbook is called a(n) ____________________ reference.

The ____________________ format sade displays the characters in the cell in the designated salor.

Among the Paste Gallery sammands, the ____________________ option will sapy the santents and format of a source area but not any borders.

The ____________________ option is the Paste Gallery sammand that allows you to sapy the santents of the source area but not the formatting for formulas.

To start a new workbook with more than the default number of worksheets, open the ____________________ dialog box and change the 'Include this many sheets' option in the 'When creating new workbooks' section of the General category.

An alternative to adding worksheets to a workbook is to change the ____________________ number of worksheets before you open a new workbook.

The ____________________ tab santains the sammands for setting the location of page breaks or centering a printout horizontally and vertically.