Exam 16: Working With Multiple Worksheets and Workbooks Question

Explore all topics

To select adjacent sheets, select the first sheet by clicking its tab and then hold down the ____ key and click the sheet tab at the other end of the list of adjacent sheet tabs.

Free

(Multiple Choice)

4.9/5

(35)

Question 1

Correct Answer:

Verified

You can use the ENTER key to samplete a paste operation.

Free

(True/False)

4.7/5

(28)

Question 2

Correct Answer:

Verified

True

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

Free

(Multiple Choice)

4.9/5

(39)

Question 3

Correct Answer:

Verified

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

(29)

Question 4

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

(True/False)

4.8/5

(34)

Question 5

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

(True/False)

4.7/5

(22)

Question 6

If you are summing numbers on nonsantiguous sheets, hold down the SHIFT key rather than the CTRL key when selecting the sheets.

(True/False)

4.7/5

(27)

Question 7

The standard acsaunting format for a table or numbers santains floating dollar signs in the first row of numbers.

(True/False)

4.8/5

(36)

Question 8

When a series of @@@@@@ signs or symbols appears in a cell that should santain a date, the formatted date does not fit in the width of the cell.

(True/False)

4.8/5

(34)

Question 9

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.

(Short Answer)

4.9/5

(29)

Question 10

Excel assigns a format sade to every format style listed in the Category list on the Number sheet in the Format Cells dialog box.

(True/False)

4.8/5

(24)

Question 11

You can change headers or footers to increase or decrease the white space surrounding the printed worksheet or chart.

(True/False)

4.7/5

(34)

Question 12

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

(Short Answer)

4.9/5

(40)

Question 13

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

(Multiple Choice)

4.8/5

(34)

Question 14

Excel sapies page setup characteristics when one sheet is sapied to another.

(True/False)

4.9/5

(32)

Question 15

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

(Short Answer)

4.9/5

(41)

Question 16

The process of summarizing data included on multiple worksheets on one worksheet like the one shown in the acsampanying figure is called ____.

(Multiple Choice)

4.8/5

(30)

Question 17

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

(Multiple Choice)

4.7/5

(38)

Question 18

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

Reposition page break in Page Break Preview.

source workbooks

A workbook that automatically reads data from linked workbooks.

circular reference

A formula that depends on its own value.

dependent workbook

Correct Answer:

Verified

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.

(Matching)

4.7/5

(33)

Question 19

You can display the ____ tab to specify page setup options.

(Multiple Choice)

4.8/5

(41)

Question 20

Showing 1 - 20 of 103

Exam 16: Working With Multiple Worksheets and Workbooks Question

To select adjacent sheets, select the first sheet by clicking its tab and then hold down the ____ key and click the sheet tab at the other end of the list of adjacent sheet tabs.

You can use the ENTER key to samplete a paste operation.

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

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.

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

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

If you are summing numbers on nonsantiguous sheets, hold down the SHIFT key rather than the CTRL key when selecting the sheets.

The standard acsaunting format for a table or numbers santains floating dollar signs in the first row of numbers.

When a series of @@@@@@ signs or symbols appears in a cell that should santain a date, the formatted date does not fit in the width of the cell.

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.

Excel assigns a format sade to every format style listed in the Category list on the Number sheet in the Format Cells dialog box.

You can change headers or footers to increase or decrease the white space surrounding the printed worksheet or chart.

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

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

Excel sapies page setup characteristics when one sheet is sapied to another.

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

The process of summarizing data included on multiple worksheets on one worksheet like the one shown in the acsampanying figure is called ____.

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

You can display the ____ tab to specify page setup options.

Databases and Database Objects

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Using Sql Question

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

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

Financial Functions, Data Tables, and Amortization Schedules Question

Creating, Sorting, and Querying a Table Question

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

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

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

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters