Match between columns Premises: By default, this is blank in a worksheet.

The Answer of dependent workbook and drag page break and is...

Match between columns Premises: Enter a number once and copy it through worksheets.

The Answer of circular reference and dependent workbook and CTRL+P is...

Exam 6: Excell: Working With Multiple Worksheets and Workbooks

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

(Short Answer)

4.8/5

(42)

Question 81

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

Premises:

By default, this is blank in a worksheet.

Responses:

dependent workbook

drag page break

circular reference

Correct Answer:

Verified

By default, this is blank in a worksheet.

(Matching)

4.9/5

(35)

Question 82

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

Premises:

Enter a number once and copy it through worksheets.

Responses:

circular reference

dependent workbook

CTRL+P

Correct Answer:

Verified

Enter a number once and copy it through worksheets.

(Matching)

4.8/5

(41)

Question 83

The ____ style is the format style that Excel initially assigns to all cells in a workbook.

(Multiple Choice)

4.9/5

(31)

Question 84

Modified Multiple Choice Which of the following fill actions can you perform by dragging the fill handle?

(Multiple Choice)

4.9/5

(39)

Question 85

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

Premises:

The process of summarizing data included on multiple worksheets on one worksheet.

Responses:

CTRL+E

circular reference

header

Correct Answer:

Verified

The process of summarizing data included on multiple worksheets on one worksheet.

(Matching)

4.8/5

(37)

Question 86

When tiling windows vertically the windows appear as wide as possible.

(True/False)

4.8/5

(31)

Question 87

You can create and then assign a style to a cell, a range of cells, a worksheet, or a workbook.

(True/False)

5.0/5

(30)

Question 88

The following sequence, 2, 4, 6, etc., is an example of a ____ series.

(Multiple Choice)

4.9/5

(25)

Question 89

When you insert a new worksheet, Excel places the new sheet tab to the left of the active tab.

(True/False)

4.7/5

(25)

Question 90

Using the following illustration, define the possible four sections of a format code. $*#,##0.00; [Magenta]#,##0.00; 0.00; "The answer is"@

(Essay)

4.9/5

(28)

Question 91

Always take the time to select ____________________ data that tests the limits of the formulas.

(Short Answer)

4.7/5

(38)

Question 92

When you print a worksheet or use the Page Setup dialog box, Excel inserts ____ breaks that show the boundaries of what will print on each page.

(Multiple Choice)

4.7/5

(32)

Question 93

A ____ is a reference to a cell or range of cells in another workbook.

(Multiple Choice)

4.7/5

(31)

Question 94

The system date might be displayed as a series of number signs if the date, as initially formatted by Excel, does not fit in the width of the cell.

(True/False)

4.8/5

(34)

Question 95

Which of the following format codes shows percent values with two decimal places and shows negative percent values in blue with parentheses?

(Multiple Choice)

4.7/5

(37)

Question 96

You can click the ____________________ tabs at the bottom of the Excel window to move from worksheet to worksheet in a workbook.

(Short Answer)

4.7/5

(34)

Question 97

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

(Essay)

4.9/5

(37)

Question 98

Critical Thinking Questions Case 5-1 Louie is designing a complex worksheet and needs to format cells containing 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 ____.

(Multiple Choice)

4.8/5

(35)

Question 99

A range that spans two or more worksheets in a workbook is called a ____ range.

(Multiple Choice)

4.9/5

(47)

Question 100

Showing 81 - 100 of 112

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

The ____ style is the format style that Excel initially assigns to all cells in a workbook.

Modified Multiple Choice Which of the following fill actions can you perform by dragging the fill handle?

When tiling windows vertically the windows appear as wide as possible.

You can create and then assign a style to a cell, a range of cells, a worksheet, or a workbook.

The following sequence, 2, 4, 6, etc., is an example of a ____ series.

When you insert a new worksheet, Excel places the new sheet tab to the left of the active tab.

Using the following illustration, define the possible four sections of a format code. $*#,##0.00; [Magenta]#,##0.00; 0.00; "The answer is"@

Always take the time to select ____________________ data that tests the limits of the formulas.

When you print a worksheet or use the Page Setup dialog box, Excel inserts ____ breaks that show the boundaries of what will print on each page.

A ____ is a reference to a cell or range of cells in another workbook.

The system date might be displayed as a series of number signs if the date, as initially formatted by Excel, does not fit in the width of the cell.

Which of the following format codes shows percent values with two decimal places and shows negative percent values in blue with parentheses?

You can click the ____________________ tabs at the bottom of the Excel window to move from worksheet to worksheet in a workbook.

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

A range that spans two or more worksheets in a workbook is called a ____ range.

Access: Creating Reports and Forms

Access: Multiple-Table Forms

Access: Advanced Report Techniques

Access: Advanced Form Techniques

Excell: Financial Functions, Data Tables, and Amortization Schedules Question

Excell: Creating, Sorting, and Querying a Table

Excell: Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots

Outlook : Managing Contacts and Personal Contact Information With Outlook

Powerpoint: Creating and Formatting Information Graphics Question

Powerpoint: Collaborating on and Delivering a Presentation Question

Powerpoint: Navigating Presentations Using Hyperlinks and Action Buttons

Powerpoint: Creating a Self-Running Presentation Containing Animation

Word: Using a Template to Create a Resume and Sharing a Finished Document

Word: Generating Form Letters, Mailing Labels, and a Directory

Word: Creating a Newsletter With a Pull-Quote and Graphics

Filters