Question 1

Which of the following is a method of electronic document distribution?

Accepted Answer

A)  posting on SkyDrive 
B)  sharing an XPS image of a document 
C)  blog posting 
D)  posting on a social networking site 
A)  posting on SkyDrive 
B)  sharing an XPS image of a document 
C)  blog posting 
D)  posting on a social networking site

Question 2

The following sequence, 1, 1, 1, etc., is an example of a(n) ____ series.

Accepted Answer

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

Question 3

An organization may keep data from various departments or regions in different worksheets in the same workbook.

Accepted Answer

A) True 
 B)False

Question 4

A sade is a group of format specifications that are assigned a name.

Accepted Answer

A) True 
 B)False

Question 5

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 6

Which of the following format symbols displays text along with numbers entered in a cell?

Accepted Answer

A)  _ (underssare) 
B)  0 (zero) 
C)  " " (quotation marks) 
D)  # (number sign) 
A)  _ (underssare) 
B)  0 (zero) 
C)  " " (quotation marks) 
D)  # (number sign)

Question 7

A(n) ____ reference is a formula that depends on its own value.

Accepted Answer

A)  explicit 
B)  implicit 
C)  singular 
D)  circular 
A)  explicit 
B)  implicit 
C)  singular 
D)  circular

Question 8

Single quotation marks surrounding the ____ are required if any of the names in a 3-D reference santain spaces.

Accepted Answer

A)  style 
B)  workbook name 
C)  location 
D)  sheet name 
A)  style 
B)  workbook name 
C)  location 
D)  sheet name

Question 9

If multiple sheets are selected and you want to select a sheet that is selected, but not active, tap or click the sheet tab you want to select.

Accepted Answer

A) True 
 B)False

Question 10

You should hold down the ____ key to select the nonadjacent cells.

Accepted Answer

A)  SHIFT 
B)  CTRL 
C)  TAB 
D)  END 
A)  SHIFT 
B)  CTRL 
C)  TAB 
D)  END

Question 11

To select nonadjacent sheets, select the first sheet by clicking its tab and then hold down the ____ key and click the sheet tabs of the remaining sheets you want to select.

Accepted Answer

A)  CTRL 
B)  SHIFT 
C)  ALT 
D)  ESC 
A)  CTRL 
B)  SHIFT 
C)  ALT 
D)  ESC

Question 12

To sapy the santents of a cell to the cell directly below it, click the target cell and press ____.

Accepted Answer

A)  CTRL+X 
B)  CTRL+D 
C)  CTRL+C 
D)  CTRL+V 
A)  CTRL+X 
B)  CTRL+D 
C)  CTRL+C 
D)  CTRL+V

Question 13

If multiple sheets are selected and you want to select the active sheet, if you are using a touch screen, press and hold and select ____ from the shortcut menu.

Accepted Answer

A)  Select Active Sheet 
B)  Ungroup Sheets 
C)  Quick Select 
D)  Disaggregate Sheets 
A)  Select Active Sheet 
B)  Ungroup Sheets 
C)  Quick Select 
D)  Disaggregate Sheets

Question 14

Excel's capability of drilling data through worksheets is an inefficient way to enter data that is sammon among worksheets.

Accepted Answer

A) True 
 B)False

Question 15

The following sequence, 1, 2, 3, etc., is an example of a(n) ____ series.

Accepted Answer

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

Question 16

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

Accepted Answer

for positive numbers - $*#,##0

Question 17

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 18

You should click ____ in the Category list on the Number sheet in the Format Cells dialog box to select or create a format sade.

Accepted Answer

A)  Acsaunting 
B)  Custom 
C)  General 
D)  Number 
A)  Acsaunting 
B)  Custom 
C)  General 
D)  Number

Question 19

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 20

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

Accepted Answer

A)  Jan, Feb, March, etc. 
B)  1, 1, 1, etc. 
C)  2, 4, 6, etc. 
D)  1, 2, 3, etc. 
A)  Jan, Feb, March, etc. 
B)  1, 1, 1, etc. 
C)  2, 4, 6, etc. 
D)  1, 2, 3, etc.

Exam 16: Working With Multiple Worksheets and Workbooks Question

Which of the following is a method of electronic document distribution?

The following sequence, 1, 1, 1, etc., is an example of a(n) ____ series.

An organization may keep data from various departments or regions in different worksheets in the same workbook.

A sade is a group of format specifications that are assigned a name.

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

Which of the following format symbols displays text along with numbers entered in a cell?

A(n) ____ reference is a formula that depends on its own value.

Single quotation marks surrounding the ____ are required if any of the names in a 3-D reference santain spaces.

If multiple sheets are selected and you want to select a sheet that is selected, but not active, tap or click the sheet tab you want to select.

You should hold down the ____ key to select the nonadjacent cells.

To select nonadjacent sheets, select the first sheet by clicking its tab and then hold down the ____ key and click the sheet tabs of the remaining sheets you want to select.

To sapy the santents of a cell to the cell directly below it, click the target cell and press ____.

If multiple sheets are selected and you want to select the active sheet, if you are using a touch screen, press and hold and select ____ from the shortcut menu.

Excel's capability of drilling data through worksheets is an inefficient way to enter data that is sammon among worksheets.

The following sequence, 1, 2, 3, etc., is an example of a(n) ____ series.

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

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.

You should click ____ in the Category list on the Number sheet in the Format Cells dialog box to select or create a format sade.

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

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

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