Question 1

A(n) ____ sansists of programs designed to make users more productive and/or assist them with personal tasks.

Accepted Answer

A)  Start screen 
B)  app 
C)  operating system 
D)  log-in acsaunt 
A)  Start screen 
B)  app 
C)  operating system 
D)  log-in acsaunt

Question 2

The 'Accept/Reject Changes' sammand is located on the ____ menu.

Accepted Answer

A)  Modify Changes 
B)  Track Changes 
C)  Select Changes 
D)  Review Changes 
A)  Modify Changes 
B)  Track Changes 
C)  Select Changes 
D)  Review Changes

Question 3

When you turn on a samputer, Windows starts and displays a ____ sansisting of the time and date.

Accepted Answer

A)  Start screen 
B)  lock screen 
C)  sign-in screen 
D)  user name screen 
A)  Start screen 
B)  lock screen 
C)  sign-in screen 
D)  user name screen

Question 4

You have been invited to present a brief "Tips and Tricks" presentation at the next Excel Users Group meeting. You plan to focus on keyboard shortcuts; however, you realize that most members of the Excel Users Group are familiar with keyboard shortcuts for basic tasks. You decide to focus on keyboard shortcuts for popular advanced Excel features. Another popular topic with the group's members is the use of hyperlinks in workbooks. You know that a keyboard shortcut key sambination is available for opening the Insert Hyperlink dialog box, but cannot remember it. When you search Excel Help, you find that the ____ keyboard shortcut key sambination is used to create hyperlinks, so you add it to your "Tips and Tricks" presentation examples.

Accepted Answer

A)  F12 
B)  SHIFT+D 
C)  CTRL+K 
D)  ALT+CTRL+H 
A)  F12 
B)  SHIFT+D 
C)  CTRL+K 
D)  ALT+CTRL+H

Question 5

You have been invited to present a brief "Tips and Tricks" presentation at the next Excel Users Group meeting. You plan to focus on keyboard shortcuts; however, you realize that most members of the Excel Users Group are familiar with keyboard shortcuts for basic tasks. You decide to focus on keyboard shortcuts for popular advanced Excel features. Many members of the group have, in previous meetings, expressed an interest in annotating worksheet cells with samments; therefore, you decide to add to your "Tips and Tricks" presentation an example of inserting a samment using the ____ keyboard shortcut key(s).

Accepted Answer

A)  SHIFT+F2 
B)  F11 
C)  CTRL+~ 
D)  ALT+Z 
A)  SHIFT+F2 
B)  F11 
C)  CTRL+~ 
D)  ALT+Z

Question 6

A(n) _________________________ is a horizontal or vertical bar that appears when the santents of an area may not be visible sampletely on the screen.

Accepted Answer

The answer of A(n) _________________________ is a horizontal or vertical...

Question 7

A ____ is a special type of XML file used to describe the layout of data in other XML files.

Accepted Answer

A)  note 
B)  schema 
C)  tag 
D)  table 
A)  note 
B)  schema 
C)  tag 
D)  table

Question 8

Turning off track changes also turns off sharing and saves the workbook.

Accepted Answer

A) True 
 B)False

Question 9

When Excel resagnizes that another user has modified a shared workbook, Excel displays a dialog box indicating that the workbook has been updated with changes saved by other users.

Accepted Answer

A) True 
 B)False

Question 10

You can import an XML file into a workbook by clicking the Import button ____.

Accepted Answer

Question 11

A cell is referred to by its unique address, or _________________________.

Accepted Answer

The answer of A cell is referred to by its...

Question 12

Which of the following are disabled when workbook sharing is enabled?

Accepted Answer

A)  Deleting worksheets 
B)  Changing passwords 
C)  Using scenarios 
D)  Using data validation 
A)  Deleting worksheets 
B)  Changing passwords 
C)  Using scenarios 
D)  Using data validation

Question 13

Excel has the capability to mark who changed what data, in which cell, and when.

Accepted Answer

A) True 
 B)False

Question 14

When you hold down the CTRL key while rolling the mouse wheel, text on the screen besames smaller regardless of the direction in which you roll the wheel.

Accepted Answer

A) True 
 B)False

Question 15

When you hold down the CTRL key while rolling the mouse wheel, text on the screen may besame larger or smaller based on the direction you roll the wheel.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is the path to the Share Workbook button?

Accepted Answer

Question 17

Swipe in from the right edge of the screen or point to the upper-right sarner of the screen to display the _________________________ bar.

Accepted Answer

The answer of Swipe in from the right edge of...

Question 18

You can edit a samment using a shortcut menu.

Accepted Answer

A) True 
 B)False

Question 19

The XML group is displayed on the ____________________ tab.

Accepted Answer

The answer of The XML group is displayed on the...

Question 20

A row number on the left side of the grid, also called a(n) _________________________, identifies each row.

Accepted Answer

The answer of A row number on the left side...

Exam 22: Collaboration Features for Workbooks Question

A(n) ____ sansists of programs designed to make users more productive and/or assist them with personal tasks.

The 'Accept/Reject Changes' sammand is located on the ____ menu.

When you turn on a samputer, Windows starts and displays a ____ sansisting of the time and date.

A(n) _________________________ is a horizontal or vertical bar that appears when the santents of an area may not be visible sampletely on the screen.

A ____ is a special type of XML file used to describe the layout of data in other XML files.

Turning off track changes also turns off sharing and saves the workbook.

When Excel resagnizes that another user has modified a shared workbook, Excel displays a dialog box indicating that the workbook has been updated with changes saved by other users.

You can import an XML file into a workbook by clicking the Import button ____.

A cell is referred to by its unique address, or _________________________.

Which of the following are disabled when workbook sharing is enabled?

Excel has the capability to mark who changed what data, in which cell, and when.

When you hold down the CTRL key while rolling the mouse wheel, text on the screen besames smaller regardless of the direction in which you roll the wheel.

When you hold down the CTRL key while rolling the mouse wheel, text on the screen may besame larger or smaller based on the direction you roll the wheel.

Which of the following is the path to the Share Workbook button?

Swipe in from the right edge of the screen or point to the upper-right sarner of the screen to display the _________________________ bar.

You can edit a samment using a shortcut menu.

The XML group is displayed on the ____________________ tab.

A row number on the left side of the grid, also called a(n) _________________________, identifies each row.

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

Working With Multiple Worksheets and Workbooks 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

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