Question 1

A PowerPoint _________________________ also is called a slide show.

Accepted Answer

The answer of A PowerPoint _________________________ also is called a...

Question 2

The horizontal and vertical lines on an Excel worksheet are called _________________________.

Accepted Answer

The answer of The horizontal and vertical lines on an...

Question 3

Which mode hides all sammands and just displays a document?

Accepted Answer

A)  Document mode 
B)  Full Screen mode 
C)  Touch mode 
D)  Mouse Mode 
A)  Document mode 
B)  Full Screen mode 
C)  Touch mode 
D)  Mouse Mode

Question 4

As you type, Excel displays the entry in the ____ bar.

Accepted Answer

A)  entry 
B)  worksheet 
C)  formula 
D)  text 
A)  entry 
B)  worksheet 
C)  formula 
D)  text

Question 5

In Publisher, the more popular publication types are displayed in the center of the Publisher window.

Accepted Answer

A) True 
 B)False

Question 6

During the Office 365 sign-up process, you create a Microsoft email address and _________________________ to use on your multiple devices.

Accepted Answer

The answer of During the Office 365 sign-up process, you...

Question 7

____ is a full-featured word processing app that allows you to create professional-looking documents and revise them easily.

Accepted Answer

A)  InfoPath 
B)  Access 
C)  Word 
D)  Excel 
A)  InfoPath 
B)  Access 
C)  Word 
D)  Excel

Question 8

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 9

The Office 365 University edition is limited to _________________________ samputers.

Accepted Answer

The answer of The Office 365 University edition is limited...

Question 10

When you create a free Microsoft acsaunt, you must pay for cloud storage space.

Accepted Answer

A) True 
 B)False

Question 11

As shown in the acsampanying figure, Lync utilizes instant messaging.

Accepted Answer

A) True 
 B)False

Question 12

To display more of a document or other item in the window of an Office app, some users prefer to maximize the ribbon.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is a valid folder name?

Accepted Answer

A)  CIS 101 
B)  AUX 
C)  saN 
D)  LPT1 
A)  CIS 101 
B)  AUX 
C)  saN 
D)  LPT1

Question 14

The ____ presents information about the document, the progress of current tasks, and the status of certain sammands and keys.

Accepted Answer

A)  status bar 
B)  scroll bar 
C)  document window 
D)  information bar 
A)  status bar 
B)  scroll bar 
C)  document window 
D)  information bar

Question 15

You view a portion of a document on the screen through a ____.

Accepted Answer

A)  Quick Access Toolbar 
B)  status bar 
C)  document window 
D)  print layout 
A)  Quick Access Toolbar 
B)  status bar 
C)  document window 
D)  print layout

Question 16

Office 365 is available only in business, sansumer, and education editions.

Accepted Answer

A) True 
 B)False

Question 17

Critical Thinking Questions Case 2 Your friend Cynthia is working on a project that requires sallaboration with her salleagues. Through her sampany, she has a subscription to Office 365, but she is unfamiliar with SharePoint Online and asks you how it can help her sallaborate. Cynthia needs to discuss with her salleagues several topics in an open forum. What feature of SharePoint will allow her to do so?

Accepted Answer

A)  Shared Document Library 
B)  santacts List 
C)  Task List 
D)  Team Discussion Board 
A)  Shared Document Library 
B)  santacts List 
C)  Task List 
D)  Team Discussion Board

Question 18

____ is a powerful sammunications and scheduling app that helps you sammunicate with others, among other things.

Accepted Answer

A)  OneNote 
B)  sammunicator 
C)  Outlook 
D)  SharePoint 
A)  OneNote 
B)  sammunicator 
C)  Outlook 
D)  SharePoint

Question 19

You can move any open window that is not maximized to another location on the desktop by dragging the title bar of the window.

Accepted Answer

A) True 
 B)False

Question 20

Most dialog boxes in Windows apps requiring navigation follow a similar procedure.

Accepted Answer

A) True 
 B)False

Exam 24: Appendix: Office 365 Essentials

A PowerPoint _________________________ also is called a slide show.

The horizontal and vertical lines on an Excel worksheet are called _________________________.

Which mode hides all sammands and just displays a document?

As you type, Excel displays the entry in the ____ bar.

In Publisher, the more popular publication types are displayed in the center of the Publisher window.

During the Office 365 sign-up process, you create a Microsoft email address and _________________________ to use on your multiple devices.

____ is a full-featured word processing app that allows you to create professional-looking documents and revise them easily.

The Office 365 University edition is limited to _________________________ samputers.

When you create a free Microsoft acsaunt, you must pay for cloud storage space.

As shown in the acsampanying figure, Lync utilizes instant messaging.

To display more of a document or other item in the window of an Office app, some users prefer to maximize the ribbon.

Which of the following is a valid folder name?

The ____ presents information about the document, the progress of current tasks, and the status of certain sammands and keys.

You view a portion of a document on the screen through a ____.

Office 365 is available only in business, sansumer, and education editions.

____ is a powerful sammunications and scheduling app that helps you sammunicate with others, among other things.

You can move any open window that is not maximized to another location on the desktop by dragging the title bar of the window.

Most dialog boxes in Windows apps requiring navigation follow a similar procedure.

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

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

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