感謝閱讀

• 非原創聲明，根據微軟課程學習理解而已
• Get started with Microsoft 365
• • Work Smarter with Microsoft Word
  • 與 Microsoft Word 更加智能地工作
  • Microsoft 365 Subscriptions
  • Microsoft 365 訂閱
  • 個人補充
  • Exercise: Finding Help and changing account settings
  • 練習：查找幫助并更改賬戶設置
  • Introduction to Word
  • Word簡介
  • Introduction to Excel
  • Excel簡介
  • Introduction to PowerPoint
  • PPT介紹
  • Introduction to Outlook
  • Outlook介紹
  • Exercise: Organizing files in OneDrive
  • 練習：在OneDrive中組織文件
• Word
• • Exercise: Identifying the elements of the Word interface
  • Exercise: 識別Word界面的元素
  • Exercise: Finding and replacing text
  • 練習：查找和替換文本
  • 個人補充
  • Exercise: Applying character formatting
  • 練習：應用字符格式化
  • Exercise: Displaying text as list items
  • 練習：將文本顯示為列表項
  • Font group commands keyboard shortcuts
  • 字體組命令的鍵盤快捷鍵
  • Exercise: Controlling paragraph layout
  • 練習：控制段落布局
  • Exercise: Applying borders and shading
  • 練習：應用邊框和底紋
  • Exercise: Inserting a table
  • 練習：插入表格
  • Exercise: Sorting table data
  • 練習：表格數據排序
  • Exercise: Adding images to a document
  • 練習：向文檔添加圖像
  • Exercise: Adjusting image appearance
  • 練習：調整圖片外觀
  • Exercise: Creating text boxes
  • 練習：創建文本框
  • Exercise: Applying a page border and color
  • 練習：應用頁面邊框和顏色
  • Exercise: Inserting footnotes and endnotes
  • 練習：插入腳注和尾注
• EXCEL
• • Working with data
  • 數據工作
  • Formatting text
  • 格式化文本
  • Exercise: Formatting cells
  • 練習：格式化單元格
  • Exercise: Searching for and replacing data
  • 練習：搜索和替換數據
  • Refining the page layout and applying print options
  • 完善頁面布局并應用打印選項
  • Exercise: Using formulas and functions
  • 練習：使用公式和函數
  • Exercise: Sort and filter data
  • 練習：排序和篩選數據
  • Exercise: Analyzing data using text functions
  • 練習：使用文本函數分析數據
  • Exercise: Analyzing data using logical functions
  • 練習：使用邏輯函數分析數據
  • Exercise: Creating and modifying a table
  • 練習：創建和修改表格
  • Exercise: Creating charts
  • 練習：生成圖表
  • Exercise: Modifying and formatting charts
  • 練習：修改和格式化圖表
  • Exercise: Apply conditional formatting
  • 練習：應用條件格式化
  • Exercise: Using data sources
  • 練習使用數據源
• PPT
• • Exercise: Building a presentation
  • 練習：構建演示文稿
  • Exercise: Laying out a presentation
  • 練習：演示文稿的布局
  • Exercise: Creating SmartArt
  • 練習：創建智能圖形
  • Exercise: Grouping objects
  • 練習：對象分組
  • Exercise: Arranging objects
  • 練習：排列對象
  • Exercise: Animating objects
  • 練習：為對象添加動畫效果
  • Exercise: Inserting a table from Microsoft Excel
  • 練習：從Microsoft Excel插入表格
  • Exercise: Adding hyperlinks and action buttons
  • 練習：添加超鏈接和操作按鈕

非原創聲明，根據微軟課程學習理解而已

本課程為翻譯+難點舉例，并不是完全原創，大家想看原文請進入微軟認證官網點擊報名后支付大約99D即可學習以及考試認證。
點我去官網
資源采用了coursera的
個人補充是對前一個知識點的個人理解

Get started with Microsoft 365

Work Smarter with Microsoft Word

Welcome to work smarter with Microsoft Word. In this course, you’ll discover the basics of Microsoft Word alongside the other apps and services available with the Microsoft 365 Cloud-based productivity tool. This course will help you to get started with basic Microsoft Word tasks and by the end of the course, you’ll be familiar with how to complete a range of complex tasks using the application. In Module 1 you’ll get started with Microsoft 365 by learning how to navigate your account, explore the basics of the most used Office 365 applications and access Microsoft 365 services. In Module 2 you’ll begin using the Microsoft Word application. As part of this module, you’ll navigate a document, use Word’s editing tools and proof a document using proofing tools. In Module 3, you’ll move on to more complex Word tasks like formatting for text and paragraphs, adding and editing tables and cells and you’ll also learn how to manage lists. Module 4 focuses on working with graphics in Microsoft Word as well as adding graphics and using images in a document, you’ll also learn how to create and format text boxes and pull quotes, use shapes in a document and enhance your documents using WordArt and complex illustrations. Module 5 looks at finalizing documents in Microsoft Word. This includes a review of accessibility features, how to set save options, controlling text flow, adding captions and references, adding hyperlinks footnotes and endnotes and slightly more complex tasks such as adding citations, a bibliography and a table of contents. In Module 6, you’ll discover how to collaborate on documents with other team members. You’ll look at how to share a document, work with comments and track changes and perform a document review. Finally in Module 7 you’ll have the opportunity to complete an optional honors assignment for special recognition. Throughout this course you’ll learn the skills and techniques required to produce high-quality professional documents. This assignment provides you with a practical opportunity to apply those skills. You don’t have to complete this assignment to obtain the course certificate, however, if you complete this and all other honors assignments, then your course certificate will include a special honors recognition. Best of luck on your journey through Microsoft Word.

與 Microsoft Word 更加智能地工作

歡迎使用 Microsoft Word 進行智能辦公。在這門課程中，您將探索 Microsoft 365 云端生產力工具中的 Microsoft Word 基礎知識，以及其他應用程序和服務。本課程將幫助您入門基本的 Microsoft Word 任務，并在課程結束時熟悉如何使用該應用程序完成一系列復雜的任務。在第1模塊中，您將通過學習如何導航您的帳戶、探索最常用的 Office 365 應用程序的基礎知識以及訪問 Microsoft 365 服務來開始使用 Microsoft 365。在第2模塊中，您將開始使用 Microsoft Word 應用程序。作為該模塊的一部分，您將學習如何導航文檔、使用 Word 的編輯工具并使用校對工具校對文檔。在第3模塊中，您將繼續進行更復雜的 Word 任務，如文本和段落格式化、添加和編輯表格和單元格，以及學習如何管理列表。第4模塊著重介紹如何在 Microsoft Word 中處理圖形，包括添加圖形和在文檔中使用圖片，您還將學習如何創建和格式化文本框和引用文本，使用形狀和復雜插圖來增強文檔。第5模塊介紹如何在 Microsoft Word 中完成文檔的最終定稿。包括無障礙功能的回顧、設置保存選項、控制文本流動、添加標題和引用、添加超鏈接、腳注和尾注，以及稍微復雜一些的任務，如添加引文、參考文獻和目錄。在第6模塊中，您將了解如何與其他團隊成員一起協作編輯文檔。您將學習如何共享文檔、處理評論和修訂記錄，并進行文檔審查。最后，在第7模塊中，您將有機會完成一個可選的榮譽作業，以獲得特別認可。在整個課程中，您將學習到制作高質量專業文檔所需的技能和技術。完成這個作業不是獲得課程證書的必要條件，但如果您完成了這個作業和所有其他榮譽作業，您的課程證書將包括特別的榮譽認可。祝您在 Microsoft Word 的學習之旅中好運。

Microsoft 365 Subscriptions

As you probably already know, Microsoft 365 is a subscription based service. But there are a lot of different subscription types available. Which one you select will depend entirely upon the needs of your business. WestCal’s are eager to make use of Microsoft apps like Word, Excel and PowerPoint. So they’ve signed up for a Microsoft 365. Business basic plan with accounts for each employee. Thomas has been given his account details. He now needs to log into his new 365-account and explore the available apps. Microsoft 365 has become increasingly popular amongst organizations, both large and small. It offers a variety of different plans to best suit organizations of any size. For example, Microsoft 365 family and Microsoft 365 personal plans are best for general consumers while Microsoft 365 apps for business. Microsoft 365, business basic and Microsoft 365 business standards are aimed at small to medium sized businesses. Larger organizations can choose Microsoft 365 apps for enterprise and Office 365 E1 E3 and E5. Keep in mind that Microsoft 365 features are constantly evolving. While the features you’ll see in this course are correct. At the time of filming, they may have been updated or changed since. So what’s included in a Microsoft 365 subscription. As you’ve seen, Microsoft 365 availability depends entirely on your organization subscription. However, all Microsoft 365 business basic and Office 365 E1 subscriptions do include the essential office apps covered earlier cloud based services, management tools and other features. Assuming your organization is using the Microsoft 365 Business Standard plan, you will also have access to always up to date desktop versions of these essential office applications. Most plans also include applications for host email, web conferencing, instant messaging and one Terabyte of one drive cloud storage, along with lots more features. Now that you’re familiar with the basics of Microsoft 365, you might be asking yourself what’s required to use its services. You’ll be happy to hear that although Microsoft 365 is based in the cloud, there are only a few requirements for enjoying its full benefits. These requirements include a device running Windows 8 or Windows 10 operating systems. Internet access to install or activate Microsoft 365 and manage it. Finally and perhaps most importantly, a compatible browser is also needed. Recent or current versions of Microsoft Edge, Firefox, Safari or Google Chrome are all compatible with Microsoft 365.

Microsoft 365 訂閱

正如您可能已經了解到的，Microsoft 365是一種訂閱制的服務，但有許多不同的訂閱類型可供選擇，您的選擇將完全取決于您企業的需求。WestCal公司希望使用Microsoft的應用程序，如Word、Excel和PowerPoint，因此他們注冊了一個帶有每個員工帳戶的Microsoft 365商業基本計劃。Thomas已經收到了他的帳戶詳細信息，現在他需要登錄他的新365帳戶并探索可用的應用程序。

Microsoft 365在各種組織中越來越受歡迎，無論是大型還是小型。它提供了多種不同的計劃，以最好地適應各種規模的組織。例如，Microsoft 365家庭版和Microsoft 365個人版適用于一般消費者，而Microsoft 365企業版、Microsoft 365商業基本版和Microsoft 365商業標準版則針對中小型企業。較大的組織可以選擇Microsoft 365企業版和Office 365 E1、E3和E5版本。需要注意的是，Microsoft 365的功能不斷演變。雖然在本課程中展示的功能是正確的，但在拍攝時可能已經更新或更改。那么在Microsoft 365訂閱中包括了什么呢？

正如您所看到的，Microsoft 365的可用性完全取決于您的組織的訂閱。然而，所有的Microsoft 365商業基本版和Office 365 E1訂閱都包括了之前介紹的基本辦公應用程序、基于云的服務、管理工具和其他功能。假設您的組織正在使用Microsoft 365商業標準版計劃，您還將能夠訪問始終保持更新的桌面版辦公應用程序。大多數計劃還包括用于托管電子郵件、網絡會議、即時通訊以及1 TB的OneDrive云存儲空間等應用程序，以及許多其他功能。

現在您已經熟悉了Microsoft 365的基礎知識，您可能會問自己使用其服務需要什么要求。您會很高興聽到，盡管Microsoft 365是基于云的，但享受其全部好處只需要很少的要求。這些要求包括運行Windows 8或Windows 10操作系統的設備，互聯網訪問以安裝或激活Microsoft 365并進行管理，最后但也許最重要的是，還需要兼容的瀏覽器。近期或當前版本的Microsoft Edge、Firefox、Safari或Google Chrome都與Microsoft 365兼容

個人補充

Microsoft 365 訂閱計劃通常包括不同層次的功能和服務，適用于個人用戶、家庭用戶和企業用戶等不同的需求。例如：

Microsoft 365 家庭版：適用于家庭使用，最多可供 6 個用戶使用。包括 Office 應用程序的桌面版本、OneDrive 云存儲、Microsoft Teams 和 Skype 高級功能等。

Microsoft 365 個人版：適用于單一用戶，包括 Office 應用程序的桌面版本、OneDrive 云存儲以及額外的優惠。

Microsoft 365 企業應用版：適用于中小型企業，包括 Office 應用程序的 Web 和移動版本、企業級電子郵件和日歷功能、OneDrive 云存儲以及 Microsoft Teams 團隊協作工具。

Microsoft 365 企業基礎版：適用于中小型企業，包括 Office 應用程序的 Web 和移動版本、企業級電子郵件和日歷功能，以及 OneDrive 云存儲，但不包括 Office 應用程序的桌面版本。

Microsoft 365 企業標準版：包括 Microsoft 365 企業基礎版的所有功能，同時還提供每個用戶最多 5 臺 PC/Mac 的 Office 應用程序的桌面版本，以及訪問 SharePoint 和 Teams 進行團隊協作的額外功能。

Microsoft 365 企業級應用版：適用于較大組織，包括 Office 應用程序的 Web、移動和桌面版本，以及高級安全和合規功能，還包括帶有 Exchange Online 的企業級電子郵件和日歷功能，以及 OneDrive 云存儲。

Office 365 E1、E3 和 E5：這些是面向企業的高級訂閱計劃，提供不同層次的功能和能力，包括 Office 應用程序的桌面版本、高級安全和合規功能，以及額外的服務，如高級分析、高級威脅保護等。

Exercise: Finding Help and changing account settings

Note: You can pass this course and all graded assessments without access to the downloadable version of Microsoft 365.

How to complete this exercise
To complete the exercises in this course, you will need access to Microsoft Word.

Note: Keep in mind that if you are using free Office for the web or another version of the Microsoft Word application some features covered in this exercise may not be available.

Free Office for the web

If you do not have access to Microsoft Word, you can use free Office for the web. This version of Office allows you to view and edit files in apps like Word, Excel, and PowerPoint. This free service is available to anyone with a Microsoft account.

Access Microsoft Account

Log in to your Microsoft account. Type the email, phone number, or Skype sign-in that you use for other services (Outlook, Office, etc.), then select Next. If you don’t have a Microsoft account, you can select No account? Create one! If you are using a business account, please get the necessary authorization before trying to change your password.

Let’s get started!

Now that you are comfortable logging into your account and completing basic navigation tasks, you would like to customize some account settings.

To begin, turn on and log into your computer. Open your most frequently used browser and open the https://login.microsoftonline.com web page:

On the landing page for your account, open the Settings task pane by clicking the Settings icon that appears in the top right-hand corner of the toolbar at the top of the current page:

Settings icon in the browser window

With the Settings task pane now displayed, click the Change your password link:

Change your password link in the settings window

A new tab will open in your browser. Sign into your account again if asked to do so. Type your existing password into the Old password text box. Type a new password for your account into the Create new password and Confirm new password text boxes. Click the submit button:

Change password window, new password created with submit button

You will now be returned to the landing page for your account:

Initials from the user profile on the top right of the window

Click the Help icon on the toolbar:

Question icon on the window

Type “Change time zone” into the search field, then click the Search icon:

Search tab containing the text “change time zone” with search button

Scroll down and select the Change your display language and time zone in Microsoft 365 for Business link:

The results from the search regarding change time zone

Scan through the instructions to change language and time zone. Once finished, click X to close the Help pane:

Close button on the top right of the help window

Sign out of your Microsoft 365 account and close your browser to complete this exercise.

練習：查找幫助并更改賬戶設置

注意：您可以在沒有下載版本的Microsoft 365的情況下通過此課程和所有評估考試。

如何完成此練習

要完成此課程中的練習，您需要訪問Microsoft Word。

注意：請記住，如果您使用的是免費的Office在線版本或其他版本的Microsoft Word應用程序，可能無法使用本練習中涉及的某些功能。

免費的Office在線版本

如果您無法訪問Microsoft Word，您可以使用免費的Office在線版本。這個版本的Office允許您在Word、Excel和PowerPoint等應用程序中查看和編輯文件。這個免費服務對任何擁有Microsoft賬戶的人都是可用的。

訪問Microsoft賬戶

登錄您的Microsoft賬戶。在登錄頁面上輸入您用于其他服務（Outlook、Office等）的電子郵件、電話號碼或Skype登錄名，然后選擇下一步。如果您沒有Microsoft賬戶，可以選擇沒有賬戶？創建一個！如果您正在使用企業賬戶，請在嘗試更改密碼之前獲取必要的授權。

讓我們開始吧！

現在您已經熟悉如何登錄您的賬戶并完成基本的導航任務，您想要自定義一些賬戶設置。

首先，打開并登錄您的計算機。在您最常使用的瀏覽器中打開https://login.microsoftonline.com網頁：

在您的賬戶登錄頁面上，通過點擊工具欄頂部右側的設置圖標，打開設置任務窗格：

現在顯示了設置任務窗格后，點擊“更改密碼”鏈接：

新的標簽頁會在瀏覽器中打開。如果被要求重新登錄賬戶，請重新登錄。在“舊密碼”文本框中輸入您的現有密碼。在“創建新密碼”和“確認新密碼”文本框中輸入一個新密碼。點擊提交按鈕：

現在您將返回到您的賬戶登錄頁面：

點擊工具欄上的幫助圖標：

在搜索框中輸入“更改時區”，然后點擊搜索圖標：

滾動到頁面底部，選擇“在Microsoft 365 for Business中更改您的顯示語言和時區”鏈接：

閱讀更改語言和時區的說明。完成后，點擊X關閉幫助窗格：

登出您的Microsoft 365賬戶并關閉瀏覽器，完成此練習。

Introduction to Word

One of the key features of Microsoft 365 is the inclusion of Office apps. In this lesson you’ll explore the interfaces and discover the basic features of the apps that come with a Microsoft 365 Business Standard subscription. The apps you’ll look at include Word, Excel, PowerPoint, and Outlook. As well as these standard apps, you’ll also have the option to explore the following: Access, Publisher, and OneNote. Keep in mind that most of these applications are available in both online and offline versions. There are often significant differences between these versions such as reduced features, but don’t worry you’ll find out about these differences in more detail over the course of this lesson. Grace is an employee with WestCal in their fulfillment center. However, she would like to transition to the editorial side of the business. To achieve this goal, she’s begun a publishing course at the local university. As part of this course, she needs to develop a familiarity with basic Microsoft Office 365 applications. One of the key applications that Grace needs to develop her skill set with is Microsoft Word. You’re probably already familiar with Microsoft Word on a basic level, but here’s a quick recap of some key facts to make sure you’re up to speed. Microsoft Word is Microsoft’s powerful word processing program, and is used to create professional documents. You can also add tables, images, and much more. Word’s interface is intuitive and easy to use. It’s also customizable so you can make sure that the tools you need are easily accessible. Microsoft Word is offered as both online and desktop versions. Although the online version has limited features, it provides most of the frequently used tools needed to compose a simple document. Let’s explore the different parts of the Microsoft Word interface. The first part of Word that we’ll explore is the title bar, this is where the name of the current file is displayed along with other information, like if it’s been saved. You can select the file name to change it. Next is the ribbon interface, this displays top commands organized into groups. You can use these top commands to create and edit different elements of your documents, like tables or paragraphs. The working area is the main portion of the Word document, this is where you can view, create, and edit content. Finally, there’s the status bar. This bar is used to display information about the documents such as the page number, the word count, and other information like the default language. You’ve explored the Microsoft Word interface and key features, you’re now ready to open the app and start exploring it for yourself.

Word簡介

Microsoft 365的關鍵特點之一是包含了Office應用程序。在本課程中，您將探索這些應用程序的界面，并了解隨附于Microsoft 365 Business Standard訂閱的應用程序的基本功能。您將查看的應用程序包括Word、Excel、PowerPoint和Outlook。除了這些標準應用程序外，您還可以選擇探索以下應用程序：Access、Publisher和OneNote。請注意，這些應用程序大多數都有在線和離線版本。這些版本之間通常存在顯著差異，如功能減少，但不要擔心，您將在本課程的過程中詳細了解這些差異。Grace是WestCal公司履行中心的一名員工。然而，她希望轉向業務的編輯部門。為了實現這個目標，她在當地大學開始了一門出版課程。作為這門課程的一部分，她需要熟悉基本的Microsoft Office 365應用程序。Grace需要熟練掌握的關鍵應用程序之一是Microsoft Word。您可能已經對Microsoft Word有基本的了解，但以下是一些關鍵事實的快速回顧，以確保您了解最新情況。Microsoft Word是微軟強大的文字處理程序，用于創建專業文檔。您還可以添加表格、圖片等等。Word的界面直觀易用，而且可定制，以便您可以確保需要的工具易于訪問。Microsoft Word提供在線和桌面版本。雖然在線版本功能有限，但提供了撰寫簡單文檔所需的大多數常用工具。讓我們探索一下Microsoft Word界面的不同部分。我們將首先探討的是標題欄，其中顯示了當前文件的名稱以及其他信息，例如是否已保存。您可以選擇文件名進行更改。接下來是功能區界面，它顯示了按組組織的頂部命令。您可以使用這些頂部命令創建和編輯文檔的不同元素，如表格或段落。工作區是Word文檔的主要部分，您可以在這里查看、創建和編輯內容。最后，還有狀態欄。此欄用于顯示有關文檔的信息，如頁碼、字數以及默認語言等。您已經探索了Microsoft Word的界面和關鍵功能，現在可以打開應用程序并開始自己探索了。

Introduction to Excel

Excel is a key application in the Microsoft 365 Office Suite. I’m sure you’ve heard of Excel, but are you familiar with what it’s used for? Microsoft Excel is Microsoft’s spreadsheet program for managing numerical data, like financial information. You can also use it to add charts, shapes, and much more. Microsoft Excel has both online and desktop versions. If you need only simple formulas, the online version will satisfy your requirements. Otherwise, you can choose to work on the desktop app. Grace is learning how to use Excel as WestCal need her to assist them with tracking finances and other data. As part of retraining, Grace will need to become familiar with Excel’s interface and tools. Excel is one of the more complex interfaces within the Microsoft Office Suite, but don’t worry, here’s an overview of Excel’s interface. In Excel, the name of the currently open file is displayed in the title bar. There’s also a ribbon interface which displays tab commands organized into groups. You can use these commands to create and edit content in the document like the Page Layout, Formulas and Data. Next is the formula bar in which you can enter data into a cell. Below this, is the work area. This displays the data in your current file that you’re working on. Finally, there’s the status bar. This bar displays running calculations and other information about the workbook. That’s your overview of Excel’s main features and interface. You’re now ready to begin exploring Excel and it’s numerical management features

Excel簡介

Excel 是 Microsoft 365 Office 套件中的一個關鍵應用程序。我相信您已經聽說過 Excel，但您是否熟悉它的用途呢？Microsoft Excel 是 Microsoft 的電子表格程序，用于管理數值數據，例如財務信息。您還可以使用它添加圖表、形狀等其他內容。Microsoft Excel 有在線和桌面版本。如果您只需要簡單的公式，在線版本就可以滿足您的需求。否則，您可以選擇使用桌面應用程序。Grace 正在學習如何使用 Excel，因為 WestCal 需要她協助他們進行財務和其他數據的跟蹤。作為重新培訓的一部分，Grace 需要熟悉 Excel 的界面和工具。Excel 是 Microsoft Office Suite 中較為復雜的界面之一，但不用擔心，這里有一個 Excel 界面的概述。在 Excel 中，當前打開文件的名稱顯示在標題欄中。接下來是功能區界面，它顯示以標簽組織的命令。您可以使用這些命令在文檔中創建和編輯內容，例如頁面布局、公式和數據。下面是公式欄，您可以在其中輸入數據到單元格中。在此下面是工作區，它顯示您當前正在處理的文件中的數據。最后是狀態欄，它顯示正在運行的計算和有關工作簿的其他信息。這是 Excel 的主要特點和界面的概述。現在您已經準備好開始探索 Excel 和其數值管理功能了。

Introduction to PowerPoint

Microsoft PowerPoint is one of the most used apps in the Microsoft 365 Office Suite. Like with many of the other apps available in the Microsoft 365 Office Suite, you’ve probably used PowerPoint before. Take a moment to re-familiarize yourself with the basics. Microsoft PowerPoint is Microsoft’s presentation software program which is used to create professional presentations. You can create anything from a basic slideshow to a self-running narrated presentation using pictures, embedded videos, and sound. Like other apps, PowerPoint is available both online and offline, but with more functionality on desktop. Here’s a look at how PowerPoint is used over at WestCal. Grace is working on improving her PowerPoint skills. WestCal often uses PowerPoint to produce presentations for clients and their own internal departments. Grace would like to be able to create these presentations when she moves to the editorial department. To become more proficient with PowerPoint, Grace will need to familiarize herself with the program’s interface. Take a closer look at the program and find out what elements users like Grace need to know about. The first part of the PowerPoint interface is the title bar. This is where the name of the current file is displayed along with other information on the file. For example, you can see here that it’s been saved. You can click the filename to change it. Then there’s the ribbon interface. This displays top commands organized into groups like Insert, Slide Show, and View. Next, we have the slides pane. Each slide in the presentation is displayed in this pane as a thumbnail, to view a slide, to select it from the pane. Like other applications, there’s also a working area. This is where you can view and edit content from the currently selected side. Finally, there’s the status bar. This bar is used to display information about the presentation like the slide number and default language. You’ve now started your journey to creating professional and exciting PowerPoint presentations having learned to navigate the apps interface and locate its main features

PPT介紹

Microsoft PowerPoint 是 Microsoft 365 Office 套件中使用最廣泛的應用程序之一。就像其他 Microsoft 365 Office 套件中的應用程序一樣，您可能以前已經使用過 PowerPoint。現在讓我們再次熟悉一下基礎知識。Microsoft PowerPoint 是 Microsoft 的演示文稿軟件，用于創建專業的演示文稿。您可以創建從基本的幻燈片演示到包含圖片、嵌入視頻和聲音的自運行講述性演示文稿。和其他應用程序一樣，PowerPoint 有在線和離線兩種版本，但桌面版功能更為強大。現在讓我們來看看在 WestCal 公司如何使用 PowerPoint。Grace 正在提高她的 PowerPoint 技能。WestCal 經常使用 PowerPoint 為客戶和內部部門制作演示文稿。當她轉到編輯部門時，Grace 希望能夠創建這些演示文稿。為了更熟練地使用 PowerPoint，Grace 需要熟悉該程序的界面。讓我們更詳細地了解一下這個程序，并找出像 Grace 這樣的用戶需要了解的元素。PowerPoint 界面的第一部分是標題欄。這是當前文件的名稱以及文件的其他信息的顯示位置。例如，您可以在這里看到文件已保存。您可以點擊文件名來更改它。接下來是功能區界面。這顯示了以組織方式排列的頂部命令，例如插入、幻燈片放映和查看。然后是幻燈片窗格。每個演示文稿中的幻燈片都以縮略圖的形式顯示在這個窗格中，您可以從窗格中選擇幻燈片來查看。和其他應用程序一樣，還有一個工作區，這是您可以在當前選定的幻燈片中查看和編輯內容的地方。最后是狀態欄，用于顯示關于演示文稿的信息，例如幻燈片編號和默認語言。現在您已經開始了創建專業和引人入勝的 PowerPoint 演示文稿的旅程，已經學會了如何導航應用程序界面并找到其主要特點。

Introduction to Outlook

Microsoft Outlook is a cornerstone application for many businesses. Like with other Office applications, you’ve most likely used it before at some stage. Here’s a quick recap on the basics. Microsoft Outlook is a powerful and easy to use information management application. You can manage your email, calendar, contacts, tasks, and much more all from one central location. You can also connect and communicate more easily with your teammates. Like other apps, Outlook can also be accessed online or offline, but it’s best to use the desktop app if you need more functionality and customizability. Over at WestCal, Grace is hoping to gain more advanced skills with Outlook. She’s already familiar with the app but only the basic features. She wants to develop more advanced skills so that she can take on more of a managerial role in which she organizes and runs meetings with clients using the app. Before she can begin to boost her skills, Grace first needs to show that she’s familiar with Outlook’s interface. She needs to know what the main features are and where to find them. Explore the interface and find out what features Grace should be familiar with. The first part of Outlook we’ll focus on is the navigation commands. These are a series of commands that you can select to access different parts of Outlook such as the app launcher, the search box, links to view notifications, change settings, get help, and the my account task pane, then there’s the editing pane. You can use the editing pane to delete, move, and archive emails alongside other actions. Outlook also contains folders. You can use the folder section to organize and access emails. Next to the folders is the navigation pane. These are shortcut icons that you can use to switch between features like mail, calendar, people, and to do, or task workspaces. Finally, there’s the item list and reading pane. The item pane shows a list of items in the folder that you’ve currently selected like your inbox. When an item is selected, it appears in the reading pane where you can view its contents. That covers our overview of outlooks interface and features. Just like Grace, you’ve now also taken the first step to communicating and collaborating effortlessly with your colleagues.

Outlook介紹

Microsoft Outlook是許多企業的重要應用程序。和其他Office應用程序一樣，您很可能在某個階段使用過它。這是對基礎知識的簡要回顧。Microsoft Outlook是一款功能強大且易于使用的信息管理應用程序。您可以從一個中心位置管理電子郵件、日歷、聯系人、任務等等。您還可以更輕松地與團隊成員連接和溝通。像其他應用程序一樣，Outlook可以在線或離線訪問，但如果您需要更多的功能和可定制性，最好使用桌面應用程序。在WestCal，Grace希望通過Outlook獲得更高級的技能。她已經熟悉這個應用程序，但只是基本功能。她想要發展更高級的技能，以便能夠在管理角色中組織和運行與客戶的會議。在她開始提升技能之前，Grace首先需要展示她熟悉Outlook的界面。她需要知道主要的功能在哪里以及如何找到它們。探索界面，找出Grace應該熟悉的功能。我們將首先關注Outlook的導航命令。這些是一系列命令，您可以選擇訪問Outlook的不同部分，如應用程序啟動器、搜索框、查看通知的鏈接、更改設置、獲取幫助和我的帳戶任務窗格，然后是編輯窗格。您可以使用編輯窗格刪除、移動和歸檔電子郵件以及其他操作。Outlook還包含文件夾。您可以使用文件夾部分來組織和訪問電子郵件。文件夾旁邊是導航窗格。這些是快捷圖標，您可以用它們在郵件、日歷、聯系人、待辦事項或任務工作區之間切換。最后，有項目列表和閱讀窗格。項目窗格顯示了您當前選擇的文件夾中的項目列表，例如您的收件箱。當選擇一個項目時，它將顯示在閱讀窗格中，您可以在其中查看其內容。這就是我們對Outlook界面和功能的概述。就像Grace一樣，您現在已經邁出了與同事輕松溝通和協作的第一步。

Exercise: Organizing files in OneDrive

Note: You can pass this course and all graded assessments without access to the downloadable version of Word.

How to complete this exercise

To complete this exercise, you will need access to Microsoft Word.

Note: Keep in mind that if you are using free Office for the web or another version of the Microsoft Word application some features covered in this exercise may not be available.

Free Office for the web

If you do not have access to Microsoft Word, you can use Free Office for the web. This version of Office allows you to view and edit files in apps like Word, Excel, and PowerPoint. This free service is available to anyone with a Microsoft account.

Access Microsoft Account

Log in to your Microsoft account. Type the email, phone number, or Skype sign-in that you use for other services (Outlook, Office, etc.), then select Next. If you don’t have a Microsoft account, you can select No account? Create one!

Let’s get started!

In this exercise, you will upload a file to your OneDrive account, create a folder, and move the file into that folder.

To begin, turn on and log into your computer. Open your most frequently used browser and open the https://login.microsoftonline.com web page:

Microsoft sign in window with next button

Click the OneDrive tile on your landing page:

Microsoft 365 landing page with the OneDrive icon highlighted.Microsoft 365 landing page with the OneDrive icon highlighted.

The OneDrive for Business page will open in a new tab and show your account’s contents:

OneDrive for Business page open, showing the account’s contents

Let’s upload a new file to your OneDrive account. Click Upload → Files:

OneDrive window open, Upload option selected and Files chosen

The Open dialog box will appear. Navigate to your Exercise Files, locate any of the exercise files, and select it. Click Open.

Note: In this example we have selected the file Activity 3-1. You can select any file in your OneDrive.

Open dialog box appears, congaing the Exercise Files, Activity 3-1 file selected, Open button clicked

Back in OneDrive, you will see the new file listed here:

OneDrive dialog window open, containing the new file

Now, click New → Folder:

OneDrive dialog window open, New option selected and Folder option clicked

Type, “Exercise Files” for the new name and click Create:

Create a Folder dialog box open, Typed in the field “exercise Files”, Create button clicked

Drag and drop the file into the new folder.

Note: In this example we have selected the file Activity 3-1. You can select any file in your OneDrive.

OneDrive dialog box open, Activity 3-1 selected from the files, dragged and dropped the file into the new folder

This exercise is now complete.

練習：在OneDrive中組織文件

注意事項：您可以在沒有可下載的Word版本的情況下完成這門課程和所有評估。

如何完成這個練習

要完成這個練習，您需要訪問Microsoft Word。

注意：請注意，如果您使用的是免費的Office在線版或其他版本的Microsoft Word應用程序，本練習中涵蓋的某些功能可能無法使用。

免費的Office在線版

如果您沒有訪問Microsoft Word的權限，您可以使用免費的Office在線版。這個版本的Office允許您在類似Word、Excel和PowerPoint的應用程序中查看和編輯文件。這個免費服務對任何具有Microsoft帳戶的人都可用。

訪問Microsoft帳戶

登錄您的Microsoft帳戶。輸入您用于其他服務（Outlook、Office等）的電子郵件、電話號碼或Skype登錄，然后選擇下一步。如果您沒有Microsoft帳戶，您可以選擇“沒有帳戶？創建一個！”

讓我們開始吧！

在這個練習中，您將把一個文件上傳到您的OneDrive賬戶，創建一個文件夾，并將文件移動到該文件夾中。

首先，打開并登錄您的計算機。打開您最常使用的瀏覽器，然后打開https://login.microsoftonline.com網頁：
Microsoft登錄窗口，顯示下一步按鈕

在您的登錄頁面上點擊OneDrive磁貼：
Microsoft 365登錄頁面，OneDrive圖標已突出顯示

OneDrive for Business頁面將在一個新的選項卡中打開，并顯示您賬戶的內容：
OneDrive for Business頁面已打開，顯示賬戶的內容

讓我們將一個新文件上傳到您的OneDrive賬戶。點擊上傳 → 文件：
OneDrive窗口已打開，選擇上傳選項，并選擇文件選項

將會出現打開對話框。導航到您的Exercise Files文件夾，找到任何一個練習文件，并選擇它。點擊打開。
注意：在這個例子中，我們選擇了文件Activity 3-1。您可以選擇您OneDrive中的任何文件。

打開對話框出現，包含Exercise Files文件夾，Activity 3-1文件已選擇，點擊打開按鈕

回到OneDrive，您會看到新文件已列在這里：
OneDrive對話框窗口已打開，包含新文件

現在，點擊新建 → 文件夾：
OneDrive對話框窗口已打開，選擇新建選項，并點擊文件夾選項

輸入“Exercise Files”作為新名稱，然后點擊創建：
創建文件夾對話框已打開，輸入“Exercise Files”到字段中，點擊創建按鈕
將文件拖放到新文件夾中。
注意：在這個例子中，我們選擇了文件 “Activity 3-1”。您可以選擇您在 OneDrive 中的任何文件。

OneDrive 對話框打開，從文件中選擇了 “Activity 3-1”，將文件拖放到新文件夾中。

現在，這個練習已經完成。

Word

Exercise: Identifying the elements of the Word interface

Note: You can pass this course and all graded assessments without access to the downloadable version of Word.

How to complete this exercise

To complete this exercise, you will need access to Microsoft Word.

Note: Keep in mind that if you are using free Office for the web or another version of the Microsoft Word application some features covered in this exercise may not be available.

Free Office for the web

If you do not have access to Microsoft Word, you can use Free Office for the web. This version of Office allows you to view and edit files in apps like Word, Excel, and PowerPoint. This free service is available to anyone with a Microsoft account.

Access Microsoft Account

Log in to your Microsoft account. Type the email, phone number, or Skype sign-in that you use for other services (Outlook, Office, etc.), then select Next. If you don’t have a Microsoft account, you can select No account? Create one!

Let’s get started!

In this exercise, you will open Microsoft Word 365 and examine some of its commands.

Type “Word” into the search box on the Windows 10 taskbar:

Search box, with field to type the word for search
(If you are using Windows 8, start typing at the Start screen to search.)

Click the entry for Word 365 to start the program:

Search bar typed Word, Word application appeared in the best match section

Microsoft Word will start and prompt you to create a document using the Start screen. Click the thumbnail labelled “Single-spaced (blank):”

Microsoft Word window prompted with options of the documents that can be create, “Single-Spaced (blank)” option selected
(If you do not see this thumbnail, choose any other document with [blank] in brackets.)

Click “Create” in the resulting dialog box:

Microsoft Word will now create the document. Take a moment to hover your mouse over some commands on the Home tab. You may see a small box appear and describe the command – this is called a ScreenTip:

Microsoft create a new document, Home tab open, small box appear on the top of the commands

In the document, type your name:

Microsoft Word document opened with the name John Smith typed

Click the Heading 1 style on the Home tab to apply that style:

The Word document open, Hedng 1 option selected, the style panel opened, with the options of the styles for the document

Click the Design tab:

Word document tab open, Design option was selected

Click any Quick Style Set to change the look of your document:

Design tab open with Document Formatting options

Click the View tab:

The Word tab open, View tab selected

Click each of the views in the Views group, starting with Read Mode and ending with Draft. (Print Layout should already be applied.) How does each option change your document?

Microsoft View tab open with the options of views on the left side, start with Read Mode and end with Draft
Return to Print Layout when you are finished.

Click the X in the top right-hand corner of the program window to close Microsoft Word 365:

Word tab open with the close icon option on the top left

When you are prompted to save your document, click “Don’t Save” to complete the exercise:

Save window open with Don’t save option selected

Exercise: 識別Word界面的元素

注意：您可以在沒有下載版本的Word的情況下完成這門課程和所有的評估。

完成這個練習需要訪問Microsoft Word。

注意：請記住，如果您使用的是免費的Office在線版本或其他版本的Microsoft Word應用程序，一些在這個練習中涵蓋的功能可能不可用。

免費的Office在線版本

如果您沒有訪問Microsoft Word的權限，您可以使用免費的Office在線版本。這個版本的Office允許您在Word、Excel和PowerPoint等應用程序中查看和編輯文件。這個免費的服務對任何擁有Microsoft賬戶的人都是可用的。

訪問Microsoft賬戶

登錄您的Microsoft賬戶。輸入您用于其他服務（Outlook、Office等）的電子郵件、電話號碼或Skype登錄名，然后選擇“下一步”。如果您沒有Microsoft賬戶，您可以選擇“沒有賬戶？創建一個！”

讓我們開始！

在這個練習中，您將打開Microsoft Word 365并查看其一些命令。

在Windows 10任務欄的搜索框中鍵入“Word”：
搜索框，帶有輸入搜索詞的字段
（如果您使用的是Windows 8，在開始屏幕上開始輸入以進行搜索。）

點擊Word 365的條目以啟動程序：
搜索欄輸入Word，Word應用程序出現在最佳匹配部分

Microsoft Word將啟動并提示您使用啟動屏幕創建文檔。點擊標有“單倍行距（空白）”的縮略圖。
Microsoft Word窗口提示選擇可以創建的文檔選項，選擇了“單倍行距（空白）”
（如果您沒有看到這個縮略圖，選擇帶有[空白]的任何其他文檔。）

在彈出的對話框中點擊“創建”：

Microsoft Word現在將創建文檔。花一些時間將鼠標懸停在主頁選項卡上的一些命令上。您可能會看到一個小框彈出并描述命令 - 這被稱為屏幕提示：

Microsoft創建了一個新文檔，主頁選項卡打開，命令上方出現了一個小框

在文檔中輸入您的名字：
Microsoft Word文檔打開，輸入了名字John Smith

在主頁選項卡上點擊“標題 1”樣式以應用該樣式：
Word文檔打開，標題 1選項被選中，樣式面板打開，顯示了文檔的樣式選項

點擊“設計”選項卡：
Word文檔選項卡打開，選擇了“設計”選項
點擊任何快速樣式集，以改變您文檔的外觀：
“設計”選項卡打開，顯示文檔格式設置選項。

點擊“查看”選項卡：
Word 選項卡打開，選擇了“查看”選項卡。

點擊“查看”選項卡中的每個視圖，從“閱讀模式”開始，一直到“草稿”為止。（打印布局應該已經應用了。）每個選項如何改變您的文檔？
Microsoft Word 的“查看”選項卡打開，左側顯示不同的視圖選項，從“閱讀模式”開始，到“草稿”結束。
完成后返回打印布局視圖。

點擊程序窗口右上角的 X 按鈕，關閉 Microsoft Word 365：
Word 選項卡打開，頂部左側有關閉圖標選項。

當提示保存文檔時，點擊“不保存”以完成練習：

Exercise: Finding and replacing text

Note: You can pass this course and all graded assessments without access to the downloadable version of Word.

How to complete this exercise

To complete this exercise, you will need access to Microsoft Word.

Note: Keep in mind that if you are using free Office for the web or another version of the Microsoft Word application some features covered in this exercise may not be available.

Free Office for the web

If you do not have access to Microsoft Word, you can use Free Office for the web. This version of Office allows you to view and edit files in apps like Word, Excel, and PowerPoint. This free service is available to anyone with a Microsoft account.

Access Microsoft Account

Log in to your Microsoft account. Type the email, phone number, or Skype sign-in that you use for other services (Outlook, Office, etc.), then select Next. If you don’t have a Microsoft account, you can select No account? Create one!

Let’s get started!

In this activity, you will use the Navigation Pane and the Find and Replace dialog box.

Click on the link below to open the Microsoft Word exercise document you can use to complete this exercise.

Exercise: Finding and replacing text

Click View → Navigation Pane:

Word document opened, View tab chosen
(If this command is already checked, skip to the next step.)

Ensure the first tab (Headings) is selected. Review the list of headings in the document:

Word document with view options opened, Headings option selected

Click the Pages tab for a different view of the document:

Word document, view tab open with navigation window at the left, with pages option selected

Review the Navigation Pane:

Navigation widow opened with the 3 pages appearing the second page was selected

Now, we want to update the document to reflect our country (rather than the Canadian program this RFP was based on). Click Home → Replace to begin:

Word document with Home tab selected and replace option clicked

The Find and Replace dialog box will open to the Replace tab. Enter “Canadian” in the “Find what” field:

Enter “citizen” in the “Replace with” field:

Find and Replace window opened with “Replace with” field typed Citizen

Click “Find Next:”

Find an Replace widow with “Find Next” clicked

Review the context of this replacement. Since it makes sense, click “Replace:”

Find and Replace window opened with replace option chosen

Complete the next two replacements. When you reach the final sentence on Page 1, delete the text instead of replacing it:

(You can do this with the Find and Replace dialog box open.)

Repeat the deletion for the next two instances:

Find and Replace window opened with the “Target Canadian Communities” paragraph selected

We can now replace the instances in the rest of the document. Click “Replace All:”

Find and Replace window opened with “Replace All” option selected

You should be notified that one final replacement has been made. Click “OK” to close this dialog box:

Replacement notification appearing with “ok” option selected

Then, close the Find and Replace dialog box:

Find and Replace window opened with the close option selected
16. Save your document as Activity 2-3 Complete. Close Microsoft Word 365 to complete this exercise.

Now, you can check out an example of a completed document in the link below:

Completed Exercise Finding and replacing text

練習：查找和替換文本

注意：您可以在沒有下載版本的Word的情況下通過本課程和所有評分評估。

如何完成這個練習

要完成這個練習，您需要訪問Microsoft Word。

注意：請記住，如果您使用的是免費的Office在線版或其他版本的Microsoft Word應用程序，本練習涵蓋的一些功能可能無法使用。

免費的Office在線版

如果您沒有訪問Microsoft Word的權限，您可以使用免費的Office在線版。這個版本的Office允許您在Word、Excel和PowerPoint等應用程序中查看和編輯文件。這個免費服務對任何擁有Microsoft賬戶的人都是可用的。

訪問Microsoft賬戶

登錄您的Microsoft賬戶。輸入您用于其他服務（Outlook、Office等）的電子郵件、電話號碼或Skype登錄，然后選擇下一步。如果您沒有Microsoft賬戶，可以選擇沒有賬戶？創建一個！

讓我們開始吧！

在這個活動中，您將使用導航窗格和查找和替換對話框。

點擊下面的鏈接打開Microsoft Word練習文檔，您可以使用這個文檔來完成練習。
練習：查找和替換文本
跳轉
點擊查看→導航窗格：
打開的Word文檔，選擇的是查看選項卡
（如果這個命令已經被選中，跳到下一步。）

確保選擇了第一個選項卡（標題），審查文檔中的標題列表：
打開的Word文檔，查看選項卡已經選擇了標題選項

點擊頁面選項卡，查看文檔的不同視圖：
打開的Word文檔，查看選項卡已打開，左側有導航窗口，選擇了頁面選項

查看導航窗格：
打開的導航窗格，顯示了3頁，第二頁被選擇

現在，我們想更新文檔以反映我們的國家（而不是加拿大的項目，這個RFP是基于的）。點擊首頁→替換開始：
打開的Word文檔，選擇了首頁選項卡，點擊了替換選項

查找和替換對話框將打開到替換選項卡。在“查找內容”字段中輸入“加拿大”：

在“替換為”字段中輸入“公民”：

打開的查找和替換窗口，輸入了替換為的內容“公民”

點擊“查找下一個”：
查找和替換窗口，點擊了“查找下一個”
查看此替換的上下文是否有意義，如果有意義，請點擊“替換：”
打開了“查找和替換”窗口，選擇了“替換”選項。

完成接下來的兩個替換。當您到達第一頁的最后一句時，刪除文本而不是替換它：
（您可以在打開“查找和替換”對話框時執行此操作。）

對于下面的兩個實例，請重復刪除操作：
打開“查找和替換”窗口，選擇“目標加拿大社區”段落。

現在，我們可以替換文檔中的所有實例。點擊“全部替換：”
打開了“查找和替換”窗口，選擇了“全部替換”選項。

您應該會收到一個最終替換的通知。點擊“確定”以關閉此對話框：
出現替換通知，選擇“確定”選項。

然后，關閉“查找和替換”對話框：
打開“查找和替換”窗口，選擇關閉選項。

將文檔保存為“活動2-3完成”。關閉Microsoft Word 365以完成此練習。

現在，您可以在下面的鏈接中查看一個完成的文檔示例：

完成的“查找和替換文本”練習文檔

個人補充

其實ctrl+f和ctrl+r即可完成，不用那么麻煩，考試也沒那么多時間去操作

Exercise: Applying character formatting

Note: You can pass this course and all graded assessments without access to the downloadable version of Word.

How to complete this exercise

To complete this exercise, you will need access to Microsoft Word.

Note: Keep in mind that if you are using free Office for the web or another version of the Microsoft Word application some features covered in this exercise may not be available.

Free Office for the web

If you do not have access to Microsoft Word, you can use Free Office for the web. This version of Office allows you to view and edit files in apps like Word, Excel, and PowerPoint. This free service is available to anyone with a Microsoft account.

Access Microsoft Account

Log in to your Microsoft account. Type the email, phone number, or Skype sign-in that you use for other services (Outlook, Office, etc.), then select Next. If you don’t have a Microsoft account, you can select No account? Create one!

Let’s get started!

In this exercise, you will start formatting a sample document.

Click on the link below to open the Microsoft Word exercise document you can use to complete this exercise.

Exercise: Applying Character Formatting

First, let’s set up the formatting for the document titles. Select the text “The Call” on the first page:

The word document opened with the text, second title from the text selected

Click the Font menu on the Home tab. Scroll down in the list and click “Franklin Gothic Medium:”

Font menu tab opened, “Franklin Gothic Medium” chosen

Press Ctrl + Shift + > twice to increase the font size:

Text with the title “The Call” selected

With the text still selected, right-click it and click the Font Color drop-down arrow on the mini toolbar:

Font tab opened with the Font colour selected

Click “Dark Blue:”

The font colour window opened, with the colours options, Dark Blue chosen

With your new title still selected, click Home → Format Painter:

Select the text “What groups are eligible?”

Word document opened with the title “What groups are eligible?” selected
(You may need to scroll down in the document to see this text.)

Both titles will now have the same formatting:

The Word document opened with the title “What groups are eligible?” applied the change
10. Save your document as Activity 3-1 Complete and close Microsoft Word 365.

Now, you can check out an example of a completed document in the link below:

練習：應用字符格式化

注：您可以在沒有下載版本的Word的情況下通過這門課程和所有評分評估。

如何完成這個練習

要完成這個練習，您需要訪問Microsoft Word。

注意：請注意，如果您使用的是免費的Office for the web或其他版本的Microsoft Word應用程序，本練習中涵蓋的一些功能可能無法使用。

免費的Office for the web

如果您無法訪問Microsoft Word，您可以使用免費的Office for the web。這個版本的Office允許您在Word、Excel和PowerPoint等應用程序中查看和編輯文件。這項免費服務對任何擁有Microsoft賬戶的人都是可用的。

訪問Microsoft賬戶

登錄您的Microsoft賬戶。輸入您在其他服務（Outlook、Office等）中使用的電子郵件、電話號碼或Skype登錄名，然后選擇下一步。如果您沒有Microsoft賬戶，可以選擇沒有賬戶？創建一個！

讓我們開始吧！

在這個練習中，您將開始對一個樣本文檔進行格式化。

點擊下面的鏈接打開Microsoft Word練習文檔，您可以使用它來完成這個練習。
Exercise: Applying Character Formatting
首先，讓我們設置文檔標題的格式。在第一頁選擇文本“The Call”：
打開的Word文檔，選擇了文本中的第二個標題

在主頁選項卡中點擊字體菜單。在列表中向下滾動，點擊“Franklin Gothic Medium:”
字體菜單選項卡打開，選擇了“Franklin Gothic Medium”

按下Ctrl + Shift + >兩次，增大字體大小：
選中了標題為“The Call”的文本

仍然選中文本，右鍵點擊它，點擊小工具欄上的字體顏色下拉箭頭：
字體選項卡打開，選擇了字體顏色

點擊“深藍色”：
字體顏色窗口打開，選擇了“深藍色”

在新的標題上仍然選中，點擊主頁→格式刷：

選中文本“哪些群體有資格？”

打開的Word文檔中，選中了標題為“What groups are eligible?”的文本
（您可能需要在文檔中向下滾動以查看此文本。）

現在，兩個標題都將具有相同的格式：
Word文檔中的標題“What groups are eligible?”應用了更改
10. 將文檔保存為“Activity 3-1 Complete”，然后關閉Microsoft Word 365。

Exercise: Displaying text as list items

Note: You can pass this course and all graded assessments without access to the downloadable version of Word.

How to complete this exercise

To complete this exercise, you will need access to Microsoft Word.

Note: Keep in mind that if you are using free Office for the web or another version of the Microsoft Word application some features covered in this exercise may not be available.

Free Office for the web

If you do not have access to Microsoft Word, you can use Free Office for the web. This version of Office allows you to view and edit files in apps like Word, Excel, and PowerPoint. This free service is available to anyone with a Microsoft account.

Access Microsoft Account

Log in to your Microsoft account. Type the email, phone number, or Skype sign-in that you use for other services (Outlook, Office, etc.), then select Next. If you don’t have a Microsoft account, you can select No account? Create one!

Let’s get started!

In this exercise, you will add lists to your sample document.

Click on the link below to open the Microsoft Word exercise document you can use to complete this exercise.

Exercise: Displaying text as list items

First, let’s apply some bullets. Select the three indented lines of text at the top of the document. Click the Bullets drop-down command on the Home tab:

Home tab open with the bullets drop-down option clicked

Click any bullet you like to apply it:

Home tab opened with the bullets option window, a option of the bullets was chosen

The bullets will be applied. Review the changes:

The Word document open with the text and the bullet points changes applied

Select the bullets in the next part of the document:

Word document opened the text with the bullets selected

Right-click the selection. Click the Numbering command on the mini toolbar:

The word document with the bullets text selected the mini toolbar appearing with the numbering option chosen

Review the changes:

The Word document opened with the changes applied in the text
8. Save your document as Activity 3-3 Complete. Close Microsoft Word 365.

練習：將文本顯示為列表項

注意：您可以在沒有下載版的Word的情況下通過本課程和所有評估考試。

如何完成這個練習

要完成這個練習，您需要訪問Microsoft Word。

注意：請記住，如果您使用的是免費的Office在線版或其他版本的Microsoft Word應用程序，本練習中涉及的某些功能可能不可用。

免費的Office在線版

如果您沒有訪問Microsoft Word的權限，您可以使用免費的Office在線版。這個版本的Office允許您在Word、Excel和PowerPoint等應用程序中查看和編輯文件。這個免費的服務對任何擁有Microsoft賬戶的人都是可用的。

訪問Microsoft賬戶

登錄您的Microsoft賬戶。輸入您用于其他服務（Outlook、Office等）的電子郵件、電話號碼或Skype登錄名，然后選擇下一步。如果您沒有Microsoft賬戶，您可以選擇沒有賬戶？創建一個！

讓我們開始吧！

在這個練習中，您將向樣本文檔添加列表。

點擊下面的鏈接，打開Microsoft Word練習文檔，您可以使用它來完成這個練習。
練習：將文本顯示為列表項
首先，讓我們應用一些項目符號。選擇文檔頂部的三行縮進的文本。點擊主頁選項卡上的“項目符號”下拉命令：
打開的主頁選項卡，點擊了“項目符號”下拉選項

點擊任何您喜歡的項目符號以應用它：
打開的主頁選項卡上顯示了“項目符號”選項窗口，選擇了一個項目符號

項目符號將被應用。復審更改：
打開的Word文檔中，文本和項目符號的更改已應用

選擇文檔中下一部分的項目符號：
打開的Word文檔中，選中了下一部分的文本和項目符號

右鍵點擊選中的文本。點擊小工具欄上的“編號”命令：
打開的Word文檔，選中的文本顯示了小工具欄，選擇了“編號”選項

復審更改：
打開的Word文檔中，文本的編號更改已應用

將文檔保存為“Activity 3-3 Complete”。關閉Microsoft Word 365。

Font group commands keyboard shortcuts

字體組命令的鍵盤快捷鍵

常用的
加粗：Ctrl + B
斜體：Ctrl + I
下劃線：Ctrl + U
刪除線：Ctrl + D
字體大小增加：Ctrl + ]
字體大小減小：Ctrl + [
字體顏色：Ctrl + Shift + C
字體背景色：Ctrl + Shift + B
字體大小增加一點：Ctrl + Shift + >
字體大小減小一點：Ctrl + Shift + <

Exercise: Controlling paragraph layout

Let’s get started!

In this exercise, you will modify the alignment, margins, and spacing in our sample document.

Click on the link below to open the Microsoft Word exercise document you can use to complete this exercise.

Exercise: Controlling Paragraph Layout

First, let’s center the title. Make sure your cursor is in the first line of the document. Click Home → Center:

Word document opened with the cursor clicked in the text Home tab selected with the Center alignment icon was chosen

The change will be applied. Notice that the Center alignment icon is now selected:

The Word document opened with the changes applied in the text, and the Center alignment icon is now selected

Now, let’s add some space between the title and the document text. Ensure your cursor is still in the title. On the Home tab, click Line and Paragraph Spacing → Add Spacing After Paragraph:

Home tab opened with the cursor is in the title, Line and Paragraph Spacing clicked, Add Spacing After Paragraph was chosen

Review the results:

The Word document opened with the cursor placed in the middle of the heading

Now, let’s improve the space around the document. Click Layout → Margins → Moderate:

Layout tab opened with the Margins selected and the Moderate option was chosen

Now, click the option button in the Paragraph group to open the Paragraph dialog box:

Layout tab opened with the Paragraph Settings option chosen
(You can perform this command from either the Home or Layout tab.)

Review the settings on the first tab. You should see some of the options that you have applied during this activity. Click “Cancel” when you are finished:

Paragraph window opened with the Alignment text option the cancel button was clicked
9. Save your document as Activity 3-4 Complete. Close Microsoft Word 365.

Now, you can check out an example of a completed document in the link below:

Completed exercise: Controlling Paragraph Layout

練習：控制段落布局

讓我們開始吧！

在這個練習中，您將修改示例文檔中的對齊、邊距和間距。

點擊下面的鏈接打開可以用來完成這個練習的Microsoft Word文檔。

練習：控制段落布局
首先，讓我們將標題居中。確保光標在文檔的第一行。點擊"主頁"→"居中"：
在打開的Word文檔中，光標點擊在文本中，"主頁"選項卡被選中，居中對齊圖標被選擇

更改將被應用。注意到"居中"對齊圖標現在被選中：
在打開的Word文檔中，更改已應用到文本，"居中"對齊圖標被選中

現在，讓我們在標題和文檔正文之間添加一些間距。確保光標仍在標題中。在"主頁"選項卡中，點擊"行和段落間距"→"段落后添加間距"：
在"主頁"選項卡中，光標在標題中，點擊"行和段落間距"，選擇"段落后添加間距"

查看結果：
在打開的Word文檔中，光標位于標題的中間位置

現在，讓我們改善文檔周圍的空間。點擊"布局"→"邊距"→"中等"：
在"布局"選項卡中，"邊距"被選中，選擇"中等"選項

然后，點擊段落組中的選項按鈕，打開段落對話框：
在"布局"選項卡中，選擇段落設置選項
（您可以從"主頁"或"布局"選項卡執行此命令。）

查看第一個選項卡上的設置。您應該看到在這個活動中應用的一些選項。完成后點擊"取消"：
段落對話框打開，對齊文本選項，點擊取消按鈕

將您的文檔保存為"Activity 3-4 Complete"。關閉Microsoft Word 365。

Exercise: Applying borders and shading

Let’s get started!

In this exercise, you will put the finishing touches on our sample document.

Click on the link below to open the Microsoft Word exercise document you can use to complete this exercise.

Exercise: Managing formatting

Select “The Call” heading. Press Shift + F1 to open the Reveal Formatting task pane:

Reveal Formatting task pane opened, “The call” title was selected
(Feel free to resize the task pane if necessary.)

Click the Shading link to open the appropriate dialog box:

Reveal Formatting dialog box opened, Shading link was clicked

The Borders and Shading dialog box will open. Click the Style menu and choose 25%:

Borders and Shading opened, Shading tab was clicked and Style 25% option was chosen

Click “OK:”

Borders and Shading table opened with “OK” button clicked

You will see the changes reflected in the Reveal Formatting task pane and the document:

Reveal Formatting pane opened, the changes was applied in the title

You can now close the pane:

Reveal Formatting pane opened with the close icon in the top right

Click anywhere in the document to de-select the text. Click Home → Replace:

Home table opened, Replace option was chosen

In the Find and Replace dialog box, click the More button:

Find and Replace dialog box opened, More button was clicked

Ensure that your cursor is in the “Find what” field. Click Format → Font:

Find and Replace dialog box opened, drop-down arrow in Format button was clicked, Font was chosen

In the Font dialog box, choose +Body from the Font list and 10 from the Size list. Click “OK:”

The Find Font dialog box opened, +Body option was chosen with the Size 10

Back in the Find and Replace dialog box, move your cursor to the “Replace with” field. (Also, notice that your font choices appear below the “Find what” field.) Click Format → Font:

Find and Replace dialog box opened, Format drop-down arrow option was clicked, Font was chosen

In the Font dialog box, choose Calibri Light from the Font list and 12 from the Size list. Click “OK:”

The Replace Font window opened, the Font Calibri Light chosen with the Size 12

Click “Replace All:”

Find and Replace window opened with the “Replace All” button selected

Microsoft Word should inform you that it has made 16 replacements. Click “OK” in this dialog box:

Microsoft Word alert box opened, with the number of replacements made, with the “OK” button

Close the Find and Replace dialog box:

Find and Replace dialog box opened with the curser placed in “Find what:” section

Review the changes to the document:

The document opened with the changes was applied in the text

Save your document as Activity 3-7 Complete. Close Microsoft Word 365.

練習：應用邊框和底紋

讓我們開始吧！

在這個練習中，您將完成我們的示例文檔的最后一步。

點擊下面的鏈接打開提供的 Microsoft Word 練習文檔：

練習：管理格式
選擇“The Call”標題。按下 Shift + F1 鍵以打開“揭示格式”任務窗格：
揭示格式任務窗格打開，"The Call"標題被選中
（如果需要，可以自由調整任務窗格的大小。）

點擊“底紋”鏈接以打開相應的對話框：
揭示格式對話框打開，點擊底紋鏈接

邊框和底紋對話框將打開。點擊樣式菜單，并選擇 25%：
邊框和底紋對話框打開，點擊底紋選項卡，并選擇樣式 25%

點擊“確定”：
邊框和底紋對話框打開，點擊確定按鈕

您會在“揭示格式”任務窗格和文檔中看到變化：
揭示格式窗格打開，標題中的變化已應用

現在可以關閉窗格：
揭示格式窗格打開，右上角關閉圖標

在文檔中的任意位置點擊以取消選中文本。點擊“首頁”→“替換”：
首頁選項卡打開，選擇替換選項

在“查找和替換”對話框中，點擊“更多”按鈕：
查找和替換對話框打開，點擊更多按鈕

確保光標位于“查找內容”字段中。點擊“格式”→“字體”：
查找和替換對話框打開，點擊格式按鈕的下拉箭頭，選擇字體選項

在字體對話框中，從字體列表中選擇“+Body”，從大小列表中選擇“10”。點擊“確定”：
查找字體對話框打開，選擇了“+Body”字體，大小為10

回到“查找和替換”對話框，將光標移動到“替換為”字段。（同時注意到您的字體選擇出現在“查找內容”字段下面。）點擊“格式”→“字體”：
查找和替換對話框打開，點擊格式按鈕的下拉箭頭，選擇字體選項

在字體對話框中，從字體列表中選擇“Calibri Light”，從大小列表中選擇“12”。點擊“確定”：
替換字體對話框打開，選擇了“Calibri Light”字體，大小為12

點擊“全部替換”：
查找和替換對話框打開，選擇了“全部替換”按鈕

Microsoft Word應該會通知您已經進行了16次替換。點擊對話框中的“OK”按鈕：
Microsoft Word彈出的警告框，顯示替換次數，點擊“OK”按鈕

關閉“查找和替換”對話框：
“查找和替換”對話框打開，光標位于“查找內容”字段

檢查文檔的更改：
文檔已經打開，文本中的更改已應用

將文檔保存為“Activity 3-7 Complete”。關閉Microsoft Word 365。

Exercise: Inserting a table

Click on the link below to open the Microsoft Word exercise document you can use to complete this exercise.

Exercise: Inserting a Table

First, let’s add a Quick Table to the document. Click to place your cursor below the “Key Dates” heading:

Word document opened with the cursor placed below the “Key Dates” subheading

Then, click Insert → Table:

Insert table opened, “Insert” option chosen

From the menu, choose Quick Tables and then click any of the calendar options:

Table menu opened, with the style choices

The table will be inserted. Now, let’s add a table for the first heading. Scroll to the bottom of the document and click to place your cursor under “Total Responses:”

The Word document opened with the table inserted, cursor placed on under “Total Responses” on the bottom of the document

Click Insert → Table. Drag your mouse over the grid to create a 2x5 table. Click to create it:

“Insert” option selected, Table opened with the grid containing the amount of row and columns options for create a table

The table will be inserted:

Table inserted in the Word Document under heading

Fill it out to match the example below by clicking and typing in each cell:

The table was filled with the information
9. Save your document as Activity 4-1 Complete. Close Microsoft Word 365.

練習：插入表格

點擊下面的鏈接以打開Microsoft Word練習文檔，您可以用它來完成這個練習。
點我下載

首先，在文檔中的“關鍵日期”標題下方點擊以放置光標：
在Word文檔中打開，并在“關鍵日期”標題下方放置光標

然后，點擊“插入”→“表格”：
點擊“插入”選項卡，打開表格選項

從菜單中選擇“快速表格”，然后點擊任意日歷選項：
打開表格菜單，顯示樣式選項

表格將被插入。現在，讓我們在第一個標題下添加一個表格。滾動到文檔底部，并點擊以在“總回應數”下方放置光標：
在Word文檔中插入了表格，光標放置在“總回應數”下方

點擊“插入”→“表格”。拖動鼠標在網格上創建一個2x5的表格，并點擊以創建：
選擇“插入”選項卡，打開表格并選擇行列數量以創建表格

表格將被插入：
表格被插入到標題下方的Word文檔中

根據以下示例在每個單元格中點擊并輸入，填寫表格：
表格被填寫了信息

將您的文檔保存為“Activity 4-1 Complete”。關閉Microsoft Word 365。

Exercise: Sorting table data

Let’s get started!

In this exercise, you will sort data in a revenue report.

Click on the link below to open the Microsoft Word exercise document you can use to complete this exercise.

Exercise: Sorting table data

Select the first column of the table:

The word document, with a table, the cursor is placed in the first column

Click Table Tools – Layout → Sort:

Table tools, Layout was clicked and the Sort option was chosen

Ensure that “Period” is displayed in the “Sort by” menu. Click the Type menu and choose “Date:”

Sort dialog table open, in the Sort by option, Period was selected. Type menu was clicked and “Date” option was chosen

Ensure that the “Header row” radio button is selected:

Sort dialog table open, Header row was selected

Click “OK” to perform the sort:

Sort dialog table open, with “OK” button

The data is now sorted in chronological order:

The table was selected with the data sorted chronologically

Save your document as Activity 1-1 Complete. Close Microsoft Word 365 to complete this exercise.

練習：表格數據排序

讓我們開始吧！

在這個練習中，你將對一份收入報表中的數據進行排序。

點擊下面的鏈接打開Microsoft Word練習文檔，你可以使用該文檔完成這個練習。
練習：表格數據排序

選擇表格的第一列：
在Word文檔中，有一個表格，光標位于第一列

點擊“表格工具”-“布局”-“排序”：
點擊“表格工具”-“布局”，選擇“排序”選項

但是我的oiifce2022是在這里

確保“期間”顯示在“排序依據”菜單中。點擊“類型”菜單，并選擇“日期”：
排序對話框打開，選擇“排序依據”為“期間”，點擊“類型”菜單并選擇“日期”選項

確保“標題行”單選按鈕被選中：
排序對話框打開，選擇了“標題行”

點擊“確定”執行排序：
排序對話框打開，有“確定”按鈕

數據現在按照時間順序排序：
表格被選中，數據按照時間順序排序

將文檔保存為“Activity 1-1 Complete”。關閉Microsoft Word 365以完成這個練習。

Exercise: Adding images to a document

Let’s get started!

In this exercise, you will start building a portfolio for a design firm.

Click on the link below to open the Microsoft Word exercise document you can use to complete this exercise.

Note: Click on the links below to open the set of files that you can use to complete this exercise.

Exercise: Adding images to a document

Exercise: Adding images to a document image

First, let’s add an icon to the title page. Ensure your cursor is flashing at the top of the title page. Click Insert → Icons:

The cursor position in the document and the Icons button are highlighted.The cursor position in the document and the Icons button are highlighted.

The Insert Icons dialog box will open.

The Icons dialog box.The Icons dialog box.

Click the arrow on the right to locate and then select the Arts category.

Step 1 indicates the search right icon and step 2 indicates the Arts category.Step 1 indicates the search right icon and step 2 indicates the Arts category.

Scroll down through the icons and click the paintbrush icon to select it. Then, click “Insert:”

Step 1 indicates the vertical scroll bar, step 2 indicates an icon in the menu, and step 3 indicates the Insert button.Step 1 indicates the vertical scroll bar, step 2 indicates an icon in the menu, and step 3 indicates the Insert button.

The icon will be inserted and the Graphics Tools – Format tab will open. On this tab, click Wrap Text → In Front of Text:

The In Front of Text option is highlighted in the Wrap Text dropdown menu.The In Front of Text option is highlighted in the Wrap Text dropdown menu.

Click and drag the icon over to the top right corner of the page:

The icon has been moved to the right side of the document.The icon has been moved to the right side of the document.

Finally, let’s recolor it. Click Graphics Fill → Blue, Accent 2:

A color has been added to the icon from the Graphics Fill dropdown menu.A color has been added to the icon from the Graphics Fill dropdown menu.

Now, let’s add some graphic samples. Scroll to the next page and click to place your cursor on the line after the heading. Then, click Insert → Pictures → This Device:

This Device is highlighted in the Pictures dropdown menu.This Device is highlighted in the Pictures dropdown menu.

Browse to the Lesson 6 folder of your Exercise Files. Select the Exercise: Adding images to a document image file and click “Insert:”

Browse from the Lesson 6 folder opened, Activity 6-2 image file selected and “Insert” was clicked

The image will be inserted and the Picture Tools – Format tab will be displayed:

A picture has been added to the document.A picture has been added to the document.

Now, let’s add a screenshot. Scroll to the last page of the document and click to place your cursor after the heading:

The last page from the word document the cursor was placed after the heading

Open your internet browser and navigate to www.microsoft.com:

The Microsoft webpage is open in a browser window.The Microsoft webpage is open in a browser window.

Switch back to Microsoft Word. Click Insert → Screenshot and click the Internet Explorer image:

The Available window is highlighted in the Insert Screenshot dropdown menu.The Available window is highlighted in the Insert Screenshot dropdown menu.

The image will be inserted:

A screenshot of the Microsoft webpage has been added to the document.A screenshot of the Microsoft webpage has been added to the document.

Save your document as Activity 6-2 Complete and close Microsoft Word 365.

練習：向文檔添加圖像

讓我們開始吧！

在這個練習中，您將開始為一個設計公司建立一個作品集。

點擊下面的鏈接打開 Microsoft Word 練習文檔，您可以使用它來完成這個練習。
注意：點擊下面的鏈接打開一組文件，您可以使用這些文件來完成這個練習。

練習：向文檔添加圖像

練習：向文檔添加圖像圖像

首先，在標題頁上添加一個圖標。確保您的光標在標題頁的頂部閃爍。點擊插入 → 圖標：
文檔中的光標位置和圖標按鈕被突出顯示。文檔中的光標位置和圖標按鈕被突出顯示。

插入圖標對話框會打開。
圖標對話框。圖標對話框。

點擊右側的箭頭，找到并選擇藝術類別。
步驟1指示搜索右側的圖標，步驟2指示藝術類別。步驟1指示搜索右側的圖標，步驟2指示藝術類別。

向下滾動查看圖標，點擊油漆刷圖標以選擇它。然后，點擊“插入”：
步驟1指示垂直滾動條，步驟2指示菜單中的圖標，步驟3指示插入按鈕。步驟1指示垂直滾動條，步驟2指示菜單中的圖標，步驟3指示插入按鈕。

圖標將被插入，圖形工具 - 格式選項卡將打開。在此選項卡上，點擊環繞文本 → 文本前:
“文本前”選項在環繞文本下拉菜單中被突出顯示。“文本前”選項在環繞文本下拉菜單中被突出顯示。

點擊并拖動圖標到頁面的右上角：
圖標已被移動到文檔的右側。圖標已被移動到文檔的右側。

最后，讓我們對其重新上色。點擊圖形填充 → 藍色，強調 2:
從圖形填充下拉菜單中為圖標添加了顏色。從圖形填充下拉菜單中為圖標添加了顏色。

現在，讓我們添加一些圖形示例。滾動到文檔的下一頁，并點擊以將光標放在標題后的一行上。然后，點擊插入 → 圖片 → 此設備:
此設備在圖片下拉菜單中被突出顯示。此設備在圖片下拉菜單中被突出顯示。

瀏覽到你的練習文件中的第六課文件夾。選擇"Exercise: Adding images to a document image"文件，然后點擊"插入"。
從第六課文件夾中選擇了"Exercise: Adding images to a document image"文件，并點擊了"插入"。

圖片將被插入，"圖片工具-格式"選項卡將顯示。
一張圖片已經被添加到文檔中。一張圖片已經被添加到文檔中。

現在，讓我們添加一個屏幕截圖。滾動到文檔的最后一頁，并點擊標題后面放置光標。
光標被放置在文檔的最后一頁標題后面。

打開你的互聯網瀏覽器，導航到www.microsoft.com。
Microsoft網頁在瀏覽器窗口中打開。

切換回Microsoft Word。點擊"插入" → “屏幕截圖”，然后點擊Internet Explorer圖像。
“插入屏幕截圖"下拉菜單中突出顯示了"可用窗口”。

圖像將被插入：
Microsoft網頁的屏幕截圖已被添加到文檔中。

將文檔保存為"Activity 6-2 Complete"，然后關閉Microsoft Word 365。

Exercise: Adjusting image appearance

Let’s get started!

In this exercise, you will try some different image manipulation techniques on your portfolio.

Click on the link below to open the Microsoft Word exercise document you can use to complete this exercise.

Exercise: Adjusting image appearance

Click the image on the first page of the document to select it:

The Word document open with image selected
(Adjust your zoom level if necessary.)

Click the Picture Tools – Format tab. Choose any style you like from the Picture Styles gallery by clicking its thumbnail:

Pictures tools selected, format table was clicked, picture styles options opened, first style was chosen

Scroll to the second page of the document. Click the second logo:

The second page of the Word document was open, second logo was clicked

Let’s change the color of this logo so it matches the document. Click Picture Tools – Format → Color → Turquoise, Accent color 1 Light:

Picture tools was clicked, Format, Color, Turquoise was selected, Accent color 1 light was chosen

Now, hold the Ctrl key and click all three logos to select them:

The Word document open with all three logos selected

Click Picture Tools – Format → Picture Effects → Shadow → Shadow Options:

Picture Tools selected, Format, Picture Effects and Shadow was selected, a pane of the Shadow option was opened

The Format Picture task pane will open to the Effects category, with the Shadow category expanded. Click the Presets button and choose “Perspective Lower Left:”

A format Picture task pane was opened from the Effects category, “Perspective Lower Left” option was chosen

Increase the Distance to 6 pt:

Format Picture pane open, the Distance field typed 6 pt

Review the changes to the logos:

The Word document open, the changes was applied in the three logos

Close the Format Picture task pane:

Format Picture window open with the close option on the top right side

Save your document as Activity 3-2 Complete and close Microsoft Word 365.

練習：調整圖片外觀

讓我們開始！

在這個練習中，您將在您的作品集中嘗試一些不同的圖片處理技巧。

點擊下面的鏈接，打開Microsoft Word練習文檔，您可以使用它來完成這個練習。
練習：調整圖片外觀

點擊文檔第一頁上的圖片，以選中它：
Microsoft Word文檔打開，圖片被選中
（如果需要的話，調整縮放級別。）

點擊圖片工具-格式選項卡。從圖片樣式庫中選擇任何您喜歡的樣式，通過點擊其縮略圖：
選擇了圖片工具，點擊了格式選項卡，打開了圖片樣式選項，選擇了第一個樣式。

滾動到文檔的第二頁。點擊第二個徽標：
Microsoft Word文檔的第二頁被打開，點擊了第二個徽標。

讓我們將這個徽標的顏色更改為與文檔匹配。點擊圖片工具-格式→顏色→青綠色，強調色 1 淺色：
點擊了圖片工具，格式，顏色，選擇了青綠色，強調色 1 淺色。

現在，按住Ctrl鍵，點擊所有三個徽標以選中它們：
Microsoft Word文檔中所有三個徽標都被選中。

點擊圖片工具-格式→圖片效果→陰影→陰影選項：
選擇了圖片工具，格式，圖片效果和陰影，打開了陰影選項的面板。

格式圖片任務窗格將打開到效果類別，其中陰影類別展開。點擊預設按鈕，選擇“透視左下:”
從效果類別打開了格式圖片任務窗格，選擇了“透視左下”選項。

將距離增加到6磅：
格式圖片窗格打開，距離字段輸入6磅。

檢查徽標的更改：
Microsoft Word文檔打開，三個徽標的更改已應用。

關閉格式圖片任務窗格：
格式圖片窗口打開，右上角有關閉選項。

將您的文檔保存為“Activity 3-2 Complete”，然后關閉Microsoft Word 365。

Exercise: Creating text boxes

Let’s get started!

In this exercise, you will add two text boxes to an annual report.

Click on the link below to open the Microsoft Word exercise document you can use to complete this exercise.

Exercise: Creating text boxes

Scroll to the second page of the document. Click to place your cursor anywhere in that page. Then, click Insert → Text Box → Integral Sidebar:

Word document open, Insert option, Text Box and Integral Sidebar were clicked
(The current theme is Integral, so this will help us keep our design consistent.)

The sidebar will be added and the Drawing Tools – Format tab will open:

Word document open, the Side Bar opened

Let’s leave the placeholder text in the sidebar for now, and add a second text box. Scroll to the fourth page and click below the text to place your cursor there:

Word document open, cursor placed at the end or the text

Click Insert → Text Box → Draw Text Box:

Insert table was selected, Text box was clicked and Draw Text Box was chosen.

Click and drag to draw a text box the width of the text, approximately the height shown below:

Word document open with a text box was inserted under the text for “Heading 3”

Click inside the text box and type the information shown below:

Word document open with the text information added inside the box
(If necessary, use the round handles on the text box to resize it.)

Select the first line in the text box. Click the Drawing Tools – Format tab and apply any WordArt style you like to it:

Word document open, Drawing Tools was selected, Format tab was clicked and WordArt style was chosen
9. For now, save your document as Activity 4-1 Complete and close Microsoft Word 365.

練習：創建文本框

讓我們開始吧！

在這個練習中，您將在一份年度報告中添加兩個文本框。

點擊下面的鏈接打開Microsoft Word練習文檔，您可以用它來完成這個練習。
創建文本框的練習文檔

滾動到文檔的第二頁。在該頁的任意位置點擊鼠標左鍵，然后點擊插入選項卡，再點擊“文本框”按鈕下的“Integral Sidebar”選項：
在Microsoft Word中插入Integral Sidebar文本框

（當前主題是Integral，這樣可以保持設計的一致性。）

側邊欄將被添加，并且“繪圖工具 - 格式”選項卡將會打開：
在Microsoft Word中打開側邊欄文本框

現在先保留側邊欄中的占位文本，然后我們再添加一個第二個文本框。滾動到文檔的第四頁，在文本下面點擊鼠標左鍵以放置光標：
在Microsoft Word中放置光標在文本下方

點擊插入選項卡，再點擊“文本框”按鈕下的“繪制文本框”選項：
在Microsoft Word中繪制文本框

點擊并拖動鼠標以繪制一個文本框，使其寬度與文本一致，高度大約如下所示：
在Microsoft Word中繪制文本框

點擊文本框內部并輸入下面所示的信息：
在Microsoft Word中輸入文本框中的信息

（如有必要，可以使用文本框周圍的圓形手柄調整其大小。）

選擇文本框中的第一行文本。點擊“繪圖工具 - 格式”選項卡，并應用您喜歡的任何WordArt樣式：
在Microsoft Word中應用WordArt樣式

現在，將文檔另存為“Activity 4-1 Complete”，然后關閉Microsoft Word 365。

Exercise: Applying a page border and color

Let’s get started!

In this exercise, you will add page formatting to a document.

Click on the link below to open the Microsoft Word exercise document you can use to complete this exercise.

Exercise: Applying a page border and color

First, let’s add a border to the title page. Ensure that your cursor is on that page and then click Design → Page Borders:

Design tab with Page Borders option selected

Choose a 3-D border style:

Borders and Shading dialog box open with 3-D border style chosen

Scroll down in the Style list and choose a double solid line:

Borders and Shading dialog box open, double solid line chosen from the Style section

The Color and Width settings look great, so we will leave those settings at their default options. Click the “Apply to” drop-down menu and choose “This section – first page only:”

Borders and Shading dialog box open, “This section - First page only” selected from Apply to section

Click “OK” to create your border:

Borders and Shading dialog box open, with “OK” button clicked

The border will now be applied to the first page of the document:

Design tab with Title option selected

Now let’s change the page color. Click Design → Page Color → Blue-Gray, Text 2, Lighter 80%:

Design tab with page color option selected

Scroll through the document to view the effects of this formatting change:

The Word document open, with the changes applied to the text

Save your document as Activity 7-1 Complete and close Microsoft Word 365.

練習：應用頁面邊框和顏色

讓我們開始吧！

在這個練習中，您將為文檔添加頁面格式。

點擊下面的鏈接打開Microsoft Word練習文檔，您可以用它來完成這個練習。
練習：應用頁面邊框和顏色

首先，讓我們給標題頁添加一個邊框。確保您的光標在該頁面上，然后點擊"設計"選項卡，再點擊"頁面邊框"：
打開的"設計"選項卡，"頁面邊框"選項已選擇

選擇一個3D邊框樣式：
打開的"邊框和底紋"對話框，選擇了一個3D邊框樣式

在樣式列表中向下滾動，選擇一個雙實線樣式：
打開的"邊框和底紋"對話框，從樣式區域選擇了雙實線樣式

顏色和寬度設置看起來很好，所以我們將保留這些設置的默認選項。點擊"應用于"下拉菜單，選擇"This section – first page only"：
打開的"邊框和底紋"對話框，從"應用于"區域選擇了"This section - First page only"

點擊"確定"以創建您的邊框：
打開的"邊框和底紋"對話框，點擊了"確定"按鈕

邊框現在將應用到文檔的第一頁：
打開的"設計"選項卡，選擇了標題選項

現在讓我們更改頁面顏色。點擊"設計"選項卡，再點擊"頁面顏色"，選擇"藍灰，文本2，更淺 80%"：
打開的"設計"選項卡，選擇了頁面顏色選項

滾動文檔查看這個格式更改的效果：
打開的Word文檔，應用了文本變化

將您的文檔保存為"Activity 7-1 Complete"并關閉Microsoft Word 365。

Exercise: Inserting footnotes and endnotes

Let’s get started!

In this exercise, you will view, add, and modify footnotes. Note that when we refer to a page number, we are referring to the physical location of the page, not the formatted number that appears on the page.

Click on the link below to open the Microsoft Word exercise document you can use to complete this exercise.

Exercise: Inserting Footnotes and Endnotes

Go to the third page of the document. Notice that there is a number by the Solar System heading:

Heading “Solar System” with Foot Note symbol inserted

Move your mouse over this number to see the note attached to it:

The Word document open, cursor is placed on the top of a number, a note appears attached

Now let us add a few sources to the document. Go to page seven of the document. Click to place your cursor at the end of the first paragraph on this page. Click References → Insert Footnote:

References tab open with option “Insert Footnote” selected

The number will be added and you will be taken to the footnote section. Type “Definition from Oxford Dictionary, 2020” without the quotation marks:

Word document with Footnote highlighted
Notice how this endnote is numbered “2” since it is the second one in the document.

Let us modify the format of the footnotes in this document. Click the Footnotes and Endnotes option button in the Footnotes group of the References tab:

Cursor is placed at Footnotes and Endnotes option in the button at the footnotes tab

The Footnote and Endnote dialog box will open. Click the “Number format” menu and choose uppercase Roman numerals:

Footnote and Endnote dialog box open, “Number format” menu chosen, Roman numerals chosen

Click the “Apply changes to” menu and click “Whole document:”

Footnote and Endnote dialog window open, “Whole document” option selected in “Apply changes to” field

Click Apply:

Footnote and Endnote dialog window open, Apply button clicked

The Footnote and Endnote dialog box will close. You will see the formatting of the second footnote change:

Footnote open with the new format applied

Let us make sure that the changes were applied to the first footnote, too. On the References tab, click the Next Footnote drop-down arrow and click Previous Footnote:

References tab with Previous Footnote option selected

You will see that the first footnote has been updated too:

First footnote open with the new format applied
(You may need to move the cursor to see the numbering.)

Save your document as Activity 2-5 Complete. Close Microsoft 365 Word to complete this activity.

練習：插入腳注和尾注

讓我們開始吧！

在本練習中，您將查看、添加和修改腳注。請注意，當我們提到頁碼時，我們指的是頁面的物理位置，而不是頁面上出現的格式化數字。

1.單擊下面的鏈接打開Microsoft Word練習文檔，您可以使用該文檔來完成此練習。

練習：插入腳注和尾注

2.轉到文檔的第三頁。請注意，太陽系標題旁邊有一個數字：

標題“太陽系”，插入腳注符號

3.將鼠標移到此數字上，即可查看其所附的注釋：

Word文檔打開，光標放在一個數字的頂部，并顯示一個注釋

4.現在讓我們為文檔添加一些來源。轉到文檔的第七頁。單擊可將光標放置在此頁面上第一段的末尾。單擊“參考”→ 插入腳注：

打開“參考”選項卡，選擇“插入腳注”選項

5.數字將被添加，您將被帶到腳注部分。鍵入“牛津詞典定義，2020”，不帶引號：

突出顯示腳注的Word文檔

注意這個尾注是如何編號為“2”的，因為它是文檔中的第二個尾注。

6.讓我們修改一下本文件腳注的格式。單擊“引用”選項卡的“腳注”組中的“腳注和尾注”選項按鈕：

光標位于腳注選項卡按鈕中的腳注和尾注選項處

7.“腳注和尾注”對話框將打開。單擊“數字格式”菜單，然后選擇大寫羅馬數字：

打開腳注和尾注對話框，選擇“數字格式”菜單，選擇羅馬數字

8.單擊“將更改應用到”菜單，然后單擊“整個文檔：”

打開腳注和尾注對話框窗口，在“將更改應用到”字段中選擇“整個文檔”選項

9.單擊“應用”：

腳注和尾注對話框窗口打開，單擊“應用”按鈕

10.腳注和尾注對話框將關閉。您將看到第二個腳注的格式更改：

腳注打開并應用新格式

11.讓我們確保這些修改也適用于第一個腳注。在“引用”選項卡上，單擊“下一個腳注”下拉箭頭，然后單擊“上一個腳注：

選中“上一個腳注”選項的“參考”選項卡

12.您將看到第一個腳注也已更新：

打開第一個腳注并應用新格式

（您可能需要移動光標才能查看編號。）

13.將您的文檔保存為“活動2-5完成”。關閉Microsoft 365 Word以完成此活動。

EXCEL

Working with data

Let’s get started!

In this activity, you will use AutoFill and Flash Fill to complete the financial data workbook.

Click on the link below to open the Microsoft Excel exercise document you can use to complete this exercise.

Exercise: Working with data

First, let’s use AutoFill to complete the formulas for the two profit columns. First, select cell G2 and place your cursor over the green AutoFill handle in the bottom right corner of the cell:

Excel workbook open Cell G2 selected, cursor placed over the green AutoFill handle in the bottom right corner of the cell

Click and drag it down to cell G20. This will copy the formula from G2 to all the blank cells, adjusting the cell references in the formula for each row:

Excel workbook open, the Autofill was dragged it down to cell G20

Observe the results:

Excel workbook open, the formula from G20 was copy to all the blank cell

To extend the formula in column I, rather than clicking and dragging the AutoFill handle, simply double-click it. Note that Excel identifies the data pattern and copies the formulas to the end of the data in row 20:

Excel workbook open, Autofill selected in column “I”, the formulas was copy until the end of the data in row 20

Now, use Flash Fill to separate the City and State data from column A into columns B and C. Click in cell B2 and type the City name from cell A2, “Warner”, then click in cell C2 and type the State abbreviation “NH”:

Excel workbook open, Cell B2 clicked and typed “Warner”, C2 clicked and typed “NH”

Now select cell B3, then click Data → Flash Fill:

Excel workbook open, Cell B3 selected, Data clicked and then Flash Fill option

Cells B2 through B20 now contain only the city name from column A. Now click cell C3 and click Data → Flash Fill to repeat the process for the State abbreviations:

Excel workbook open, Cells B2 to B20 contains the cities name from column A, C3 cell clicked, Data selected and Flash Fill

Observe the results:

Excel workbook open, the changes were applied in the document

You can now discard the data in column A by right-clicking on the column header and selecting Delete from the menu:

Excel workbook open, data in column A selected, right-click in column header, small tool box opens, delete option clicked

The data in column A is removed and the remaining data shifts one column to the left. Note that the cell references in your formulas have changed to the new column letters automatically:

Excel workbook open, the data from column is removed, the cell refences from the formulas have changed to the new column

Finally, we need to copy the Scorecard data to its own sheet. Select cells J1 through to L4 by clicking and dragging:

Excel workbook document open, Cells J1 through to L4

Click Home → Copy:

Excel workbook open, Home tab selected, copy option selected

Click the Financial Scorecard worksheet tab:

Excel workbook open, Financial Scorecard worksheet tab selected

Ensure your cursor is in cell A1. Click the Home tab in the ribbon, click on the drop-down arrow of the Paste command, then click the Paste Values icon from the menu:

Excel workbook open, cursor placed in Cell A1, Home tab clicked, drop-down arrow clicked from Paste, Paste Values clicked

The data will be pasted:

Excel workbook open, data pasted
If you select one of the cells in Column C and click in the formula bar, you will notice that the formulas have been replaced by static values. This is because we selected the Values option to prevent the formulas from breaking during the copy process.

Save your workbook as Activity 2-3 Complete. Close Microsoft 365 Excel to complete this activity.

數據工作

讓我們開始吧！

在這個活動中，您將使用自動填充和閃電填充來完成財務數據工作簿。

點擊下面的鏈接打開 Microsoft Excel 練習文檔，您可以使用該文檔來完成此練習。
練習：處理數據

首先，讓我們使用自動填充來完成兩個利潤列的公式。首先選中單元格 G2，將光標放在單元格右下角的綠色自動填充手柄上：
Excel 工作簿打開，選中單元格 G2，將光標放在單元格右下角的綠色自動填充手柄上。

點擊并拖動手柄，將其拖動到單元格 G20。這將把公式從 G2 復制到所有空白單元格，并為每一行調整單元格引用：
Excel 工作簿打開，自動填充手柄被拖動到單元格 G20。

觀察結果：
Excel 工作簿打開，公式從 G20 復制到所有空白單元格。

要擴展列 I 中的公式，而不是點擊并拖動自動填充手柄，只需雙擊它。注意，Excel 會識別數據模式并將公式復制到數據的末尾，即第 20 行：
Excel 工作簿打開，在列 “I” 中選擇自動填充，公式被復制到數據的末尾。

現在，使用閃電填充將列 A 中的城市和州數據分開到 B 列和 C 列。點擊單元格 B2 并在其中輸入來自單元格 A2 的城市名稱 “Warner”，然后點擊單元格 C2 并輸入州的縮寫 “NH”：
Excel 工作簿打開，點擊單元格 B2 并輸入 “Warner”，點擊單元格 C2 并輸入 “NH”。

現在選中單元格 B3，然后點擊 數據→閃電填充：
Excel 工作簿打開，選中單元格 B3，點擊數據，然后選擇閃電填充選項。

現在，單元格 B2 到 B20 中只包含列 A 中的城市名稱。現在點擊單元格 C3，然后點擊 數據→閃電填充，以重復這個過程，將州的縮寫應用到相應的單元格中：
Excel 工作簿打開，單元格 B2 到 B20 包含了列 A 中的城市名稱，點擊單元格 C3，選擇數據，然后點擊閃電填充。

觀察結果：
Excel 工作簿打開，文檔中的變化已應用。

現在，您可以通過右鍵單擊列標題并從菜單中選擇“刪除”來丟棄列 A 中的數據：
Excel 工作簿打開，選擇列 A 中的數據，右鍵單擊列標題，彈出小工具欄，選擇刪除選項

列 A 中的數據將被刪除，剩余的數據會向左移動一列。請注意，公式中的單元格引用會自動更改為新的列字母：
Excel 工作簿打開，列 A 中的數據被刪除，公式中的單元格引用已更改為新的列

最后，我們需要將得分卡數據復制到自己的工作表中。通過點擊并拖動選擇單元格 J1 到 L4：
Excel 工作簿文檔打開，通過點擊并拖動選擇單元格 J1 到 L4

點擊主頁 → 復制：
Excel 工作簿打開，選擇主頁選項卡，選擇復制選項

點擊 Financial Scorecard 工作表選項卡：
Excel 工作簿打開，選擇 Financial Scorecard 工作表選項卡

確保光標位于單元格 A1。點擊主頁選項卡，點擊剪貼板命令的下拉箭頭，然后從菜單中點擊“粘貼值”圖標：
Excel 工作簿打開，將光標放置在單元格 A1，點擊主頁選項卡，點擊剪貼板命令的下拉箭頭，從菜單中點擊“粘貼值”圖標

數據將被粘貼：
Excel 工作簿打開，數據已被粘貼
如果您選擇列 C 中的一個單元格并在公式欄中點擊，您會注意到公式已被靜態值替代。這是因為我們選擇了“值”選項，以防止在復制過程中破壞公式。

將您的工作簿保存為“Activity 2-3 Complete”。關閉 Microsoft 365 Excel 以完成此活動。

Formatting text

Let’s get started!

In this activity, you will format header rows and a title in your worksheet.

Click on the link below to open the Microsoft Excel exercise document you can use to complete this exercise.

Exercise: Formatting text

First, let’s format the header row of the Financial Data sheet. Select Row 1:

Excel workbook open, Row 1 was selected

Click the Increase Font Size button twice:

Excel workbook open, Increase Font Size option clicked twice

The value in the Size menu should now be 14:

Excel workbook open, the size of the font changed to 14

Apply the Bold effect:

Excel workbook open, Bold option selected

Click the drop-down arrow next to the Font Color command:

Excel workbook open, Font color drop-down arrow clicked

Click the Blue swatch in the Standard Colors palette:

Excel workbook open, Standard Colors palette open, Blue Swatch color chosen

Because of the font changes, the data no longer fits in the cells. Press Ctrl + A to select the entire worksheet. Click Home → Format → AutoFit Column Width:

Excel workbook open, entire workbook was selected, Home tab selected, Format and AutoFit Column Width were clicked

Now, let’s copy the header row formatting to the second sheet. Click any cell in Row 1 to select it and click Home → Format Painter:

Excel workbook open, random cell in Row 1 selected, Home tab selected, Format Painter clicked

Click the Financial Scorecard worksheet tab:

Excel workbook open, Financial Scorecard worksheet tab selected

Click cell A1:

Excel workbook open, Cell A1 selected
The formatting will be applied; notice that the Merge & Center formatting option has been removed as part of this process. We will fix this in a later activity.

Save your workbook as Activity 3-1 Complete. Close Microsoft 365 Excel to complete this activity.

格式化文本

讓我們開始吧！

在這個活動中，您將會對工作表中的標題行和標題進行格式化。

點擊下面的鏈接打開Microsoft Excel練習文檔，您可以使用它來完成這個練習。
練習：格式化文本

首先，讓我們格式化“財務數據”工作表的標題行。選擇第一行：
Excel工作簿已打開，選擇了第一行。

點擊“增大字號”按鈕兩次：
Excel工作簿已打開，點擊了“增大字號”選項兩次。

現在，大小菜單中的值應該是14：
Excel工作簿已打開，字體大小已更改為14。

應用“粗體”效果：
Excel工作簿已打開，選擇了“粗體”選項。

點擊“字體顏色”命令旁邊的下拉箭頭：
Excel工作簿已打開，點擊了“字體顏色”下拉箭頭。

在“標準顏色”調色板中，點擊藍色樣本：
Excel工作簿已打開，“標準顏色”調色板已打開，選擇了藍色樣本顏色。

由于字體的更改，數據不再適合單元格中。按Ctrl + A選擇整個工作表。點擊“開始”→“格式”→“自動調整列寬度”：
Excel工作簿已打開，選擇了整個工作表，“開始”選項卡被選擇，“格式”和“自動調整列寬度”被點擊。

現在，讓我們將標題行的格式復制到第二個工作表。點擊第一行的任意單元格來選擇它，然后點擊“開始”→“格式刷”：
Excel工作簿已打開，選擇了第一行的任意單元格，“開始”選項卡被選擇，點擊了“格式刷”。

點擊“財務績效評分卡”工作表標簽：
Excel工作簿已打開，點擊了“財務績效評分卡”工作表標簽。

點擊單元格A1：
Excel工作簿已打開，選擇了單元格A1。將應用格式；請注意，在此過程中，“合并并居中”格式選項已被刪除。我們將在以后的活動中修復它。

將工作簿保存為“Activity 3-1 Complete”。關閉Microsoft 365 Excel以完成這個活動。

Exercise: Formatting cells

Let’s get started!

In this activity, you will improve the appearance and readability of your sales report using borders, fills, and number formatting.

Click on the link below to open the Microsoft Excelexercise document you can use to complete this exercise.

Exercise: Formatting cells

First, let’s apply the proper formatting to our data. The Financial Scorecard worksheet should be open. (If not, click its tab to switch to it.) Select the three cells containing numbers in Column B:

Excel workbook open, the Three cells containing numbers in Column B selected

Click the dollar icon in the Number group of the Home tab and click $ English (United States):

Excel workbook open, dollar icon was clicked, a small pane with options open, $ English (United States) selected

The formatting will be applied. However, we do not need the cents information, so click Decrease Decimal twice:

Excel workbook open, Decrease Decimal option clicked twice

This will remove the decimals from the numbers, but notice that the full value is still available in the formula bar:

Excel workbook open, the decimals was removed from the document, the value appears in the formula bar

Now, switch to the Financial Data worksheet:

Excel workbook open, Worksheet switched to the Financial Data

Select cells D2 through H20:

Excel workbook open, Cells D3 until H20 selected

Click the dollar icon in the Number group of the Home tab and click $ English (United States):

Excel workbook open, Home tab open, dollar icon clicked, small pane open, $ English (United States) option selected

Click the Decrease Decimal button twice to remove the cents values:

Excel workbook open, Decrease Decimal button clicked twice, the cents values removed

Review the results:

Excel workbook open, the changes applied to the document

Finally, let’s make the header row stand out a bit more. Select cells A1 to H1:

Excel workbook open, Cells A1 to H1 selected

Click the Borders drop-down arrow and click Thick Bottom Border:

Excel workbook open, Borders drop- down arrow clicked, Thick Bottom Border selected

The border will be added. Now, click the Fill drop-down arrow and choose the color shown here:

Excel workbook open, the border was added, Fill drop-down arrow clicked, color pane open, a color was chosen

Click any cell to de-select the header row. Review your formatting changes:

Excel workbook open, changes applied in the document

Save your workbook as Activity 3-2 Complete. Close Microsoft 365 Excel to complete this activity.

練習：格式化單元格

讓我們開始吧！

在本練習中，您將使用邊框、填充和數字格式設置來改善銷售報告的外觀和可讀性。

單擊下面的鏈接以打開您可以用來完成此練習的 Microsoft Excel 練習文檔。
練習：格式化單元格

首先，讓我們對數據應用適當的格式設置。應該打開 Financial Scorecard 工作表。（如果沒有，請單擊其選項卡切換到它。）選擇列 B 中包含數字的三個單元格：
Excel 工作簿打開，選擇列 B 中包含數字的三個單元格

單擊主頁選項卡中的數字組中的美元圖標，然后單擊$ English (United States)：
Excel 工作簿打開，單擊美元圖標，打開一個帶有選項的小窗格，選擇$ English (United States)

將應用格式設置。但是，我們不需要美分信息，因此單擊 Decrease Decimal 兩次：
Excel 工作簿打開，單擊 Decrease Decimal 兩次

這將從數字中刪除小數點，但請注意，完整的值仍然可在公式欄中看到：
Excel 工作簿打開，從文檔中刪除了小數位，值在公式欄中顯示

現在，切換到 Financial Data 工作表：
Excel 工作簿打開，切換到 Financial Data 工作表

選擇單元格 D2 到 H20：
Excel 工作簿打開，選擇單元格 D2 到 H20

單擊主頁選項卡中的數字組中的美元圖標，然后單擊$ English (United States)：
Excel 工作簿打開，主頁選項卡打開，單擊數字組中的美元圖標，打開一個小窗格，選擇$ English (United States)

單擊 Decrease Decimal 按鈕兩次以刪除美分值：
Excel 工作簿打開，單擊 Decrease Decimal 按鈕兩次，刪除美分值

查看結果：
Excel 工作簿打開，更改應用于文檔

最后，讓我們使標題行更加突出一些。選擇單元格 A1 到 H1：
Excel 工作簿打開，選擇單元格 A1 到 H1

單擊邊框下拉箭頭，然后單擊 Thick Bottom Border：
Excel 工作簿打開，單擊邊框下拉箭頭，然后單擊 Thick Bottom Border

邊框將被添加。現在，單擊填充下拉箭頭，選擇此處顯示的顏色：
Excel 工作簿打開，添加了邊框，單擊填充下拉箭頭，選擇顏色

點擊任意單元格取消選擇標題行。檢查您的格式更改：
Excel工作簿打開，文檔中的格式更改已生效。

將您的工作簿保存為“Activity 3-2 Complete”。關閉Microsoft 365 Excel以完成此活動。

Exercise: Searching for and replacing data

Let’s get started!

You have been asked to make some changes to the Sales Report. Rather than manually changing every cell you decide to use the Find and Replace tool.

Click on the link below to open the Microsoft Excel exercise document you can use to complete this exercise.

Exercise: Searching for and replacing data

First, you need to replace all of the forward slashes separating the countries and regions with a hyphen. If you have any area of the spreadsheet highlighted, click outside the highlight to cancel it. Click Home → Find & Select → Replace:

Excel workbook open, Home tab selected, Find & select clicked, a small pane open, Replace option selected

Type the forward-slash character (“/”) in the “Find what” field, type space, hyphen, space (“ – “), in the “Replace with” field, then click Replace All:

Find and Replace box open, Find What field typed slash character, Replace With field typed Space hyphen, Replace All selected

An information dialog box will appear indicating that the operation is complete, and 20 replacements were made. Click OK:

Information dialog box open, indicating that the operation is complete, “OK” button selected

Now click on the Email Addresses tab:

Excel workbook open, Email Addresses tab selected

Notice that the forward slashes on this sheet have not been replaced. Click on the Sales Data tab to return to that sheet:

Email Addresses tab open, the replacement was applied in this document. Sales Data tab selected

Now Click the Options button in the Find and Replace dialog box, select Workbook from the Within drop-down menu, then click Replace All:

Find and Replace dialog window open, Options button clicked, Workbook chosen from Within drop down menu, Replace all clicked

Note that the Information dialog box now reports that another 20 replacements have been made, this time on the Email Addresses sheet:

Email Address tab open, information dialog box open indicating how many replacements was made

The next task is to remove any values of zero from the quarterly sales numbers. Switch back to the Sales Data worksheet and replace the contents of the Find what field with a zero (“0”). Next, select the contents of the Replace with field and press Delete. Finally, click Replace All:

Sales Data tab open, Find and Replace window open, Find what field typed “0”, Replace with field deleted, Replace All clicked

Once you have clicked OK to acknowledge the 40 replacements, note that the cells with a value of zero been replaced, and any zeros in the quarterly sales values have also been removed:

Sales data workbook open, the changes were applied

Click the Undo drop-down arrow on the Quick Access toolbar and select the most recent replace action to restore the correct data:

Excel workbook open, at the Quick Access toolbar the Undo drop-down arrow clicked, the most recent replace action selected

Now click to select the Match entire cell contents checkbox and, once again, click Replace All:

Find and Replace dialog box open, Match entire cell contents checkbox selected, Replace All option selected

Now only the six cells that have a zero as the entire cell contents have been replaced:

Excel workbook open, the changes were applied in the document

Click Close to close the Find and Replace dialog box, then save your workbook as Activity 3-4 Complete. Close Microsoft 365 Excel to complete this activity.

練習：搜索和替換數據

讓我們開始吧！

你被要求對銷售報告進行一些更改。而不是手動更改每個單元格，你決定使用查找和替換工具。

點擊下面的鏈接打開Microsoft Excel的練習文檔，你可以使用這個文檔完成練習。
練習：搜索和替換數據

首先，你需要將所有國家和地區之間的斜杠替換為連字符。如果你已經在電子表格中選擇了任何區域，請點擊區域外面取消選擇。點擊首頁→查找和選擇→替換：
Excel工作簿已打開，選擇了首頁選項卡，點擊了查找和選擇，打開了一個小窗格，選擇了替換選項

在“查找內容”字段中鍵入斜杠字符 (“/”)，在“替換為”字段中鍵入空格、連字符、空格（" - “），然后點擊"全部替換”：
查找和替換對話框已打開，查找內容字段輸入斜杠字符，替換為字段輸入空格連字符，選擇全部替換

一個信息對話框將出現，指示操作已完成，并且進行了20次替換。點擊"確定"：
信息對話框打開，指示操作已完成，選擇"確定"按鈕

現在點擊"電子郵件地址"選項卡：
Excel工作簿已打開，"電子郵件地址"選項卡被選中

注意到這個工作表上的斜杠沒有被替換。點擊"銷售數據"選項卡返回到那個工作表：
"電子郵件地址"選項卡已打開，替換未應用在這個文檔中，"銷售數據"選項卡被選中

現在點擊查找和替換對話框中的"選項"按鈕，從"在"下拉菜單中選擇"整個工作簿"，然后點擊"全部替換"：
查找和替換對話框已打開，點擊了選項按鈕，選擇了整個工作簿，點擊了全部替換

注意到信息對話框現在報告又進行了20次替換，這次是在"電子郵件地址"工作表上：
"電子郵件地址"選項卡已打開，信息對話框打開，指示進行了多少次替換

下一個任務是從季度銷售數字中刪除所有的零值。切換回到"銷售數據"工作表，將"查找內容"字段的內容替換為零 (“0”)。接下來，選中"替換為"字段的內容，按下刪除鍵。最后，點擊"全部替換"：

一旦點擊“確定”按鈕確認40個替換操作，注意到具有零值的單元格已被替換，并且季度銷售數據中的任何零值也已被刪除：
打開銷售數據工作簿，更改已應用

點擊快速訪問工具欄上的撤消下拉箭頭，并選擇最近的替換操作以恢復正確的數據：
打開Excel工作簿，點擊快速訪問工具欄上的撤消下拉箭頭，選擇最近的替換操作

現在點擊以選擇“匹配整個單元格內容”復選框，然后再次點擊“全部替換”：
打開查找和替換對話框，選擇“匹配整個單元格內容”復選框，點擊“全部替換”選項

現在只有包含零值的六個單元格被替換：
Excel工作簿中，只有六個包含零值的單元格被替換

點擊“關閉”以關閉查找和替換對話框，然后將工作簿保存為“Activity 3-4 Complete”。關閉Microsoft 365 Excel以完成本次活動。

Refining the page layout and applying print options

Let’s get started!

You need to print a worksheet that shows sales information, but you would like to print it on four pages. Additionally, a page break must appear between the years and the regions. All pages also need title information for each row and column.

Click on the link below to open the Microsoft Excel exercise document you can use to complete this exercise.

Exercise: Refining the Page Layout and Applying Print Options

Insert a manual page break by first selecting cell H1 and then clicking Page Layout → Breaks → Insert Page Break:

Excel workbook open, Cell H1 selected, Page Layout tab selected, Breaks clicked, Insert Page Break option selected.

Insert another manual page break by selecting cell H27 and then clicking Page Layout → Breaks → Insert Page Break:

Excel workbook open, Cell H27 selected, Page Layout tab selected, Breaks clicked, Insert Page Break option chosen

Next, use your cursor to select the D6:K50 range:

Excel workbook open, the Cells D6 to K50 selected

Click Page Layout → Print Area → Set Print Area:

Excel workbook open, the Cells are selected, Page Layout tab selected, Print Area selected, Set Print area option chosen

Next, with the previously selected cell range still selected, click Page Layout → Print Titles:

Page Layout selected, Print Titles option selected

The Page Setup dialog box will now be open to the Sheet tab. Click the cell selector button on the far right of the Rows to repeat at top text box:

Page Setup dialog window open, Cell selector button clicked on the far right of the Rows to repeat at top text box

Your worksheet will now be shown. Click and drag to select rows 1 through 5:

Excel workbook open, the rows 1 through 5 was selected

In the cell selector dialog box, click the cell selector button to return to the Page Setup dialog box, or press Enter:

Page Setup dialog box open, Cell selector button clicked

Back at the Page Setup dialog box, click inside the Columns to repeat at left text box and type “$A:$C”:

Page Setup dialog box open, Columns to repeat at left box text selected, typed “$A:$C”

Click OK to apply the new settings:

Page Setup dialog open, “OK” button clicked

Click File → Print:

File option selected, Print option selected

Examine the preview portion of this screen. You will see that the current worksheet has been divided into four pages. Each page has both column and row titles:

Print dialog window open, workbook appears in the preview area with the changes applied

Save your workbook as Activity 4-2 Complete. Close Microsoft 365 Excel to complete this activity.

完善頁面布局并應用打印選項

讓我們開始吧！

您需要打印一個顯示銷售信息的工作表，但您希望將其打印在四張頁面上。此外，在年份和地區之間需要顯示分頁符。所有頁面還需要每行和每列的標題信息。

點擊下面的鏈接以打開Microsoft Excel練習文檔，您可以使用該文檔完成這個練習。
練習：完善頁面布局并應用打印選項

通過首先選擇單元格H1，然后點擊頁面布局（Page Layout）→ 斷點（Breaks）→ 插入分頁符（Insert Page Break）來插入手動分頁符：
Excel工作簿打開，選中單元格H1，選擇頁面布局（Page Layout）選項卡，點擊斷點（Breaks），選擇插入分頁符（Insert Page Break）選項。

通過選擇單元格H27，然后點擊頁面布局（Page Layout）→ 斷點（Breaks）→ 插入分頁符（Insert Page Break）來插入另一個手動分頁符：
Excel工作簿打開，選中單元格H27，選擇頁面布局（Page Layout）選項卡，點擊斷點（Breaks），選擇插入分頁符（Insert Page Break）選項。

接下來，使用鼠標光標選擇D6:K50范圍：
Excel工作簿打開，選擇了單元格D6到K50。

點擊頁面布局（Page Layout）→ 打印區域（Print Area）→ 設置打印區域（Set Print Area）：
Excel工作簿打開，選擇了單元格范圍，選擇頁面布局（Page Layout）選項卡，選擇打印區域（Print Area），選擇設置打印區域（Set Print Area）選項。

接著，保持之前選擇的單元格范圍選中狀態，點擊頁面布局（Page Layout）→ 打印標題（Print Titles）：
選擇了頁面布局（Page Layout），選擇了打印標題（Print Titles）選項。

現在，頁面設置對話框將打開到“工作表”選項卡。點擊在頂部重復的行的右側的單元格選擇器按鈕：
頁面設置對話框打開，點擊在頂部重復的行的單元格選擇器按鈕。

您的工作表現在會顯示出來。點擊并拖動以選擇從第1行到第5行的行：
Excel工作簿打開，選擇了第1行到第5行的行。

在單元格選擇器對話框中，點擊單元格選擇器按鈕以返回頁面設置對話框，或者按Enter鍵：
頁面設置對話框打開，點擊單元格選擇器按鈕。

在“頁面設置”對話框中，點擊“左側重復的列”文本框，并輸入“$A:$C”：
頁面設置對話框打開，選擇“左側重復的列”文本框，輸入“$A:$C”

點擊“確定”以應用新的設置：
頁面設置對話框打開，點擊“確定”按鈕

點擊“文件” → “打印”：
選擇“文件”選項，點擊“打印”選項

檢查屏幕上的打印預覽部分。您會看到當前的工作表被分成了四頁，每頁都包含列和行的標題：
打印對話框打開，工作簿在預覽區顯示了應用的更改

將您的工作簿保存為“Activity 4-2 Complete”。關閉Microsoft 365 Excel以完成本活動。

Exercise: Using formulas and functions

Let’s get started!

In this activity, you will start working on a rough draft of a sales report.

Click on the link below to open the Microsoft Excel exercise document you can use to complete this exercise.

Exercise: Using formulas and functions

First, we need to set up formulas to calculate the operating profit. Click cell F2:

Excel workbook open, Cell F2 selected

Type an equal sign (=), then, click cell D2:

Excel workbook open, equal sign typed in the Cell F2 field, D2 selected and added in the Cell F2

Type a minus sign (-) and click cell E2:

Excel workbook open, minus sign typed in the Cell F2, Cell E2 selected and added in the Cell F2

Press Enter to complete the formula:

Excel workbook open, the result appears in the Cell F2

We will complete the rest of the column in the next activity. For now, click cell H2 and repeat Steps 2 through 5 to create a formula that subtracts depreciation from the operating profit, to calculate the net profit:

Excel workbook open, Cell H2 selected, Cell F2 and G2 added in the Cell H2

Now, let’s work on our scorecard. Click cell L2, where we want to calculate the average revenue:

Excel workbook open, Cell L2 selected

Click the AutoSum arrow on the Home tab and click Average:

\workbook open, Home tab selected, AutoSum command selected, a small pane open, Average option selected

By default, Excel will select the values in the first part of the row, but this is not what we want. Click and drag to select cells D2 to D20 instead:

Excel workbook open, Cells D2 to D20 selected

Press Enter to complete the formula and calculate the results:

Excel workbook selected, the formula was calculated and appears in L2

Cell L3 should now be selected. This is where we want to display the highest revenue. Let’s use a different method to create this formula. To begin, click Formulas → Insert Function:

Excel workbook open, L3 selected, Formulas tab open, Insert Formula option selected

Ensure that the Most Recently Used category is selected. Then, click the MAX function from the list. Click OK to insert it. If you do not see the MAX function in the Most Recently Used category, change to the Maths category and select it from there.

Insert Function dialog window open, Most Recently Used category selected, Max function chosen and “OK” button clicked

Now, click and drag to select cells D2 to D20:

Excel workbook open, Cells D2 to D20 selected

Click OK to complete the formula and calculate the results:

Function Arguments dialog window open, “OK” button selected

Now, use either the AutoSum command or the Insert Function command to calculate the lowest value in the Expenses column with the MIN function:

Excel workbook open, Cell L4 selected with the MIN function

Let’s double-check the first two values we calculated. Select cells D2 to D20:

Excel workbook open, Cell D2 to D20 selected

Look at the average calculated in the status bar, and compare it to the average calculated using the function:

Excel workbook open, average was calculated in the status bar

However, the MAX function is not shown here. Right-click anywhere on the Status bar, then click to select Maximum in the Customize Status Bar dialog box:

Excel workbook open, right clicked in the status bar, Customize Status Bar dialog open, Maximum option selected

Click anywhere in the Excel window outside of the Customize Status Bar dialog box. The dialog box will close, and you will now see the Max value in the status bar, which should match the result of the Max function:

Excel workbook open, dialog box closed, the Max value appears n the status bar. And match with the result in the Max function

Save your workbook as Activity 2-2 Complete. Close Microsoft 365 Excel to complete this activity.

練習：使用公式和函數

讓我們開始吧！

在這個活動中，你將開始草擬一份銷售報告的初步草稿。

點擊下面的鏈接打開 Microsoft Excel 練習文檔，你可以使用這個文檔來完成本次練習。
練習：使用公式和函數

首先，我們需要設置公式來計算營業利潤。點擊單元格 F2：
Excel 工作簿打開，選擇了單元格 F2

輸入等號（=），然后點擊單元格 D2：
Excel 工作簿打開，單元格 F2 中輸入了等號，選擇了單元格 D2 并添加到單元格 F2 中

輸入減號（-），然后點擊單元格 E2：
Excel 工作簿打開，單元格 F2 中輸入了減號，選擇了單元格 E2 并添加到單元格 F2 中

按下 Enter 鍵完成公式：
Excel 工作簿打開，結果顯示在單元格 F2 中

我們將在下一步完成該列的其余部分。現在，點擊單元格 H2，并重復步驟 2 到 5，創建一個公式，從營業利潤中減去折舊費用，計算凈利潤：
Excel 工作簿打開，選擇了單元格 H2，將單元格 F2 和 G2 添加到單元格 H2 中

現在，讓我們來處理我們的績效評分卡。點擊單元格 L2，這是我們要計算平均營收的地方：
Excel 工作簿打開，選擇了單元格 L2

在主頁選項卡上點擊自動求和箭頭，然后點擊平均值：
Excel 工作簿打開，主頁選項卡選擇，自動求和命令選擇，一個小窗口打開，選擇了平均值選項

默認情況下，Excel 會選擇行的前部分的值，但這不是我們想要的。點擊并拖動選擇單元格 D2 到 D20：
Excel 工作簿打開，選擇了單元格 D2 到 D20

按下 Enter 鍵完成公式并計算結果：
Excel 工作簿選擇，公式計算并顯示在 L2 單元格中

現在，應該選擇單元格 L3。這是我們要顯示最高營收的地方。讓我們使用另一種方法創建這個公式。首先，點擊公式 → 插入函數：
Excel 工作簿打開，選擇了單元格 L3，公式選項卡打開，選擇了插入函數選項

確保選擇了"最近使用的"類別。然后從列表中點擊"MAX"函數。點擊"確定"以插入它。如果在"最近使用的"類別中沒有看到"MAX"函數，可以切換到"數學"類別并從那里選擇。
打開"插入函數"對話框，選擇了"最近使用的"類別，選擇了"MAX"函數，點擊"確定"按鈕。

現在，點擊并拖動以選擇單元格D2到D20：
Excel工作簿打開，選擇了單元格D2到D20。

點擊"確定"以完成公式并計算結果：
"函數參數"對話框打開，選擇了"確定"按鈕。

現在，使用"自動求和"命令或"插入函數"命令來使用"MIN"函數計算"支出"列中的最小值：
Excel工作簿打開，選擇了包含"MIN"函數的單元格L4。

讓我們再次檢查前兩個計算出的值。選擇單元格D2到D20：
Excel工作簿打開，選擇了單元格D2到D20。

查看狀態欄中計算出的平均值，并將其與使用函數計算出的平均值進行比較：
Excel工作簿打開，狀態欄中計算出了平均值。

然而，在這里沒有顯示"MAX"函數。在狀態欄的任何位置右鍵單擊，然后在"自定義狀態欄"對話框中點擊以選擇"最大值"：
Excel工作簿打開，在狀態欄的任何位置右鍵單擊，打開"自定義狀態欄"對話框，選擇了"最大值"選項。

在"Excel"窗口的任何位置單擊以關閉"自定義狀態欄"對話框。對話框將關閉，現在在狀態欄中將顯示"Max"值，應與"Max"函數的結果相匹配：
Excel工作簿打開，對話框已關閉，在狀態欄中顯示了"Max"值，并與"Max"函數的結果相匹配。

將工作簿保存為"Activity 2-2 Complete"。關閉Microsoft 365 Excel以完成此活動。

Exercise: Sort and filter data

Let’s get started!

You have been asked to present the sales report data by state and to exclude all corporate information. You will use Excel 365 sorting and filtering tools to accomplish these tasks.

Click on the link below to open the Microsoft Excel exercise document you can use to complete this exercise.

Exercise: Sort and filter data

Our first task is to sort the data by state. Select cells B2 to B20:

Excel workbook open, Cells B2 to B20 selected

Now, click Home → Sort & Filter → Sort Ascending:

Excel workbook open, Home tab selected, Sort & Filter option selected, Sort Ascending chosen

Select Expand the selection in the Sort Warning dialog box and click Sort:

Sort Warning dialog window open, Expand the selection selected, “Sort” button selected

Review the results:

Excel workbook open, results applied in the document

Now we want to filter out the corporate data. Select any cell within the data and click Data → Filter:

Excel workbook open, random Cell selected containing data, Data tab selected, Filter option selected

Click the drop-down arrow in cell C1 (Office Type):

Excel workbook open, drop-down arrow selected in Cell C1

Click in the checkbox next to Corporate to deselect, then click OK:

Excel workbook open, a small pane open, Checkbox next to Corporate option was deselected, “OK” button selected

Review the results, and note the AutoFilter icon in cell C1, the blue row numbers, and the double lines indicating the hidden cells:

Excel workbook open, the changes were applied

Save your workbook as Activity 2-5 Complete. Close Microsoft 365 Excel to complete this activity.

練習：排序和篩選數據

讓我們開始吧！

您被要求按州對銷售報告數據進行排序，并排除所有公司信息。您將使用Excel 365的排序和篩選工具來完成這些任務。

點擊下面的鏈接打開Microsoft Excel練習文檔，您可以使用它來完成這個練習。
練習：排序和篩選數據

我們的第一個任務是按州對數據進行排序。選擇單元格B2到B20：
Excel工作簿打開，選擇了單元格B2到B20

現在，點擊首頁 → 排序與篩選 → 升序排序：
Excel工作簿打開，選擇首頁選項卡，選擇了排序與篩選選項，選擇了升序排序

在排序警告對話框中選擇擴展選擇，然后點擊排序：
排序警告對話框打開，選擇了擴展選擇，點擊了"排序"按鈕

檢查結果：
Excel工作簿打開，文檔中應用了排序結果

現在我們想要篩選掉公司數據。在數據中選擇任何一個單元格，然后點擊數據 → 篩選：
Excel工作簿打開，選擇了包含數據的任意單元格，選擇了數據選項卡，選擇了篩選選項

點擊單元格C1中的下拉箭頭（Office類型）：
Excel工作簿打開，選擇了單元格C1中的下拉箭頭

在公司選項旁的復選框中點擊以取消選擇，然后點擊確定：
Excel工作簿打開，一個小窗口打開，取消選擇了公司選項旁的復選框，點擊了"確定"按鈕

檢查結果，并注意單元格C1中的自動篩選圖標、藍色的行號和表示隱藏單元格的雙線：
Excel工作簿打開，應用了更改

將您的工作簿保存為"Activity 2-5 Complete"。關閉Microsoft 365 Excel以完成這個練習。

Exercise: Analyzing data using text functions

Let’s get started!

Using some of the text functions that you have learned about in this session, you would like to automate portions of an invoice form to decrease the time needed for data entry.

Click on the link below to open the Microsoft Excel exercise document you can use to complete this exercise.

Exercise: Analyzing Data Using Text Functions

First you would like to find the first initial from the first name that is entered into column A. Click to select cell C2 and type “=LEFT(A2)” into the Formula Bar:

Excel workbook open, Cell C2 selected and typed “=LEFT(A2)” into the Formula Bar

Press the Enter key on your keyboard and you will see that the previously selected cell now displays the initial from the first name (“J” in this case):

Excel workbook open, Enter key pressed ad the previously selected cell now displays the initial from the first name

Next, you need to do the same thing and find the first initial from the last name that is entered into column B. Click to select cell D2 and type “=LEFT(B2)” into the Formula Bar:

Excel workbook open, Cell D2 selected and typed “=LEFT(B2)” into the Formula Bar

Press the Enter key on your keyboard and you will see that the previously selected cell now displays the initial from the last name (“S” in this case):

Excel workbook open, Enter tab pressed, The previously Cell selected now displays the initial from the last name

Now you need to use the TEXTJOIN function to fill in the Full Initials column. Click to select the E2 cell and then type “=TEXTJOIN(,TRUE,C2,D2)” into the Formula Bar:

Excel workbook open, Cell E2 selected and typed “=TEXTJOIN(,TRUE,C2,D2)” into the Formula Bar

Press the Enter key and you will see that the values from cells C2 and D2 have been combined to show the full initials:

Excel workbook open, Enter tab pressed, the values from the Cells C2 and D2 have been combined to show the full initials

Finally, you would like to automatically fill in the shipment method based on the number of characters that appear in the invoice number. If the invoice has more than five characters, then it is designated a rush order and if it is five characters or less, it is a standard order. Select H2:

Excel workbook open, Cell H2 selected

Type “=IF(LEN(G2)>5, “RUSH”, “STANDARD”)” into the Formula Bar.

Excel workbook open, Typed "IF(LEN(G2)>5, “RUSH”, “STANDARD” into the Formula Bar

Press the Enter key on your keyboard and you will see that this particular order is a rush order because its invoice number is more than five characters:

Excel workbook open, Enter key clicked, the “RUSH” word appears in the cell because the number contain more then 5 characters

Use the Auto Fill feature to copy the formulas that you entered during this activity into the adjacent cells in row 3:

Excel workbook open, Auto Fill feature used to copy the formulas into the adjacent Cells in row 3

Save the current workbook as Activity 2-1 Complete and then close Microsoft 365 Excel to complete this exercise.

練習：使用文本函數分析數據

讓我們開始吧！

使用您在本課程中學到的一些文本函數，您希望自動化發票表單的部分內容，從而減少數據輸入所需的時間。

點擊下面的鏈接打開 Microsoft Excel 練習文檔，您可以使用它來完成這個練習。
練習：使用文本函數分析數據

首先，您想要從輸入到 A 列的第一個名字中找到第一個字母。點擊選擇單元格 C2，并在公式欄中鍵入 “=LEFT(A2)”：
Excel 工作簿已打開，選中單元格 C2 并在公式欄中鍵入 “=LEFT(A2)”

按下鍵盤上的 Enter 鍵，您會看到之前選擇的單元格現在顯示了第一個名字的首字母（在這個例子中為 “J”）：
Excel 工作簿已打開，按下 Enter 鍵，之前選中的單元格現在顯示了第一個名字的首字母

接下來，您需要做同樣的事情，找到輸入到 B 列的姓氏的第一個字母。點擊選擇單元格 D2，并在公式欄中鍵入 “=LEFT(B2)”：
Excel 工作簿已打開，選中單元格 D2 并在公式欄中鍵入 “=LEFT(B2)”

按下鍵盤上的 Enter 鍵，您會看到之前選擇的單元格現在顯示了姓氏的首字母（在這個例子中為 “S”）：
Excel 工作簿已打開，按下 Enter 鍵，之前選中的單元格現在顯示了姓氏的首字母

現在您需要使用 TEXTJOIN 函數來填寫 Full Initials 列。點擊選擇單元格 E2，然后在公式欄中鍵入 “=TEXTJOIN(,TRUE,C2,D2)”：
Excel 工作簿已打開，選中單元格 E2 并在公式欄中鍵入 “=TEXTJOIN(,TRUE,C2,D2)”

按下 Enter 鍵，您會看到來自單元格 C2 和 D2 的值已經組合在一起，顯示了完整的首字母：
Excel 工作簿已打開，按下 Enter 鍵，來自單元格 C2 和 D2 的值已經組合在一起，顯示了完整的首字母

最后，根據發票號碼中出現的字符數自動填寫運輸方式。如果發票號碼超過五個字符，則被指定為緊急訂單，如果不超過五個字符，則為標準訂單。選擇 H2：
Excel 工作簿已打開，選擇了單元格 H2

在公式欄中鍵入 “=IF(LEN(G2)>5, “RUSH”, “STANDARD”)”。

按下鍵盤上的回車鍵，您會看到這個特定訂單是一個緊急訂單，因為其發票號碼超過五個字符：
Excel工作簿打開，按下回車鍵，單元格中顯示“RUSH”字樣，因為發票號碼超過五個字符

使用“自動填充”功能將您在此活動中輸入的公式復制到第3行的相鄰單元格中：
Excel工作簿打開，使用“自動填充”功能將公式復制到第3行的相鄰單元格中

將當前工作簿保存為“Activity 2-1 Complete”，然后關閉Microsoft 365 Excel，以完成此練習。

Exercise: Analyzing data using logical functions

Let’s get started!

Click on the link below to open the Microsoft Excel exercise document you can use to complete this exercise.

Exercise: Analyzing Data Using Logical Functions

First you need to fill in the ID column. This data is the first name and last name separated by an underscore (). While you can do this manually, the TEXTJOIN function is built for exactly this type of work. Select cell C5, then, in the Formula Bar, type “=TEXTJOIN(“”,TRUE,A5,B5)”

Excel workbook open, Cell C5 selected, “typed TEXTJOIN(”_“,TRUE,A5<B5)” in the Formula Bar

Press Enter, to enter the formula, then select cell C5 again, hover your cursor over the cell handle until your cursor icon turns into a small black cross:

Excel workbook open, Enter key clicked, Cell C5 selected, cursor was hovered over the cell, a small icon black cross appeared

Double click on the cell handle to automatically copy your formula down the column, to cell C14:

Excel workbook open, Double click on the cell hande, automatically the formula was copied down to the column to cell C14

Next, you need to determine which salespeople are going to receive a bonus. Bonuses are dispensed when the representative exceeds their weekly sales goal, and if their call reports are complete. For this purpose, you can use the AND function. Use your cursor to select cells G5 on the worksheet:

Excel workbook open, Cell G5 selected

Inside the Formula Bar, type “=AND(D5=“Yes”,E5>F5)” and then press Enter:

Excel workbook open, Fomula “=AND(D5=“Yes”,E5>F5)” typed in Formula Bar, Enter Key clicked

Because both logical tests are true, the formula returns the value of TRUE in cell G5. Now drag the AutoFill handle at the bottom right of the cell down to cell G14:

Excel workbook open, in the G5 Cell appeared the word “True”, The AutoFill handle dragged until down to Cell G14

All sales representatives who have met both conditions now show a value of TRUE in this column. To add the bonus amount to column H, first select cells H5 through H14:

Excel workbook open, Cell H5 through H14 selected

Inside the Formula Bar, type “=IF(G5:G14=TRUE,K2, 0)”. Because this is an array function, press Ctrl + Shift + Enter:

Excel workbook open, Formula “=IF(G5:G14=TRUE,K2,0)”, Ctrl plus Shift plus Enter commands clicked

The bonus information has now been calculated for all employees in this worksheet:

Excel workbook open, the bonus information was calculated in the document

Save the current workbook as Activity 2-2 Complete and then close Microsoft 365 Excel to complete this exercise.

練習：使用邏輯函數分析數據

讓我們開始吧！

點擊下面的鏈接打開 Microsoft Excel 練習文檔，你可以使用它來完成這個練習。
練習：使用邏輯函數分析數據

首先需要填寫ID列。這些數據是名字和姓氏之間用下劃線（）分隔的。雖然你可以手動完成，但TEXTJOIN函數正好用于這種類型的工作。選擇單元格C5，然后在公式欄中輸入“=TEXTJOIN(“”,TRUE,A5,B5)”。
Excel工作簿打開，選擇了單元格C5，在公式欄中輸入了“=TEXTJOIN(“_”,TRUE,A5,B5)”

按下Enter鍵，輸入公式，然后再次選擇單元格C5，將光標懸停在單元格手柄上，直到光標圖標變成小黑十字：
Excel工作簿打開，點擊Enter鍵，選擇了單元格C5，將光標懸停在單元格上，出現了小黑十字圖標

雙擊單元格手柄，自動將公式復制到整列，直到單元格C14：
Excel工作簿打開，雙擊單元格手柄，將公式自動復制到整列，直到單元格C14

接下來，你需要確定哪些銷售人員將獲得獎金。當銷售代表超過他們的每周銷售目標，并且他們的通話報告完整時，獎金會發放。為此，你可以使用AND函數。使用光標選擇工作表上的單元格G5：
Excel工作簿打開，選擇了單元格G5

在公式欄中輸入“=AND(D5=“Yes”,E5>F5)”，然后按Enter鍵：
Excel工作簿打開，在公式欄中輸入了“=AND(D5=“Yes”,E5>F5)”，按下Enter鍵

因為兩個邏輯測試都為真，所以公式在單元格G5中返回了TRUE的值。現在將自動填充手柄拖到單元格G14：
Excel工作簿打開，在G5單元格中出現了“True”字樣，將自動填充手柄拖到單元格G14

所有滿足兩個條件的銷售代表現在在這一列中顯示為TRUE的值。要在H列中添加獎金金額，首先選擇單元格H5到H14：
Excel工作簿打開，選擇了單元格H5到H14

在公式欄內輸入“=IF(G5:G14=TRUE,K2,0)”。因為這是一個數組函數，按下Ctrl + Shift + Enter：
Excel工作簿打開，公式欄內輸入“=IF(G5:G14=TRUE,K2,0)”，按下Ctrl + Shift + Enter鍵。

現在，工作表中的所有員工的獎金信息已被計算出來：
Excel工作簿打開，文檔中計算出了獎金信息。

將當前工作簿保存為“Activity 2-2 Complete”，然后關閉Microsoft 365 Excel，完成這個練習。

Exercise: Creating and modifying a table

Let’s get started!

You have decided that because the Weekly Sales & Bonus Payout worksheet will become larger on a weekly basis, it is a good idea to convert the range into a table to facilitate data analysis. You would also like to apply a new table style to it.

Click on the link below to open the Microsoft Excel exercise document you can use to complete this exercise.

Exercise: Creating and Modifying a Table

First, use your cursor to select the A4:G14 cell range:

Excel workbook open, Cells A4 until G14 selected

Next, click Insert → Table:

Excel workbook open, insert tab selected, Table option selected

In the Create Table dialog box, you will see that the range you previously selected is listed inside the “Where is the data for your table?” text box:

Create table dialog window open, with the information that was previous selected inside the text box

Ensure that the “My table has headers” checkbox is checked and click OK:

Create Table dialog window open, My table has headers checkbox was selected, “OK” button selected

You will see that the previously selected range has now been converted into a table:

Excel workbook open, the changes were applied in the document

Now, you need to apply a new table style. With any of the cells inside the table selected, open the Table Design contextual tab. Within the Table Styles group, click the More arrow:

Excel workbook open, Table Design selected, More Arrow was selected n the Table Styles group

A variety of different quick styles to choose from is now displayed. For this example, click Table Style Medium 8:

Excel workbook open, different styles pane open, Table Style medium 8 selected

The new style is now applied to the current table:

Excel workbook open, the style was applied in the document

Save the current workbook as Activity 3-1 Complete and then close Microsoft 365 Excel to complete this exercise.

練習：創建和修改表格

讓我們開始吧！

您決定因為每周銷售和獎金支付工作表的數據范圍將會逐周增大，所以將其轉換為表格以便于數據分析。您還想為表格應用一個新的表格樣式。

點擊下面的鏈接打開Microsoft Excel練習文檔，您可以使用它來完成這個練習。
練習：創建和修改表格

首先，使用光標選擇A4:G14單元格范圍：
打開Excel工作簿，選擇從A4到G14的單元格范圍

接下來，點擊插入（Insert）→ 表格（Table）：
打開Excel工作簿，選擇插入（Insert）選項卡，點擊表格（Table）選項

在創建表格（Create Table）對話框中，您會看到之前選擇的范圍已列在“您的表格數據在哪里？”文本框內：
打開創建表格對話框，之前選擇的信息顯示在文本框內

確保“我的表格具有標題”復選框被選中，然后點擊確定（OK）：
打開創建表格對話框，選中了“我的表格具有標題”復選框，點擊“確定”按鈕

您會看到之前選擇的范圍現在已經被轉換為一個表格：
打開Excel工作簿，文檔中的范圍已經變成了表格

現在，您需要應用一個新的表格樣式。選中表格內的任意單元格，打開表格設計（Table Design）上下文選項卡。在表格樣式（Table Styles）組中，點擊更多箭頭：
打開Excel工作簿，選擇表格設計（Table Design），在表格樣式（Table Styles）組中點擊更多箭頭

現在會顯示出各種不同的快速樣式可供選擇。對于本示例，點擊表格樣式中的Medium 8（中號8）：
打開Excel工作簿，不同樣式的窗格打開，選擇表格樣式中的Medium 8（中號8）

新的樣式現在應用到了當前表格：
打開Excel工作簿，文檔中的表格應用了新的樣式

將當前工作簿保存為“Activity 3-1 Complete”，然后關閉Microsoft 365 Excel以完成這個練習。

Exercise: Creating charts

Let’s get started!

You need to produce a chart that easily demonstrates to your supervisor which salesperson made the most sales in week 1.

Click on the link below to open the Microsoft Excel exercise document you can use to complete this exercise.

Exercise: Creating charts

First, you need to select the dataset with which you would like to work. Use your cursor to select cells C4:C14 and E4:E14. Remember to hold the Ctrl key down when selecting non-adjacent cell ranges:

Excel workbook open, Cells C4 until C14 and E4 until E14 was selected

Next, click Insert → Insert Column or Bar Chart → Clustered Column:

Excel workbook open, Insert tab selected, Insert column or Bar Chart selected, a small pane open, clustered Column chosen

The new chart now appears on the current worksheet, overlapping some of the data:

Excel workbook open, a new chart appears on the document

Click and drag this chart to a location on the worksheet where it is not overlapping anything:

Excel workbook open, the chart was clicked and dragged to a location where was not overlapping anything

Examine the new chart. You will quickly see that Thompson made the most sales in week 1, with Harrison as the next runner up. McCain clearly has some work to do:

Chart open, containing all the information from the Excel workbook

Save the current workbook as Activity 4-1 Complete and then close Microsoft 365 Excel to complete this exercise.

練習：生成圖表

讓我們開始！

您需要生成一個圖表，以便向您的主管清楚地展示哪位銷售人員在第一周銷售最多。

點擊下面的鏈接打開Microsoft Excel練習文檔，您可以使用該文檔完成這個練習。
練習：創建圖表

首先，您需要選擇要使用的數據集。使用光標選擇單元格C4:C14和E4:E14。記住在選擇非相鄰單元格范圍時按住Ctrl鍵：
Excel工作簿已打開，選中了單元格C4到C14和E4到E14

接下來，點擊插入 → 插入柱形圖或條形圖 → 簇狀柱形圖：
Excel工作簿已打開，選中插入選項卡，選擇插入柱形圖或條形圖，打開一個小窗口，選擇了簇狀柱形圖

新的圖表現在出現在當前工作表上，與一些數據重疊：
Excel工作簿已打開，一個新的圖表出現在文檔上

點擊并拖動這個圖表到工作表上沒有重疊任何內容的位置：
Excel工作簿已打開，點擊并拖動圖表到沒有重疊內容的位置

檢查新的圖表。您很快就會看到Thompson在第一周的銷售最多，Harrison是次佳。McCain顯然還有一些工作要做：
打開的圖表，包含了Excel工作簿中的所有信息

將當前工作簿另存為“Activity 4-1 Complete”，然后關閉Microsoft 365 Excel，完成這個練習。

Exercise: Modifying and formatting charts

Let’s get started!

You have created a chart that illustrates the weekly sales made by your sales staff. You would like to improve the look of the chart. Additionally, it looks as though George Jackson’s data has been accidentally left out of the chart.

Click on the link below to open the Microsoft Excel exercise document you can use to complete this exercise.

Exercise: Modifying and formatting charts

Click to select the chart on the current worksheet. You will see the Chart Design and Format contextual tabs appear on the ribbon:

Excel workbook open, the Chart was selected and the Chart Design and Format tabs appears on the ribbon

First, you should add a title to this chart. Click Chart Design → Add Chart Element → Chart Title → Above Chart:

Excel workbook open, Add Char Element selected, small pane open, Chart Title selected, and Above Chart option was chosen

The chart title is now displayed above the data series on the chart:

Chart title was displayed above the data series on the chart

Next, you should add gridlines to make this chart a little easier to read. Click to select the chart and then click the Chart Elements button that appears near the top right-hand corner:

Chart was selected and the was clicked the Chart Elements button that appears near the top right-hand corner

From the menu that appears, check the Gridlines check box:

The chart open and a small pane open, Gridlines option was selected

Major gridlines are now displayed on the chart:

The Chart open, major gridlines was displayed on the chart

Finally, you might as well remove the legend as it is fairly self-evident what this data represents. Click Chart Design → Legend → None:

Excel workbook open, Chart Design option selected, a small pane open, Legend was selected and the None was chosen

Now you need to adjust the color of this chart. Click the Chart Design contextual tab. Within the Chart Styles gallery, click any of the chart styles presented:

Excel workbook open, Chart Design tab selected, a Chart Styles gallery open, a random Chart Style was selected

The new style is now applied to the selected chart:

The changes was applied in the chart

Finally, with the chart selected, click and drag the handle of the highlighted data selection, at the bottom right of cell E13, and drag it down one row:

Excel workbook open, the chart was selected, the bottom right of the cell E13 was selected and dragged down in one row

A column representing the weekly sales of George Jackson will be added to the chart:

Chart open and a new Column representation the weekly sales of George Jackson was added

Save your current workbook as Activity 4-2 Complete and close Microsoft 365 Excel to complete this exercise.

練習：修改和格式化圖表

讓我們開始吧！

您創建了一個圖表，顯示了銷售人員每周的銷售情況。您希望改進圖表的外觀。此外，喬治·杰克遜的數據似乎被意外地遺漏在圖表中。

點擊下面的鏈接打開Microsoft Excel練習文檔，您可以使用該文檔完成本練習。
練習：修改和格式化圖表

點擊選擇當前工作表上的圖表。您將看到圖表設計和格式化上下文選項卡出現在功能區中：
Excel工作簿打開，圖表被選中，圖表設計和格式化選項卡出現在功能區中。

首先，您應該為這個圖表添加一個標題。點擊圖表設計 -> 添加圖表元素 -> 圖表標題 -> 在圖表之上：
Excel工作簿打開，選擇了添加圖表元素，打開了一個小窗格，選擇了圖表標題，并選擇了在圖表之上。

現在，圖表標題顯示在圖表上的數據系列之上：
圖表標題顯示在圖表上的數據系列之上。

接下來，您應該添加網格線，以使這個圖表更加易于閱讀。點擊選擇圖表，然后點擊出現在右上角附近的圖表元素按鈕：
圖表被選中，點擊了出現在右上角附近的圖表元素按鈕。

在出現的菜單中，勾選網格線復選框：
圖表打開，一個小窗格打開，選擇了網格線選項。

現在，主要網格線顯示在圖表上：
圖表打開，主要網格線顯示在圖表上。

最后，您可以刪除圖例，因為這個數據代表的內容相當明顯。點擊圖表設計 -> 圖例 -> 無：
Excel工作簿打開，選擇了圖表設計選項，一個小窗格打開，選擇了圖例，并選擇了無。

現在您需要調整圖表的顏色。點擊圖表設計上下文選項卡。在圖表樣式庫中，點擊任何一個呈現的圖表樣式：
Excel工作簿打開，選擇了圖表設計選項卡，一個圖表樣式庫打開，選擇了一個隨機的圖表樣式。

新的樣式現在被應用到所選的圖表上：
更改已應用到圖表上。

將當前工作簿保存為“Activity 4-2 Complete”，并關閉Microsoft 365 Excel，完成此練習。

Exercise: Apply conditional formatting

Let’s get started!

To help find outliers and trends within a weekly sales and bonus payout worksheet, you need to apply some conditional formatting.

Click on the link below to open the Microsoft Excel exercise document you can use to complete this exercise.

Exercise: Apply Conditional Formatting

To begin, open Exercise: Apply Conditional Formatting from your Exercise Files folder:

Excel workbook open, Activity 1-3

You first want to use color scales to highlight the sales associates that made above average in sales and those that were below average. Use your cursor to select cells D5:D14:

Excel workbook open, Cells D5 until D14 selected

Next, click Home → Conditional Formatting → Color Scales. From the Color Scales gallery, click the first option:

Excel workbook open, Conditional Formatting selected, small pane open Color scales was selected, First option clicked

You will immediately see that those sales associates who have made more than average in sales will be highlighted in green, while those who made below are highlighted in red. Those that were close to the average are a yellow or orange shade:

Excel workbook open, colors applied in the document

Next, you need to create a custom conditional formatting rule that will use an icon set to identify sales associates who met or exceeded their weekly goal, as well as those who met or exceeded the minimum sales goal requirement. Ensure that the D5:D14 range is selected:

Excel workbook open, Cells D5 until D14 selected

Next, click Home → Conditional Formatting → New Rule:

Excel workbook open, home tab selected, Conditional Formatting selected, small pane open, New Rule selected

The New Formatting Rule dialog box will now be displayed. Click to select the “Format all cells based on their values” rule type:

New Formatting Rule window open, “Format all cells based on their values” selected

Within the Edit the Rule Description section, click the Format Style drop-down menu and then click the Icon Sets option:

New Formatting Rule window open, Format Style menu drop-down clicked, Icon Sets option selected

The controls in the Edit the Rule Description section will change to incorporate controls that are relevant to icon sets. On the row that has the green icon, click the Type drop-down menu and then click the Number option:

New Formatting Rule window open, type drop-down menu clicked, Number option selected

On the same row, inside the Value text box, type “15000” (the weekly goal):

New Formatting Rule window open, “1500” was typed inside the Value text box
(Note that you could also reference a cell that contains the value that you need.)

On the row that has the yellow dot icon, click the Type drop-down menu and then click the Number option:

New Formatting Rule window open, Type drop-down menu clicked and the Number option was selected

On the same row, type “10000” (the minimum weekly target) into the Value text box:

New Formatting Rule window open, “10000” value typed into the text box in the same row

With the new custom conditional formatting rule configured, click OK:

New Formatting Rule window open, “OK” button selected

The new rule will now be applied to the selected range of data. (You may need to resize the column so that there is room for the icon set.) In this case you will see sales associates who made or exceeded their goal, those who are slipping below the base goal, and those who have not met either goal type:

Excel workbook open, changes applied in the document
15. Save your work as Activity 1-3 Complete and then close Microsoft Excel 2016.

練習：應用條件格式化

讓我們開始吧！

為了在每周銷售和獎金支付工作表中找到異常值和趨勢，您需要應用一些條件格式化。

點擊下面的鏈接以打開可以用來完成這個練習的 Microsoft Excel 文檔。
練習：應用條件格式化

首先，從您的練習文件夾中打開“練習：應用條件格式化”的 Excel 工作簿：
Excel 工作簿已打開，活動 1-3

您首先要使用顏色比例尺來突出顯示銷售業務員中超過平均銷售額和低于平均銷售額的人員。使用鼠標光標選擇單元格 D5:D14：
Excel 工作簿已打開，單元格 D5 到 D14 已選擇

接下來，點擊首頁 → 條件格式 → 顏色比例尺。從顏色比例尺圖庫中，點擊第一個選項：
Excel 工作簿已打開，選擇了條件格式，小窗口中選擇了顏色比例尺，點擊了第一個選項

您會立即看到那些在銷售額上超過平均值的銷售業務員將被突出顯示為綠色，而那些低于平均值的人將被突出顯示為紅色。接近平均值的人將會是黃色或橙色：
Excel 工作簿已打開，文檔中應用了顏色

接下來，您需要創建一個自定義的條件格式化規則，以使用圖標集來標識達到或超過每周目標的銷售業務員，以及達到或超過最低銷售目標要求的人員。確保選擇了 D5:D14 范圍的單元格：
Excel 工作簿已打開，單元格 D5 到 D14 已選擇

接下來，點擊首頁 → 條件格式 → 新建規則：
Excel 工作簿已打開，選擇了首頁標簽，點擊了條件格式，小窗口中選擇了新建規則

新建格式化規則對話框現在會顯示出來。點擊選擇“根據單元格的值設置格式”的規則類型：
新建格式化規則窗口已打開，選擇了“根據單元格的值設置格式”

在“編輯規則說明”部分，點擊格式樣式下拉菜單，然后點擊圖標集選項：
新建格式化規則窗口已打開，點擊格式樣式下拉菜單，選擇了圖標集選項

在同一行內，點擊數值文本框，并輸入 “15000”（即每周目標銷售額）：
Excel工作簿打開，新格式化規則窗口中，數值文本框輸入 “15000”
（注意，你也可以引用包含所需數值的單元格。）

在帶有黃色圓點圖標的行，點擊類型下拉菜單，并選擇 “數字” 選項：
Excel工作簿打開，新格式化規則窗口中，點擊類型下拉菜單，并選擇 “數字” 選項

在同一行內，輸入 “10000”（即每周最低銷售目標）到數值文本框：
Excel工作簿打開，新格式化規則窗口中，數值文本框輸入 “10000”

配置完成新的自定義條件格式規則后，點擊 “確定”：
Excel工作簿打開，新格式化規則窗口中，點擊 “確定” 按鈕

新的規則現在將應用于選定的數據范圍。（你可能需要調整列寬以便為圖標集留出空間。）在這種情況下，你將看到達到或超過目標銷售額的銷售人員、低于基本目標的銷售人員以及未達到任何目標的銷售人員：
Excel工作簿打開，文檔中應用了更改

將你的工作保存為 “Activity 1-3 Complete”，然后關閉Microsoft Excel 2016。

Exercise: Using data sources

Let’s get started!

You have been asked to create a price list, in Canadian dollars, for some of your company’s products. You will need to update it regularly using the current exchange rate. You first need to import your price list, then create a web query to load and maintain the current exchange rate.

Note: The will need the following activities to complete this exercise:

Exercise: Using Data Sources

Exercise: Using Data Sources_text

Click on the link below to open the Microsoft Excel exercise document you can use to complete this exercise.

Exercise: Using Data Sources

Click Data → From Text/CSV:

Workbook Excel open, Data tab selected, From Textt/CSV selected

The Import Data dialog box will open. Navigate to your activity files and select Exercise: Using Data Sources_text, then click the Import button:

Import Data window open, Activity 6-2.txt file selected, Import button selected

The Get & Transform Data dialog box will open, displaying the data in the source file. If the selection in the Delimiter drop-down list reads --Custom–, and there is an extra header, click to select the Tab option in the Delimiter drop-down list:

Get & Transform Data dialog box open, Delimiter drop-down selected, Tab option selected from the list

With your data properly aligned in the list box, click the Load button:

Get & Transform Data dialog box open, Load button selected

A new worksheet is created and the data from your text file is loaded as a table. The Queries & Connections task pane opens on the right of the screen:

New worksheet created, data from the text file was loaded as a table, The Queries & Connections pane opened on the right.

Click on the Sheet1 tab to make it the active worksheet. Click to select cell A1, then press Ctrl + C to copy the URL of the exchange rate site:

Excel workbook open, Data tab selected, From Web option selected

Now click Data → From Web:

Excel workbook open, Data tab selected, From Web option selected

The From Web dialog box will open. Click to select the URL field, then press Ctrl + V, to paste the URL. Click OK:

From Web window open, The URL field selected, and copied, “OK” button selected

The Navigator dialog box will open. Click to select Table 0 in the list box on the left, confirm the data is present in the Table View window on the right, then click the Load button:

Navigator dialog box open, Table 0 selected from the list, and appears in the Table View on the right, Load button selected

A new worksheet is created and the data from the website is loaded as a table. The query appears under the Exercise: Using Data Sources

Worksheet was created and the data from the website was loaded a a table

Hover your cursor over the web query in the Queries & Connections task pane, then click Edit in the table dialog box that appears:

The cursor hovered the web query in the Queries & Connections pane, a table dialog box appears Edit option selected

The Power Query Editor will launch. Click the filter button to the right of the header of the Country-Currency column, then click to select the Text Filters field and begin typing “Canada”. When Canada-Dollar is the only selected item, click OK:

The Power Query Editor launched, Filter button selected, Text Filters field selected, Canada typed, Canada-Dollar selected

Click the Close and Load command in the Close group of the Home tab:

Excel workbook open, Home table selected, Close and Load selected

You will see that the Web Query table now only displays the Canada-Dollar row of data from the data set:

Excel workbook open, Web Query table displayed Canada-Dollar row from the data set

Click the Sheet2 tab to make it the active sheet, then click to select cell C2. Type the formula “=[@[US Dollars]]*VLOOKUP(“Canada-Dollar”,Sheet3!A:B,2,FALSE)”, then press the Enter key:

Excel workbook open, Sheet 2 tab selected, C2 selected and typed the formula, “Enter” button selected

The table containing the price list will auto complete the formula for every row in the column:

Excel workbook open, table containing the price list that completed the formula for every row in the column

To refresh the data from the website, right-click on the query in the Queries and Connections task pane, then select Refresh:

Queries and Connections pane open, right click, pane opens and Refresh option selected

You can now save your changes as Activity 6-2 Complete and close Microsoft Excel 365 to complete the activity.

練習使用數據源

讓我們開始吧！

您被要求創建一個加拿大元的價格表，以顯示公司部分產品的價格，并需要根據當前匯率定期更新。首先，您需要導入您的價格表，然后創建一個網頁查詢以加載和維護當前的匯率。

注意：完成這個練習需要以下步驟：

練習：使用數據源

練習：使用數據源_文本

點擊下面的鏈接打開 Microsoft Excel 練習文檔，用于完成這個練習。
練習：使用數據源

點擊數據（Data）→ 從文本/CSV（From Text/CSV）：
Excel 工作簿打開，選擇數據選項卡，選擇從文本/CSV選項

導入數據對話框會打開。導航到您的活動文件夾，選擇“練習：使用數據源_文本”文件，然后點擊“導入”按鈕：
打開導入數據窗口，選擇活動6-2.txt文件，點擊導入按鈕

獲取和轉換數據對話框會打開，顯示源文件中的數據。如果分隔符下拉列表中的選擇是“–自定義–”，并且有額外的標題，點擊下拉列表中選擇“Tab”選項：
打開獲取和轉換數據對話框，選擇分隔符下拉列表，選擇列表中的“Tab”選項

確保您的數據在列表框中正確對齊后，點擊“加載”按鈕：
打開獲取和轉換數據對話框，點擊加載按鈕

會創建一個新的工作表，并將文本文件中的數據加載為表格。右側會打開“查詢和連接”任務窗格：
創建新的工作表，將文本文件中的數據加載為表格，右側打開“查詢和連接”窗格。

點擊“Sheet1”選項卡，使其成為活動工作表。點擊選擇單元格A1，然后按Ctrl + C復制匯率網站的URL：
Excel 工作簿打開，選擇數據選項卡，選擇從Web選項

現在點擊數據（Data）→ 從Web：
Excel 工作簿打開，選擇數據選項卡，選擇從Web選項

“從Web”對話框會打開。點擊選擇URL字段，然后按Ctrl + V，將URL粘貼到字段中。點擊“確定”：
打開“從Web”窗口，選擇URL字段，粘貼復制的URL，點擊確定

“導航器”對話框會打開。點擊左側列表框中的Table 0選項，確認數據在右側的表格視圖窗口中顯示，然后點擊“加載”按鈕：
打開導航器對話框，選擇列表中的Table 0選項，數據在右側的表格視圖窗口中顯示，點擊加載按鈕

新建一個工作表，并將從網站加載的數據加載為表格。

將光標懸停在“查詢和連接”任務窗格中的網頁查詢上，然后點擊出現的表格對話框中的“編輯”選項。

Power Query 編輯器將啟動。點擊“Country-Currency”列標題右側的篩選按鈕，然后點擊選擇“文本篩選”字段并開始輸入“Canada”。當只有“Canada-Dollar”被選中時，點擊“確定”。

在“主頁”選項卡的“關閉”組中，點擊“關閉并加載”命令。

現在你會看到 Web 查詢表格中只顯示了數據集中的“Canada-Dollar”行數據。

點擊“Sheet2”選項卡使其成為活動工作表，然后點擊選擇單元格 C2。輸入公式“=[@[US Dollars]]*VLOOKUP(“Canada-Dollar”,Sheet3!A:B,2,FALSE)”，然后按回車鍵。

包含價格列表的表格將自動為列中的每一行完成公式。

要刷新網站上的數據，右鍵點擊“查詢和連接”任務窗格中的查詢，然后選擇“刷新”。

現在可以保存更改為“Activity 6-2 Complete”，并關閉 Microsoft Excel 365，完成該活動。

PPT

Exercise: Building a presentation

Let’s get started!

In this exercise, you will begin building the framework for your annual report presentation.

Click on the link below to open the Microsoft PowerPoint exercise document you can use to complete this exercise.

Exercise: Building a presentation

Exercise: Building a presentation_Outlines

Exercise: Building a presentation_slides

First, you need to add slides from a Microsoft Word outline. Click Home → New Slide drop-down arrow → Slides from Outline:

PowerPoint window open, Home tab selected, New Slide drop-down arrow selected, Slides from Outline selected

Browse to your Exercise Files folder. Locate and select the Activity 2-2 Outline file. Click Insert:

Insert Outline window open, Activity 2-2 Outline file selected, Insert button selected

The slides will be inserted. However, we have inserted an extra slide that we do not need; the marketing report will be presented separately. Right-click this slide (Slide 6) in the Slides pane and click Delete Slide:

PowerPoint window open, Slides were inserted, right-clicked in Slide-6 the small dialog box open, Delete slide selected

Now, select the Detailed Sales Summary slide (Slide 5). Press Ctrl + D three times to create three copies of it:

PowerPoint window open, Detailed Sale Summary slide (Slide 5) selected for create the slide three times

Replace Q1 in the first sales summary slide with “Quarter 1”

PowerPoint window open, in the slide text box selected in the slide, Q1 was replaced to “Quarter 1”

Repeat this step for the next three slides to create slides for Quarters 2, 3, and 4:

PowerPoint window open, Quarters 2, 3 and 4 created

Finally, we need to add boilerplate information to the end of the presentation. Click to select the last slide (Slide 9). Then, click Home → Reuse Slides:

PowerPoint window open, slide 9 selected, Home tab selected, Reuse Slides option selected

In the Reuse Slides pane, Click Browse to locate your Exercise Files folder:

Reuse Slides pane open, Browse option selected

Select the Activity 2-2 Slides file. Click Choose Slides:

Choose Slide window open, Activity 2-2 slides file selected, Choose Slides button selected

Click Insert Slide on the first slide in the Reuse Slides pane:

Reuse slides pane open, Insert slide option selected
(If you want to keep the original formatting, check the Use Source formatting box.)

The slides will be inserted using the presentation’s theme:

PowerPoint window open, the slides were inserted using the presentation’s theme
Repeat this step for the second slide.

Close the Reuse Slides pane:

Reuse slides pane open, X option selected to close the pane

To ensure that the formatting is correct, ensure that any slide in the Slides pane is selected. Then, click Home → Select → Select All:

A random slide was selected, Home tab selected, select clicked, and Select All option chosen

With all slides now selected, click the Reset command on the Home tab:

PowerPoint window open, all slides were selected, Home tab selected, Reset option selected

Review the formatting changes:

PowerPoint window open, the changes were applied in the document

Save your presentation as Activity 2-2 Complete. Close Microsoft 365 PowerPoint to complete this activity.

練習：構建演示文稿

讓我們開始吧！

在這個練習中，您將開始構建年度報告演示文稿的框架。

點擊下面的鏈接，打開Microsoft PowerPoint練習文檔，您可以使用它來完成這個練習。
練習：構建演示文稿

練習：構建演示文稿_大綱

練習：構建演示文稿_幻燈片

首先，您需要從Microsoft Word的大綱中添加幻燈片。點擊首頁 → 新建幻燈片下拉箭頭 → 從大綱添加幻燈片：
PowerPoint窗口打開，首頁選中，新建幻燈片下拉箭頭選中，從大綱添加幻燈片被選中

瀏覽到您的練習文件夾。找到并選擇Activity 2-2 Outline文件。點擊插入：
插入大綱窗口打開，選擇了Activity 2-2 Outline文件，點擊插入按鈕

幻燈片將被插入。然而，我們插入了一個多余的幻燈片，我們不需要它；市場報告將會單獨呈現。在幻燈片窗格中右鍵點擊這個幻燈片（幻燈片6）并點擊刪除幻燈片：
PowerPoint窗口打開，幻燈片被插入，右鍵點擊了幻燈片6，小對話框中選擇了刪除幻燈片

現在，選擇詳細的銷售摘要幻燈片（幻燈片5）。按Ctrl + D三次，創建三個副本：
PowerPoint窗口打開，選擇了詳細的銷售摘要幻燈片（幻燈片5），按Ctrl + D三次創建了三個副本

在第一個銷售摘要幻燈片中將Q1替換為“Quarter 1”：
PowerPoint窗口打開，在幻燈片的文本框中選擇了Q1，并將其替換為"Quarter 1"

重復這一步驟，為接下來的三個幻燈片創建第二、三、四季度的幻燈片：
PowerPoint窗口打開，創建了第二、第三和第四季度的幻燈片

最后，我們需要在演示文稿末尾添加模板信息。點擊選擇最后一張幻燈片（幻燈片9）。然后，點擊首頁 → 重復使用幻燈片：
PowerPoint窗口打開，選擇了幻燈片9，首頁選中，重復使用幻燈片選項被選中

在"重復使用幻燈片"窗格中，點擊"瀏覽"按鈕，定位到你的"練習文件"文件夾：
"重復使用幻燈片"窗格打開，選擇"瀏覽"按鈕

選擇"Activity 2-2 Slides"文件，點擊"選擇幻燈片"：
"選擇幻燈片"窗口打開，選擇"Activity 2-2 Slides"文件，點擊"選擇幻燈片"按鈕

在"重復使用幻燈片"窗格的第一張幻燈片上點擊"插入幻燈片"：
"重復使用幻燈片"窗格打開，選擇第一張幻燈片，點擊"插入幻燈片"選項
（如果想保留原始格式，請勾選"使用源格式"框。）

幻燈片將使用演示文稿的主題進行插入：
PowerPoint窗口打開，幻燈片使用演示文稿的主題進行插入
重復這一步驟來插入第二張幻燈片。

關閉"重復使用幻燈片"窗格：
"重復使用幻燈片"窗格打開，點擊"X"選項來關閉窗格

為了確保格式正確，確保在幻燈片窗格中選擇任意一張幻燈片。然后，點擊"主頁"→"選擇"→"全選"：
隨機選擇一張幻燈片，選擇"主頁"選項卡，點擊"選擇"，選擇"全選"選項

當所有幻燈片都被選中時，點擊主頁選項卡上的"重置"命令：
PowerPoint窗口打開，所有幻燈片被選中，選擇"主頁"選項卡，點擊"重置"選項

檢查格式變化：
PowerPoint窗口打開，對文檔的格式變化進行檢查

將你的演示文稿保存為"Activity 2-2 Complete"。關閉Microsoft 365 PowerPoint以完成這個任務。

Exercise: Laying out a presentation

Let’s get started!

In this exercise, you will modify the layout and appearance of your annual report presentation.

Click on the link below to open the Microsoft PowerPoint exercise document you can use to complete this exercise.

Exercise: Laying out a presentation

First, let’s change the layout of a few of the slides. Click to select Slide 5 in the Slides pane. Hold down the Shift key and click Slide 8. (You may need to scroll down in the Slides pane to see this slide.) This will select all four slides:

PowerPoint window open, Slide 5 until slide 8 selected

Now, click Home → Layout → Title and Content:

PowerPoint window open, Home tab clicked, Layout option selected, Title and Content option chosen

This will change the layout of all four slides to include a content placeholder instead of a text placeholder. This is perfect as each slide will include a chart in the future:

PowerPoint window open, the layout was applied in the four slides

Now let’s change the theme. Click anywhere in the PowerPoint window to de-select the sales summary slides. Select any slide and click the Design tab:

PowerPoint window open, the slides was deselected, a random slide was selected, Design tab selected

Click the More arrow in the Themes gallery:

Design tab open, More arrow selected in Themes gallery

Move the mouse over some of the thumbnails in the gallery. As you do this you will see a preview applied to the current slide:

PowerPoint window open, the thumbnails gallery open with the preview layout view

Click the Frame theme to apply it:

Theme gallery open, Frame option was selected

Preview some of the variants for this theme by moving your mouse over the thumbnails in the Variants gallery:

PowerPoint window open, theme was applied, gallery Variants open in the top of the window

Finally, let’s create a background style for the title slide. Click to select Slide 1 in the Slides pane. Then, click the More arrow in the Variants group on the Design tab:

Design tab open, slide 1 selected, the More arrow in the Variants group clicked

Click Background Styles from the expanded gallery:

Gallery open, Background Styles clicked

Right-click Style 11 and click Apply to Selected Slides:

Variants gallery open, right-clicked in the style 11, Apply to Selected Slides option selected

Let’s check out the settings for this style. Click Design → Format Background:

Design tab selected, Format Background option chosen

The Format Background task pane will open and show the details for the gradient fill that is applied. Click the Type menu and click Shade from title:

Background task pane open, with the details of the gradient fill, Type menu clicked, Shade from title selected

Observe your changes:

PowerPoint window open, changes applied

Save your presentation as Activity 2-3 Complete. Close Microsoft 365 PowerPoint to complete this activity.

練習：演示文稿的布局

讓我們開始吧！

在這個練習中，您將修改年度報告演示文稿的布局和外觀。

點擊下面的鏈接，打開Microsoft PowerPoint練習文檔，您可以使用它來完成這個練習。
練習：演示文稿的布局

首先，讓我們修改幾個幻燈片的布局。在幻燈片窗格中點擊選擇第5張幻燈片。按住Shift鍵點擊第8張幻燈片。（您可能需要在幻燈片窗格中向下滾動才能看到這張幻燈片。）這將選擇這四張幻燈片：
PowerPoint窗口打開，選擇了從第5張幻燈片到第8張幻燈片。

然后，點擊首頁→布局→標題和內容：
PowerPoint窗口打開，點擊了首頁標簽，選擇了布局選項，選擇了標題和內容選項。

這將把這四張幻燈片的布局更改為包含內容占位符而不是文本占位符。這非常適合，因為每張幻燈片將來都會包含一個圖表：
PowerPoint窗口打開，布局在這四張幻燈片上被應用。

現在讓我們更改主題。在PowerPoint窗口的任何地方點擊以取消選擇銷售總結幻燈片。選擇任何一張幻燈片，并點擊設計標簽：
PowerPoint窗口打開，幻燈片被取消選擇，隨機選擇了一張幻燈片，選擇了設計標簽。

點擊主題庫中的更多箭頭：
設計標簽打開，主題庫中選擇了更多箭頭。

將鼠標移到主題庫中的一些縮略圖上。在這樣做時，您將看到當前幻燈片上應用的預覽：
PowerPoint窗口打開，縮略圖庫中顯示了預覽布局。

點擊“Frame”主題以應用它：
主題庫打開，選擇了“Frame”選項。

通過將鼠標移到變體庫中的縮略圖上，預覽一些該主題的變體：
PowerPoint窗口打開，主題已應用，頂部打開了變體庫。

最后，讓我們為標題幻燈片創建一個背景樣式。在幻燈片窗格中點擊選擇第1張幻燈片。然后，在設計標簽的變體組中點擊更多箭頭：
設計標簽打開，選擇了幻燈片1，點擊了變體組中的更多箭頭。

從展開的庫中點擊“背景樣式”：
庫打開，點擊了“背景樣式”。

右鍵點擊樣式11，選擇“應用于選定幻燈片”：
打開變體畫廊，右鍵點擊樣式11，在選項中選擇“應用于選定幻燈片”

讓我們查看此樣式的設置。點擊“設計”→“格式背景”：
選擇“設計”選項卡，點擊“格式背景”選項

格式背景任務窗格將打開，并顯示應用的漸變填充的詳細信息。點擊“類型”菜單，選擇“從標題漸變”：
打開背景任務窗格，顯示漸變填充的詳細信息，點擊“類型”菜單，選擇“從標題漸變”

觀察您的更改：
PowerPoint窗口中顯示應用的更改

將您的演示文稿保存為“活動2-3完成”。關閉Microsoft 365 PowerPoint以完成此活動。

Exercise: Creating SmartArt

Let’s get started!

A presentation that you are working on needs some SmartArt to help explain your company’s organizational structure.

Click on the link below to open the Microsoft PowerPoint exercise document you can use to complete this exercise.

Exercise: Creating SmartArt

Display slide four. Click the Insert SmartArt Graphic placeholder in the center of this slide:

PowerPoint window open, Slide 4 was displayed, Insert SmartArt Graphic selected

The Choose a SmartArt Graphic dialog box will now be displayed. Select the Hierarchy category and then click the Organization Chart option. Click OK:

SmartArt Graphic dialog box open, Hierarchy was selected, Organization Chart option clicked, Ok button selected

A SmartArt graphic will now appear on the current slide using the type that you selected:

Slide 4 open, the SmartArt graphic appears in the slide using the type that was selected

Inside the Text pane, type “President” beside the first bullet point. You will see this text appear inside the associated shape in the graphic:

PowerPoint window open, “President” word was typed inside the Text pane
(If the Text pane is not visible, click SmartArt Design → Text Pane.)

Complete the graphic to match the image below:

PowerPoint window open, the graphic was completed

Now you would like to change the color of this graphic. With the SmartArt graphic still selected, click SmartArt Design → Change Colors → Transparent Gradient Range – Accent 3:

PowerPoint open, SmartArt Design tab selected, Change Colors selected, Transparent Gradient Range - Accent3 option chosen

The SmartArt graphic should now look like this:

Slide 4 open, the changes was applied in the slide

Save the current presentation as Activity 3-1 Complete. Close Microsoft 365 PowerPoint.

練習：創建智能圖形

讓我們開始！

你正在編輯的演示文稿需要一些智能圖形來幫助解釋你公司的組織結構。

點擊下面的鏈接，打開Microsoft PowerPoint的練習文檔，用于完成這個練習。
練習：創建智能圖形

顯示第四張幻燈片。點擊中央的“插入智能圖形”占位符：
打開PowerPoint窗口，顯示第四張幻燈片，選擇插入智能圖形占位符

現在會顯示“選擇智能圖形”對話框。選擇“層次結構”類別，然后點擊“組織圖”選項。點擊“確定”：
打開智能圖形對話框，選擇層次結構，點擊組織圖選項，點擊確定按鈕

現在在當前幻燈片上會出現一個智能圖形，使用你選擇的類型：
打開第四張幻燈片，智能圖形在幻燈片上顯示，使用之前選擇的類型

在文本窗格中，輸入“President”在第一個項目符號旁邊。你會看到這個文本出現在圖形中相應的形狀內：
打開PowerPoint窗口，文本窗格中輸入“President”
(如果文本窗格不可見，點擊智能圖形設計 → 文本窗格。)

完成圖形，使其與下面的圖像匹配：
打開PowerPoint窗口，圖形已完成

現在你想要更改這個圖形的顏色。仍然選擇智能圖形，點擊智能圖形設計 → 更改顏色 → 透明漸變范圍 - 強調3：
打開PowerPoint窗口，選擇智能圖形設計選項卡，選擇更改顏色，選擇透明漸變范圍 - 強調3選項

現在智能圖形應該看起來像這樣：
打開第四張幻燈片，已應用更改

將當前演示文稿保存為“Activity 3-1 Complete”。關閉Microsoft 365 PowerPoint。

Exercise: Grouping objects

Let’s get started!

In this activity, you will improve the layout of the images in our product overview slide.

Click on the link below to open the Microsoft PowerPoint exercise document you can use to complete this exercise.

Exercise: Grouping objects

Click slide 3:

PowerPoint window open, Slide 3 selected

Hold down the Ctrl key and click both of the images on the left-hand side of the slide to select them:

Slide 3 open, both images on the left-hand side was selected

Right-click the selection and click Group → Group:

Right-clicked , a small pane open, Group option selected, group selected

Click and drag to move the new group upwards and to the left so that both images are on the slide:

Slide 3 open, the images was grouped

With the group still selected, click Home → Arrange → Ungroup:

The images group was selected, Home tab selected, Arrange selected, a small pane opens, Ungroup option selected

Now the images will appear as two separate objects:

The images were separated

With either object (or both objects) selected, click Picture Format → Group → Regroup to restore the group:

The both images was selected, Picture Format selected, group option selected, Regroup was chosen

Save your presentation as Activity 5-3 Complete. Close Microsoft 365 PowerPoint to complete this activity.

練習：對象分組

讓我們開始吧！

在這個活動中，您將改進產品概述幻燈片中圖片的布局。

點擊下面的鏈接以打開包含 Microsoft PowerPoint 練習的文檔。
練習：對象分組

點擊幻燈片 3：
打開了 PowerPoint 窗口，選中了幻燈片 3。

按住 Ctrl 鍵，并點擊幻燈片左側的兩個圖片以選擇它們：
在幻燈片 3 上，通過按住 Ctrl 鍵點擊左側的兩個圖片，將其選中。

右鍵點擊選中的圖片，選擇“組合”→“組合”：
右鍵點擊選中的圖片，在彈出的菜單中選擇“組合”→“組合”。

點擊并拖動新的組合向上和向左移動，使兩個圖片都在幻燈片上：
通過點擊并拖動新的組合對象，將其向上和向左移動，使兩個圖片都放置在幻燈片上。

仍然選中組合對象，點擊“首頁”→“排列”→“取消組合”：
仍然選中組合對象，點擊“首頁”選項卡，選擇“排列”選項，然后選擇“取消組合”。

現在，圖片將作為兩個單獨的對象顯示：
現在，兩個圖片將作為兩個單獨的對象顯示。

選中任何一個對象（或兩個對象都選中），點擊“圖片格式”→“組合”→“重新組合”以恢復組合：
選中任何一個對象（或兩個對象都選中），點擊“圖片格式”選項卡，選擇“組合”選項，然后選擇“重新組合”。

將您的演示文稿保存為“Activity 5-3 Complete”。關閉 Microsoft 365 PowerPoint 以完成這個活動。

Exercise: Arranging objects

Let’s get started!

In this activity, you will finalize the layout of the images on the product overview slide.

Click on the link below to open the Microsoft PowerPoint exercise document you can use to complete this exercise.

Exercise: Arranging objects

First, let’s set up the grid to help us arrange the images. Click the View tab and click the option button in the Show group:

PowerPoint window open, View tab selected, the option button in the Show group was selected

The Grid and Guides dialog box will open. Ensure that the checkbox in the Snap to section is checked. As well, check the Display grid on screen option. Click OK:

Grid and Guides window open, Snap to section was checked, and Display grid on screen too, “OK” button selected

The grid will now be displayed. Click slide 3:

Grid was displayed, Slide 3 selected

Click the gray gear image. Click Picture Format → Bring Forward:

Grey gear image selected, Picture Format selected, Bring Forward command selected

This image will now be displayed on top of the transparent image:

The mage was displayed on top of the transparent image

Click and drag down the transparent image (in the lower left-hand corner) until it is aligned with the grid. (Ensure that the right-hand guide stays in position.) Release your mouse button when the image is in position:

The transparent image was aligned with the grid

Now, we can turn off the grid. Click the View tab:

PowerPoint window open, View tab selected

Uncheck the Gridlines box in the Show group:

The Gridlines box was uncheck in the Show group

This activity is now complete. Save your presentation as Activity 5-4 Complete and close Microsoft 365 PowerPoint.

練習：排列對象

讓我們開始吧！

在這個活動中，您將完成產品概覽幻燈片上圖像的布局。

點擊下面的鏈接以打開包含練習的 Microsoft PowerPoint 文檔，您可以使用它來完成這個練習。
練習：排列對象

首先，讓我們設置網格，以幫助我們排列圖像。點擊“查看”選項卡，然后點擊“顯示”組中的選項按鈕：
PowerPoint 窗口打開，選擇“查看”選項卡，然后選擇“顯示”組中的選項按鈕。

網格和參考線對話框將打開。確保“捕捉到”部分的復選框已被選中。同時，選中“在屏幕上顯示網格”選項。點擊“確定”：
網格和參考線對話框打開，確認“捕捉到”部分被選中，同時選中“在屏幕上顯示網格”選項，點擊“確定”。

網格現在將顯示出來。點擊幻燈片 3：
網格顯示出來，選擇幻燈片 3。

點擊灰色的齒輪圖像。點擊“圖片格式”→“上移一層”：
選擇灰色的齒輪圖像，點擊“圖片格式”，選擇“上移一層”命令。

現在，這個圖像將顯示在透明圖像的上面：
圖像顯示在透明圖像的上面。

點擊并拖動透明圖像（位于左下角），直到與網格對齊。（確保右側的參考線保持不動。）當圖像對齊時釋放鼠標按鈕：
透明圖像與網格對齊。

現在，我們可以關閉網格。點擊“查看”選項卡：
PowerPoint 窗口打開，選擇“查看”選項卡。

在“顯示”組中取消選中“網格線”復選框：
在“顯示”組中取消選中“網格線”復選框。

這個活動現在已經完成。將您的演示文稿保存為“Activity 5-4 Complete”，然后關閉 Microsoft 365 PowerPoint。

Exercise: Animating objects

Let’s get started!

In this activity, you will finalize the layout of the images on the product overview slide.

Click on the link below to open the Microsoft PowerPoint exercise document you can use to complete this exercise.

Exercise: Animating objects

Click slide 2:

PowerPoint window open, Slide 2 selected

Select the bullet list:

The bullet list was selected in the slide

Click the Animations tab and click the Fade animation:

Animations tab selected, Fade animation selected

Click Animations → Animation Pane:

Animations selected, Animation Pane option clicked

We will use this task pane to customize our animation. Click the listing for the second bullet:

The second bullet selected in the animation pane

Click the drop-down arrow next to this item:

The animation pane open, drop-down arrow next to the second item was selected

Click Start After Previous:

Animation Pane open, a small pane opens, Start After Previous selected

You will see the small box representing the effect move slightly to the right, to indicate it will appear after the first bullet. Repeat steps six, seven, and eight for the next two bullets so that they are all in sequence:

Animation Pane open, The small box representing the effect moved slightly to the right, the step was repeated in 6, 7, and 8

Click the first animation to select it. Click Play From to test the animation:

Animation Pane open, first animation selected, Play From selected

When the preview is complete, close the Animation Pane:

The animation Pane was closed

Select the bullet list. Click Animations → Animation Painter:

Slide 2 open, bullet list selected, Animations selected, Animation Painter option selected

Click slide 4. Click the text box containing the bullet list:

Slide 4 selected, The text box containing the bullet list was clicked

The custom animation will immediately be applied and previewed:

The custom animation was applied and previewed

Save your presentation as Activity 5-5 Complete. Close Microsoft 365 PowerPoint to complete this activity.

練習：為對象添加動畫效果

讓我們開始吧！

在這個活動中，你將完成產品概述幻燈片上圖片的布局。

點擊下面的鏈接，打開 Microsoft PowerPoint 練習文檔，用于完成這個練習。
練習：為對象添加動畫效果

點擊幻燈片2：
打開 PowerPoint 窗口，選擇幻燈片2

選擇項目符號列表：
項目符號列表在幻燈片中被選中

點擊動畫選項卡，然后點擊淡入動畫：
選擇動畫選項卡，選擇淡入動畫

點擊動畫 → 動畫窗格：
選擇動畫，點擊動畫窗格選項

我們將使用這個任務窗格來自定義我們的動畫。點擊第二個項目符號的列表項：
點擊第二個項目符號的列表項

點擊這個項旁邊的下拉箭頭：
動畫窗格打開，點擊第二個項目符號的下拉箭頭

點擊在之前開始：
動畫窗格打開，一個小窗口打開，選擇在之前開始

你會看到表示動畫效果的小方框稍微向右移動，表示它將在第一個項目符號之后出現。重復步驟六、七和八，將下面兩個項目符號的動畫效果都設置成順序出現：
動畫窗格打開，小方框稍微向右移動，步驟在6、7、8中重復

點擊第一個動畫效果來選擇它。點擊從此處開始播放來測試動畫效果：
動畫窗格打開，選擇第一個動畫效果，點擊從此處開始播放

當預覽完成后，關閉動畫窗格：
動畫窗格被關閉

選擇項目符號列表。點擊動畫 → 動畫復制工具：
打開幻燈片2，選擇項目符號列表，點擊動畫，選擇動畫復制工具

點擊幻燈片4。點擊包含項目符號列表的文本框：
選擇幻燈片4，點擊包含項目符號列表的文本框

自定義動畫將立即應用并預覽：
自定義動畫被應用并預覽

將你的演示文稿保存為“Activity 5-5 Complete”。關閉 Microsoft 365 PowerPoint，完成這個活動。

Exercise: Inserting a table from Microsoft Excel

Let’s get started!

In this activity, you will add a table from Microsoft Excel to your presentation.

Click on the link below to open the Microsoft PowerPoint exercise document you can use to complete this exercise.

Exercise: Inserting a table from Microsoft Excel

Exercise: Inserting a table from Microsoft Excel_Excel sheet

Click slide 4:

PowerPoint window open, slide 4 selected

Click Insert → Object:

PowerPoint window open, Insert tab selected, Object option selected

The Insert Object dialog box will open. Click the Create from file radio button:

Insert Object window open, Create from file radio button selected

Now, click the Browse button to choose the file:

Insert Object window open, Browse button selected

In the Browse dialog box, navigate to Lesson 6 of your Exercise Files. Locate and select the Activity 6-3 Excel workbook file. Click OK:

Browse window open, Activity 6-3 Excel workbook file selected, “OK” button selected

Click OK in the Insert Object dialog box:

Insert Object window open, “OK” button selected

The Excel worksheet will be added to the slide:

PowerPoint window open, Excel worksheet was added to the slide

Click the bottom left-hand corner of the object and drag it outwards to increase the size as shown below:

PowerPoint window open, the worksheet was increased the size
(Notice that the red guideline will help you position the table.)

Click the outer border of the worksheet and drag it down to the bottom of the slide to move it below the “Future Projections” title:

PowerPoint window open, the worksheet was moved below to the “Future Projections” title

With the object still selected, click Shape Format → Align → Align Center:

PowerPoint window open, the object selected, Shape Format selected, Align selected and Align Center

Save your presentation as Activity 6-3 Complete. Close Microsoft 365 PowerPoint to complete this activity.

練習：從Microsoft Excel插入表格

讓我們開始吧！

在這個活動中，您將在演示文稿中添加來自Microsoft Excel的表格。

點擊下面的鏈接以打開Microsoft PowerPoint練習文檔，您可以在其中完成這個練習。
練習：從Microsoft Excel插入表格

練習：從Microsoft Excel插入表格_Excel工作表

點擊幻燈片4：
PowerPoint窗口打開，幻燈片4被選中

點擊插入 → 對象：
PowerPoint窗口打開，選擇插入選項卡，選擇對象選項

“插入對象”對話框將打開。點擊“從文件創建”單選按鈕：
插入對象窗口打開，選擇從文件創建單選按鈕

現在，點擊“瀏覽”按鈕以選擇文件：
插入對象窗口打開，選擇瀏覽按鈕

在瀏覽對話框中，導航到您的練習文件中的第6課。找到并選擇Activity 6-3 Excel工作簿文件。點擊“確定”：
瀏覽窗口打開，選擇Activity 6-3 Excel工作簿文件，點擊“確定”按鈕

在“插入對象”對話框中點擊“確定”：
插入對象窗口打開，點擊“確定”按鈕

Excel工作表將被添加到幻燈片上：
PowerPoint窗口打開，Excel工作表被添加到幻燈片上

點擊工作表的左下角并向外拖拽以增加其大小，如下圖所示：
PowerPoint窗口打開，工作表被增大大小
（注意，紅色指導線將幫助您定位表格。）

點擊工作表的外邊框并將其向下拖動到幻燈片的底部，放置在“未來預測”標題下方：
PowerPoint窗口打開，工作表被移動到“未來預測”標題下方

仍然選中對象，點擊“形狀格式” → “對齊” → “居中對齊”：
PowerPoint窗口打開，對象被選中，選擇“形狀格式”，選擇“對齊”，選擇“居中對齊”

將您的演示文稿另存為“Activity 6-3 Complete”。關閉Microsoft 365 PowerPoint以完成這個活動。

Exercise: Adding hyperlinks and action buttons

Let’s get started!

To add more interactivity to a presentation that you have been working on, you would like to add a hyperlink as well as an action button. Microsoft Word is required to complete this activity.

Click on the link below to open the Microsoft PowerPoint exercise document you can use to complete this exercise.

Exercise: Adding Hyperlinks and Action Buttons

Exercise: Add Hyperlinks and Action Buttons_Agenda

First, you would like to add to the first slide a hyperlink that will lead to your organization’s website. With the first slide displayed, use your cursor to select the company name:

PowerPoint window open, the slides was displayed, Company name was selected

Click Insert → Link ? Insert Link:

PowerPoint window open, Insert tab selected, Insert option selected, Link and Insert Link too

The Insert Hyperlink dialog box will now be displayed. In the Address text box, type the website address of your organization. Click OK:

Insert Hyperlink window open, the Website address was typed in the Address text box, “OK” button selected

The selected text will now be converted into a hyperlink:

PowerPoint window open, the first slide is in the view area the text was converted into a hyperlink

Now display slide two. Click to select the star shape that appears in the top right-hand corner:

PowerPoint window open, the slide two is displayed. A star shape was selected in the top right-hand corner of the slide

Click Insert → Action:

PowerPoint window open, Insert tab selected, Action option selected

The Action Settings dialog box is now displayed with the Mouse Click tab open. Click the Hyperlink to radio button:

Action Settings window open, Hyperlink to radio button was selected

This will enable the associated drop-down menu. Click on this drop-down menu and select Other File:

Action Settings window open, the drop-down menu selected, Other File option chosen

The Hyperlink to Other File dialog box will now be open. Use its controls to find and locate the Agenda document within your Exercise Files folder. Click to select this file and then click OK:

Hyperlink to Other File window open, Agenda document selected, “OK” button selected

Back at the Action Settings dialog box, you will now see the full file address for the selected file inside the Hyperlink to text box. Click OK:

Action Settings window open, the full file address appears inside the Hyperlink text box “OK” button selected

Now you should test the hyperlink and action button to make sure that they work properly. Start the slide show from the beginning. On the first slide, click the hyperlink that you added:

PowerPoint window open, the hyperlink was selected from the first slide

Your default browser will then open to display the website destination that was directed by the hyperlink:

The Default browser opened the website destination that was directed by the hyperlink

Close the browser to return to the slide show. Advance to slide two and click the star shape that is near the upper right-hand corner of the slide:

The PowerPoint window open, slide two was selected and the star shape was selected

The Agenda file will now be open in Microsoft Word:

The agenda file opened the Microsoft Word window

Close the Microsoft Word window and exit the slide show. Save the current presentation as Activity 6-4 Complete.

練習：添加超鏈接和操作按鈕

讓我們開始吧！

為了在您正在工作的演示文稿中添加更多的互動性，您希望添加一個超鏈接和一個操作按鈕。完成這個任務需要使用 Microsoft Word。

點擊下面的鏈接，打開 Microsoft PowerPoint 練習文檔，您可以用它來完成這個練習。
練習：添加超鏈接和操作按鈕

練習：添加超鏈接和操作按鈕_議程

首先，在第一張幻燈片上，您想添加一個超鏈接，將其鏈接到您的組織網站。在第一張幻燈片上顯示時，使用鼠標光標選擇公司名稱：
打開 PowerPoint 窗口，幻燈片顯示，公司名稱被選擇。

點擊“插入”→“鏈接”→“插入鏈接”：
打開 PowerPoint 窗口，選擇“插入”選項卡，選擇“插入”選項，點擊“鏈接”和“插入鏈接”。

現在將顯示“插入超鏈接”對話框。在地址文本框中輸入您組織的網站地址。點擊“確定”：
打開“插入超鏈接”窗口，輸入網站地址到地址文本框，點擊“確定”按鈕。

選擇的文本現在將轉換為超鏈接：
打開 PowerPoint 窗口，第一張幻燈片在視圖區域內，文本被轉換為超鏈接。

現在顯示第二張幻燈片。點擊選擇位于右上角的星形圖案：
打開 PowerPoint 窗口，顯示第二張幻燈片，選擇位于幻燈片右上角的星形圖案。

點擊“插入”→“操作”：
打開 PowerPoint 窗口，選擇“插入”選項卡，選擇“操作”選項。

現在將顯示“操作設置”對話框，并且鼠標單擊選項卡處于打開狀態。點擊“超鏈接到”單選按鈕：
打開“操作設置”窗口，選擇“超鏈接到”單選按鈕。

這將啟用關聯的下拉菜單。點擊此下拉菜單，并選擇“其他文件”：
打開“操作設置”窗口，選擇下拉菜單，選擇“其他文件”選項。

現在將顯示“超鏈接到其他文件”對話框。使用其控件在您的練習文件夾中找到并定位議程文檔。點擊選擇此文件，然后點擊“確定”：
打開“超鏈接到其他文件”窗口，選擇議程文檔，點擊“確定”按鈕。

現在在“操作設置”對話框中，您會看到所選文件的完整文件地址顯示在“超鏈接到”文本框內。點擊“確定”：
PowerPoint窗口打開，“操作設置”對話框顯示，完整文件地址顯示在“超鏈接到”文本框內，點擊“確定”按鈕。

現在您應該測試一下超鏈接和動作按鈕，確保它們正常工作。從第一張幻燈片開始播放幻燈片演示。在第一張幻燈片上，點擊您添加的超鏈接：
PowerPoint窗口打開，從第一張幻燈片上選擇了超鏈接。

然后，您的默認瀏覽器將打開顯示由超鏈接指向的網站目標：
默認瀏覽器打開了由超鏈接指向的網站目標。

關閉瀏覽器以返回到幻燈片演示。前往第二張幻燈片，并點擊位于幻燈片右上角附近的星形圖標：
PowerPoint窗口打開，選擇了第二張幻燈片，并點擊了星形圖標。

現在，Agenda文件將在Microsoft Word中打開：
Agenda文件在Microsoft Word中打開。

關閉Microsoft Word窗口并退出幻燈片演示。將當前演示保存為“Activity 6-4 Complete”。

總結

以上是生活随笔為你收集整理的微软office认证课程的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。