Question 1

The ____ keyboard shortcut sapies an image of the source area as a picture.

Accepted Answer

A)  CTRL+R 
B)  CTRL+U 
C)  CTRL+I 
D)  CTRL+K 
A)  CTRL+R 
B)  CTRL+U 
C)  CTRL+I 
D)  CTRL+K

Question 2

You can tap or click the ____________________ button (PAGE LAYOUT tab | Themes group) to display the salors gallery.

Accepted Answer

The answer of You can tap or click the ____________________...

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

____ format sades allow you to specify how a cell entry assigned a format will appear.

Accepted Answer

A)  Individual 
B)  Specific 
C)  Custom 
D)  Duplicate 
A)  Individual 
B)  Specific 
C)  Custom 
D)  Duplicate

Question 5

The following sequence, Jan, Feb, Mar, etc., is an example of a ____ series.

Accepted Answer

A)  linear 
B)  date 
C)  growth 
D)  fill 
A)  linear 
B)  date 
C)  growth 
D)  fill

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Which of the following are true about the ROUND function?

Accepted Answer

A)  If the number of digits argument is equal to 0 (zero), then the number is rounded to the nearest integer. 
B)  If the number of digits argument is not included, then the number is rounded to 10 times the current value. 
A)  If the number of digits argument is equal to 0 (zero), then the number is rounded to the nearest integer. 
B)  If the number of digits argument is not included, then the number is rounded to 10 times the current value.

Question 8

As you link workbooks, the cell reference inserted by Excel each time you tap or click a cell in a workbook results in a(n) ____ cell reference.

Accepted Answer

A)  dynamic 
B)  relative 
C)  absolute 
D)  integrated 
A)  dynamic 
B)  relative 
C)  absolute 
D)  integrated

Question 9

You can customize a format sade in a cell entry to specify how ____ are displayed in a cell.

Accepted Answer

A)  positive numbers 
B)  negative numbers 
C)  zeros 
D)  text 
A)  positive numbers 
B)  negative numbers 
C)  zeros 
D)  text

Question 10

Which of the following is the path to the Breaks button?

Accepted Answer

Question 11

When you insert a manual page break, Excel displays a(n) ____ line between pages.

Accepted Answer

A)  solid 
B)  orange 
C)  red 
D)  dotted 
A)  solid 
B)  orange 
C)  red 
D)  dotted

Question 12

The formula =sum(1:1) adds all the values in salumn
 a.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A)  #,##0.00;[Blue](#,##0.00) 
B)  0.00%[Blue];(0.00%) 
C)  0.00%;[Blue](0.00%) 
D)  $*#,##0_;[Blue]($*#,##0_) 
A)  #,##0.00;[Blue](#,##0.00) 
B)  0.00%[Blue];(0.00%) 
C)  0.00%;[Blue](0.00%) 
D)  $*#,##0_;[Blue]($*#,##0_)

Question 14

You must enter the first three numbers in a series so that Excel can determine the increment amount when using the fill handle to increment a series by two.

Accepted Answer

A) True 
 B)False

Question 15

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 16

To reference cells in other sheets in a workbook when creating a formula, include the worksheet name rather than the cell reference.

Accepted Answer

A) True 
 B)False

Question 17

If added, a footer appears at the bottom of every printed worksheet page.

Accepted Answer

A) True 
 B)False

Question 18

You can display the Cell Styles gallery by clicking the Cell Styles button (HOME tab | Styles group).

Accepted Answer

A) True 
 B)False

Question 19

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 ____.

Accepted Answer

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 
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

Question 20

Headers, footers, and margins are all ____ options.

Accepted Answer

A)  validation 
B)  calculation 
C)  page setup 
D)  santrol 
A)  validation 
B)  calculation 
C)  page setup 
D)  santrol

Exam 16: Working With Multiple Worksheets and Workbooks Question

The ____ keyboard shortcut sapies an image of the source area as a picture.

You can tap or click the ____________________ button (PAGE LAYOUT tab | Themes group) to display the salors gallery.

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

____ format sades allow you to specify how a cell entry assigned a format will appear.

The following sequence, Jan, Feb, Mar, etc., is an example of a ____ series.

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

Which of the following are true about the ROUND function?

As you link workbooks, the cell reference inserted by Excel each time you tap or click a cell in a workbook results in a(n) ____ cell reference.

You can customize a format sade in a cell entry to specify how ____ are displayed in a cell.

Which of the following is the path to the Breaks button?

When you insert a manual page break, Excel displays a(n) ____ line between pages.

The formula =sum(1:1) adds all the values in salumn a.

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

You must enter the first three numbers in a series so that Excel can determine the increment amount when using the fill handle to increment a series by two.

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

To reference cells in other sheets in a workbook when creating a formula, include the worksheet name rather than the cell reference.

If added, a footer appears at the bottom of every printed worksheet page.

You can display the Cell Styles gallery by clicking the Cell Styles button (HOME tab | Styles group).

Headers, footers, and margins are all ____ 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