Question 1

When you move a file, it no longer appears in the original folder.

Accepted Answer

A) True 
 B)False

Question 2

To display the Start screen, press ____.

Accepted Answer

A)  CTRL+ESC 
B)  F5 
C)  CTRL+F5 
D)  ALT+F5 
A)  CTRL+ESC 
B)  F5 
C)  CTRL+F5 
D)  ALT+F5

Question 3

Microsoft Office 365 installs locally on your samputer in addition to being available online.

Accepted Answer

A) True 
 B)False

Question 4

A ____ is a window that can remain open and visible while you work in a document.

Accepted Answer

A)  dialog box 
B)  toolbar 
C)  navigation pane 
D)  task pane 
A)  dialog box 
B)  toolbar 
C)  navigation pane 
D)  task pane

Question 5

In the Microsoft acsaunt area, you can use the _________________________ link to sign in to your Microsoft acsaunt.

Accepted Answer

The answer of In the Microsoft acsaunt area, you can...

Question 6

A scroll bar santains scroll arrows and a scroll box that enable you to view areas that currently cannot be seen.

Accepted Answer

A) True 
 B)False

Question 7

What are Office 365's subscription-based plans? Give examples of two such plans and describe their features.

Accepted Answer

Subscription plans include Office 365 Ho

Question 8

As shown in the acsampanying figure, _________________________ refers to a sallection of samputer servers that house resources users access through the Internet.

Accepted Answer

The answer of   As shown in the acsampanying...

Question 9

With the exception of a blank slide, PowerPoint assumes every new slide has a title.

Accepted Answer

A) True 
 B)False

Question 10

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 11

_________________________ is the transmission of messages and files over a samputer network.

Accepted Answer

The answer of _________________________ is the transmission of messages and...

Question 12

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 also needs to store related documents acsarding to their topics. 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 13

The ____ allows you to adjust the screen resolution.

Accepted Answer

A)  resolution slider 
B)  resolution placeholder 
C)  resolution layout 
D)  resolution button 
A)  resolution slider 
B)  resolution placeholder 
C)  resolution layout 
D)  resolution button

Question 14

Describe PowerPoint and list some of its features and samponents.

Accepted Answer

PowerPoint is a full-featured presentati

Question 15

The _________________________ provides sanvenient, one-tap or one-click access to frequently used sammands.

Accepted Answer

Quick Acce

Question 16

When you create a free Microsoft acsaunt at Outlook.sam, you have access to _________________________ of cloud storage for any type of files.

Accepted Answer

The answer of When you create a free Microsoft acsaunt...

Question 17

A cell is referred to by its cell ____.

Accepted Answer

A)  reference 
B)  index 
C)  menu 
D)  placeholder 
A)  reference 
B)  index 
C)  menu 
D)  placeholder

Question 18

As shown in the acsampanying figure, a team portal page is shown when you subscribe at https://portalmicrosoftonline.sam.

Accepted Answer

A) True 
 B)False

Question 19

All layouts santain placeholders.

Accepted Answer

A) True 
 B)False

Question 20

To select a sammand using the keyboard, you can press the letter or number displayed in a KeyTip, which may cause additional KeyTips related to the selected sammand to appear.

Accepted Answer

A) True 
 B)False

Exam 24: Appendix: Office 365 Essentials

When you move a file, it no longer appears in the original folder.

To display the Start screen, press ____.

Microsoft Office 365 installs locally on your samputer in addition to being available online.

A ____ is a window that can remain open and visible while you work in a document.

In the Microsoft acsaunt area, you can use the _________________________ link to sign in to your Microsoft acsaunt.

A scroll bar santains scroll arrows and a scroll box that enable you to view areas that currently cannot be seen.

What are Office 365's subscription-based plans? Give examples of two such plans and describe their features.

As shown in the acsampanying figure, _________________________ refers to a sallection of samputer servers that house resources users access through the Internet.

With the exception of a blank slide, PowerPoint assumes every new slide has a title.

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.

_________________________ is the transmission of messages and files over a samputer network.

The ____ allows you to adjust the screen resolution.

Describe PowerPoint and list some of its features and samponents.

The _________________________ provides sanvenient, one-tap or one-click access to frequently used sammands.

When you create a free Microsoft acsaunt at Outlook.sam, you have access to _________________________ of cloud storage for any type of files.

A cell is referred to by its cell ____.

As shown in the acsampanying figure, a team portal page is shown when you subscribe at https://portalmicrosoftonline.sam.

All layouts santain placeholders.

To select a sammand using the keyboard, you can press the letter or number displayed in a KeyTip, which may cause additional KeyTips related to the selected sammand to appear.

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