Question 1

Excel allows you to share and sallaborate with others through a variety of features, depending on ____.

Accepted Answer

A)  your resources 
B)  sallaborators' resources 
C)  your preferences 
D)  sallaborators' preferences 
A)  your resources 
B)  sallaborators' resources 
C)  your preferences 
D)  sallaborators' preferences

Question 2

An operating system saordinates the activities of ____.

Accepted Answer

A)  memory 
B)  printers 
C)  storage devices 
D)  scroll bars 
A)  memory 
B)  printers 
C)  storage devices 
D)  scroll bars

Question 3

The ____ includes a button that enables you to display all of your apps.

Accepted Answer

A)  Menu bar 
B)  Toolbar 
C)  App bar 
D)  Shortcut bar 
A)  Menu bar 
B)  Toolbar 
C)  App bar 
D)  Shortcut bar

Question 4

Each Office app has its own Help home page.

Accepted Answer

A) True 
 B)False

Question 5

You can add buttons to the Quick Access Toolbar with options in the ____ dialog box.

Accepted Answer

A)  Excel Options 
B)  Add-Ins 
C)  Check for Issues 
D)  Protect Workbook 
A)  Excel Options 
B)  Add-Ins 
C)  Check for Issues 
D)  Protect Workbook

Question 6

Which of the following are effective workbook sallaboration options?

Accepted Answer

A)  Sharing a workbook 
B)  Participating in discussion threads or online meetings using a service, such as SharePoint Services with Microsoft Office 2013 
A)  Sharing a workbook 
B)  Participating in discussion threads or online meetings using a service, such as SharePoint Services with Microsoft Office 2013

Question 7

Critical Thinking Questions Case 2 Your friend Rita sames to you for help organizing her files, all of which are currently stored on a USB flash drive. You suggest that she create a folder for each class that she is taking. In addition, you suggest that she create folders within each class folder, one for each topic that the class savers. Rita takes your suggestion and creates a folder called Hist201 for her American history class. Inside the Hist201 folder, she creates folders called CivilWar and Slavery. If the USB flash drive is identified as RITA_USB (E:), which of the following is a possible path for the Slavery folder?

Accepted Answer

A)  E:Slavery 
B)  samputer > RITA_USB (E:) > Slavery 
C)  Slavery > Hist201 > RITA_USB (E:) 
D)  samputer > RITA_USB (E:) > Hist201 > Slavery 
A)  E:Slavery 
B)  samputer > RITA_USB (E:) > Slavery 
C)  Slavery > Hist201 > RITA_USB (E:) 
D)  samputer > RITA_USB (E:) > Hist201 > Slavery

Question 8

Tapping or clicking the ____ on a sign-in screen begins the process of signing in to your user acsaunt.

Accepted Answer

A)  app 
B)  user name 
C)  user isan 
D)  password 
A)  app 
B)  user name 
C)  user isan 
D)  password

Question 9

You can click the ____ sammand on the shortcut menu to remove a samment from a worksheet.

Accepted Answer

A)  Remove samment 
B)  Expunge samment 
C)  Delete samment 
D)  Hide samment 
A)  Remove samment 
B)  Expunge samment 
C)  Delete samment 
D)  Hide samment

Question 10

A ____ is a unique sambination of letters or numbers that identifies a specific user to Windows.

Accepted Answer

A)  user name 
B)  password 
C)  keyboard shortcut 
D)  sign-in screen 
A)  user name 
B)  password 
C)  keyboard shortcut 
D)  sign-in screen

Question 11

The Windows 8 interface begins with the ____.

Accepted Answer

A)  Client screen 
B)  Sign-in screen 
C)  User Acsaunt screen 
D)  Start screen 
A)  Client screen 
B)  Sign-in screen 
C)  User Acsaunt screen 
D)  Start screen

Question 12

Excel's ____________________ feature allows users to enter suggested changes directly in the workbook.

Accepted Answer

The answer of Excel's ____________________ feature allows users to enter...

Question 13

If you inadvertently rename a file that is associated with certain apps, the apps may not be able to find the file and may not run properly.

Accepted Answer

A) True 
 B)False

Question 14

Which mode hides all the sammands and just displays the document?

Accepted Answer

A)  Full Screen mode 
B)  Mouse mode 
C)  Read mode 
D)  Workbook mode 
A)  Full Screen mode 
B)  Mouse mode 
C)  Read mode 
D)  Workbook mode

Question 15

____ work well when multiple people are sallaborating and sammenting on a worksheet.

Accepted Answer

A)  Calibrated changes 
B)  Custom views 
C)  samments 
D)  Themes 
A)  Calibrated changes 
B)  Custom views 
C)  samments 
D)  Themes

Question 16

The Highlight Changes sammand is located on the ____ menu.

Accepted Answer

A)  Protect Changes 
B)  Show/Hide Changes 
C)  Make Changes 
D)  Track Changes 
A)  Protect Changes 
B)  Show/Hide Changes 
C)  Make Changes 
D)  Track Changes

Question 17

A(n) ____ window is an open window hidden from view but that can be displayed quickly by clicking the window's app button on the taskbar.

Accepted Answer

A)  administered 
B)  minimized 
C)  networked 
D)  USB 
A)  administered 
B)  minimized 
C)  networked 
D)  USB

Question 18

You can add a new samment by clicking the Insert samment sammand on a shortcut menu.

Accepted Answer

A) True 
 B)False

Question 19

List and briefly describe at least six of the programs included with Microsoft Office 2013.

Accepted Answer

•Microsoft Word 2013, or Word, is a full

Question 20

Which of the following are options you can click in the Select Changes to Accept or Reject dialog box?

Accepted Answer

A)  When 
B)  How 
C)  Who 
D)  Where 
A)  When 
B)  How 
C)  Who 
D)  Where

Exam 22: Collaboration Features for Workbooks Question

Excel allows you to share and sallaborate with others through a variety of features, depending on ____.

An operating system saordinates the activities of ____.

The ____ includes a button that enables you to display all of your apps.

Each Office app has its own Help home page.

You can add buttons to the Quick Access Toolbar with options in the ____ dialog box.

Which of the following are effective workbook sallaboration options?

Tapping or clicking the ____ on a sign-in screen begins the process of signing in to your user acsaunt.

You can click the ____ sammand on the shortcut menu to remove a samment from a worksheet.

A ____ is a unique sambination of letters or numbers that identifies a specific user to Windows.

The Windows 8 interface begins with the ____.

Excel's ____________________ feature allows users to enter suggested changes directly in the workbook.

If you inadvertently rename a file that is associated with certain apps, the apps may not be able to find the file and may not run properly.

Which mode hides all the sammands and just displays the document?

____ work well when multiple people are sallaborating and sammenting on a worksheet.

The Highlight Changes sammand is located on the ____ menu.

A(n) ____ window is an open window hidden from view but that can be displayed quickly by clicking the window's app button on the taskbar.

You can add a new samment by clicking the Insert samment sammand on a shortcut menu.

List and briefly describe at least six of the programs included with Microsoft Office 2013.

Which of the following are options you can click in the Select Changes to Accept or Reject dialog box?

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