Skip to ContentGo to accessibility pageKeyboard shortcuts menu
OpenStax Logo
Workplace Software and Skills

2.4 Essentials of Microsoft 365

Workplace Software and Skills2.4 Essentials of Microsoft 365

Table of contents
  1. Preface
  2. 1 Technology in Everyday Life and Business
    1. Chapter Scenario
    2. 1.1 Computing from Inception to Today
    3. 1.2 Computer Hardware and Networks
    4. 1.3 The Internet, Cloud Computing, and the Internet of Things
    5. 1.4 Safety, Security, Privacy, and the Ethical Use of Technology
    6. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  3. 2 Essentials of Software Applications for Business
    1. Chapter Scenario
    2. 2.1 Software Basics
    3. 2.2 Files and Folders
    4. 2.3 Communication and Calendar Applications
    5. 2.4 Essentials of Microsoft 365
    6. 2.5 Essentials of Google Workspace
    7. 2.6 Collaboration
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  4. 3 Creating and Working in Documents
    1. Chapter Scenario
    2. 3.1 Navigating Microsoft Word
    3. 3.2 Formatting Document Layout in Microsoft Word
    4. 3.3 Formatting Document Content in Microsoft Word
    5. 3.4 Collaborative Editing and Reviewing in Microsoft Word
    6. 3.5 Document Design
    7. 3.6 Navigating Google Docs
    8. 3.7 Formatting Layout and Content in Google Docs
    9. 3.8 Collaborative Editing and Reviewing in Google Docs
    10. 3.9 Versions and Version History
    11. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  5. 4 Document Preparation
    1. Chapter Scenario
    2. 4.1 Microsoft Word: Advanced Formatting Features
    3. 4.2 Working with Graphics and Text Tools in Microsoft Word
    4. 4.3 Managing Long Documents in Microsoft Word
    5. 4.4 Google Docs: Enhanced Formatting Features
    6. 4.5 Working with Graphics and Text Tools in Google Docs
    7. 4.6 Managing Long Documents in Google Docs
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  6. 5 Advanced Document Preparation
    1. Chapter Scenario
    2. 5.1 Creating Different Document Types in Microsoft Word
    3. 5.2 Mail Merge in Microsoft Word
    4. 5.3 Creating Forms in Microsoft Word
    5. 5.4 Creating Different Document Types in Google Docs
    6. 5.5 Creating Forms in Google Docs
    7. 5.6 Advanced Collaboration in Google Docs
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  7. 6 Preparing Presentations
    1. Chapter Scenario
    2. 6.1 Presentation and Design Essentials
    3. 6.2 Designing a Presentation in Microsoft PowerPoint
    4. 6.3 Formatting Microsoft PowerPoint Slides: Layout and Design Principles
    5. 6.4 Adding Visuals and Features to Microsoft PowerPoint Slides
    6. 6.5 Designing a Presentation in Google Slides
    7. 6.6 Creating Google Slides: Layout and Text
    8. 6.7 Adding Visuals and Features to Google Slides
    9. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  8. 7 Advanced Presentation Skills
    1. Chapter Scenario
    2. 7.1 Effective Presentation Skills
    3. 7.2 Finalizing a Slide Collection
    4. 7.3 Preparing a Microsoft PowerPoint Collection for Presentation
    5. 7.4 Preparing a Google Slides Collection for Presentation
    6. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  9. 8 Content Management Systems and Social Media in Business
    1. Chapter Scenario
    2. 8.1 What Are Content Management Systems?
    3. 8.2 Common Content Management Systems
    4. 8.3 Creating Content with a Content Management System
    5. 8.4 Search Engine Optimization
    6. 8.5 Social Media in Business
    7. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  10. 9 Working with Spreadsheets
    1. Chapter Scenario
    2. 9.1 Microsoft Excel Basics
    3. 9.2 Text and Numbers in Microsoft Excel
    4. 9.3 Calculations and Basic Formulas in Microsoft Excel
    5. 9.4 Formatting and Templates in Microsoft Excel
    6. 9.5 Google Sheets Basics
    7. 9.6 Text and Numbers in Google Sheets
    8. 9.7 Calculations and Basic Formulas in Google Sheets
    9. 9.8 Formatting and Templates in Google Sheets
    10. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  11. 10 Advanced Excel Formulas, Functions, and Techniques
    1. Chapter Scenario
    2. 10.1 Data Tables and Ranges
    3. 10.2 More About Formulas
    4. 10.3 Using Arithmetic, Statistical, and Logical Functions
    5. 10.4 PivotTables
    6. 10.5 Auditing Formulas and Fixing Errors
    7. 10.6 Advanced Formatting Techniques
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  12. 11 Advanced Excel Spreadsheets: Statistical and Data Analysis
    1. Chapter Scenario
    2. 11.1 Understanding Data, Data Validation, and Data Tables
    3. 11.2 Statistical Functions
    4. 11.3 What-If Analysis
    5. 11.4 PivotTables/Charts
    6. 11.5 Data Analysis Charts
    7. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  13. 12 Using Excel in Accounting and Financial Reporting
    1. Chapter Scenario
    2. 12.1 Basic Accounting
    3. 12.2 Financial Functions in Microsoft Excel
    4. 12.3 Integrating Microsoft Excel and Accounting Programs
    5. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  14. 13 Understanding and Using Databases
    1. Chapter Scenario
    2. 13.1 What Is a Database?
    3. 13.2 Microsoft Access: Main Features and Navigation
    4. 13.3 Querying a Database
    5. 13.4 Maintaining Records in a Database
    6. 13.5 Creating Reports in Microsoft Access
    7. 13.6 Creating Forms in Microsoft Access
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  15. 14 Advanced Database Use
    1. Chapter Scenario
    2. 14.1 Advanced Queries in Microsoft Access
    3. 14.2 Multiple Table Forms
    4. 14.3 Customizing Forms
    5. 14.4 Customizing Reports
    6. 14.5 Using Macros
    7. 14.6 Data Analysis and Integration
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  16. 15 Integrating Applications
    1. Chapter Scenario
    2. 15.1 Microsoft 365: Collaboration and Integration
    3. 15.2 Microsoft Word: Integration with Microsoft Excel and Microsoft Access
    4. 15.3 Microsoft Word and Microsoft PowerPoint Integration
    5. 15.4 Microsoft Excel and Microsoft PowerPoint Integration
    6. 15.5 Microsoft Excel and Microsoft Access Integration
    7. 15.6 Integrating Data from Other Programs into Google Workspace
    8. 15.7 New Developments: The Role of Artificial Intelligence
    9. 15.8 Mastering Workplace Software Skills: A Project
    10. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
  17. Index

Learning Objectives

By the end of this section, you will be able to:

  • Know how to access Microsoft applications
  • Describe the key functions within Microsoft’s standard menus
  • Create, save, and open a document

Both personal and business productivity have increased as the result of technological advances. Computer technology has facilitated communication, information sharing, and data analytics. Although there have been several software programs developed over the years in these areas, two main leaders have emerged: Microsoft and Google are most common in organizations today and are suitable for a variety of purposes. Google and Microsoft have dominated the market for productivity software programs because they have adapted to the changing needs of businesses. Their success continues because of their forward-thinking and response to market needs.

Overview of Microsoft 365

Microsoft launched Microsoft Office in 1990. This suite of applications included three main programs: Word, Excel, and PowerPoint. These programs are bundled as a package to give the user the full range of productivity tools to meet a wide variety of needs. Office applications offer the flexibility to appeal to various preferences with the many ways to perform tasks within the software.

Office applications are compatible across a wide variety of platforms, including mobile devices and Apple/Mac operating systems. The applications also integrate well with other software. You may be aware of older versions of Office, such as Office 2016 or 2019, but the latest product, Microsoft 365, moves beyond these static versions, instead offering a subscription that updates automatically. With the introduction of Microsoft 365, the programs use a cloud-based technology that can be accessed anywhere. Microsoft 365 also enhanced the collaborative features of the programs.

Accessing and Maintaining Microsoft Products

When you register for a Microsoft 365 account, you are given access to OneDrive, which is its product that provides online storage in the cloud. This offers many advantages. When you save a file to your OneDrive, you will be able to access it from any computer as long as you have an internet connection. There are different versions of Microsoft 365 available for purchase, but most software today uses this subscription-based model for a fee. The software programs are installed on your devices as “apps,” but can also be accessed through the web-based versions with some limitations to functionality. Updates to the programs are provided regularly by Microsoft and should be performed when prompted. Sometimes the information technology department (IT) will take care of these software maintenance issues with your company or school equipment. There are student editions of most versions of Microsoft 365 that can be purchased at a reduced cost or even for free. The student editions might also have some limitations to the functionality of the programs.

Applications

The Microsoft 365 suite includes software for many of the most common computer needs in today’s workplace, as well as for personal use, including word processing, spreadsheets, presentations, database management, an email and calendar interface, and a collaboration tool. Table 2.2 provides an overview of the applications within the suite. Other chapters in this text will cover these programs in detail. What comes next in this chapter is a breakdown of commands that are common to all the Microsoft 365 applications, so you can get a basic understanding of how to navigate.

Application Type Description
Word Word processing Create documents such as reports, memos, agendas, résumés, flyers, and mailings.
Excel Spreadsheet Create data-based sheets and workbooks for gathering data, performing functions, and analysis.
PowerPoint Presentations Create slide presentations for use in workplace meetings or client showcases.
Access Database Create and maintain databases of information.
Outlook Email Manage email communications and calendars.
Teams Collaboration tool Set up workspaces for collaboration, such as a team might use on a specific project.
Table 2.2 Microsoft 365 Applications

Overview: Ribbons, Tabs, and Commands Menu

Since its initial release, Microsoft’s suite of office products has been a driver of change, introducing new features in each subsequent version. Since the 2007 version, the apps have used the ribbon—an interactive bar of commands at the top of the application—as their user interface. With the ribbon, all the functions are clearly organized and user-friendly.

The ribbon is organized into tabs, each of which houses a collection of thematically grouped commands. The default tabs are File, Home, Insert, Design, Layout, References, Mailings, Review, View, and Help. As you hover your mouse over the ribbon, you will notice many small icons (pictures) that have a command over them. A command directs the program to complete a process, such as Save. When you select the Save icon, the command will start.

As you can see in Figure 2.19, the commands in the ribbon are organized into a command group of similar or related buttons, which appear together on the ribbon tabs.

Home is labeled with Tab. All tabs and command groups together are labeled Ribbon. Font, Paragraph, and Styles sections are labeled with Command group labels.
Figure 2.19 The Home tab contains the command groups Font, Paragraph, and Styles, which are used for formatting text. (Used with permission from Microsoft)

Each tab generates a different ribbon with the appropriate commands and command groups. This section introduces the most used tabs. You will learn more details about them and practice using them in each specific application as the book goes on. Figure 2.20 shows the tabs available in Word and Excel, and Figure 2.21 shows the tabs available in PowerPoint and Access.

(a) Tabs displayed for Word: File, Home, Developer, Insert, Design, Layout, References, Mailings, Review, View, Help. (b) Tabs displays for Excel: File, Home, insert, Page Layout, Formulas, Data, Review, View, Help, Inquire.
Figure 2.20 The main menu bars for (a) Word and (b) Excel share common tabs (File, Home, Insert, Help, for instance), but also contain tabs that are in character with their main functions (such as References in Word and Formulas in Excel). (Used with permission from Microsoft)
(a) PowerPoint tabs visible: File, Home, Insert, Design, Transitions, Animations, Slide Show, Review, View, and Recording. (b) Access tabs visible: File, Home, Create, External Data, Database Tools, Help, Table Fields, and Table
Figure 2.21 The main menu bars for (a) PowerPoint and (b) Access also share common tabs with one another and with Word and Excel (File, Home, Insert, Help, for instance). They also contain tabs that are in character with their main functions (such as Animations in PowerPoint and Database Tools in Access). (Used with permission from Microsoft)

File Tab

If you open a Microsoft product without opening any specific file, you will see the welcome screen, which provides a Backstage view. The Backstage view is located in an application for managing most tasks related to the documents. In Backstage view, you can open, close, rename, print, and control the settings for the application. There will be many commonalities within the Office programs for the tabs. When you have opened a file in an application such as Word or Excel, the Backstage view gives you information about that file you are working with. As you can see in Figure 2.22, the file properties are shown on the right pane of the Backstage view, which displays critical metrics about your document, such as its size, number of pages, number of words, file name, last saved time, and when it was printed. Backstage view also includes important commands such as file protection, inspecting the document, and managing the document, which will be discussed later in this chapter.

Info window lists: file Properties (Size, Pages, Words, Total Editing Time, Title, Tags, Comments, Template, Status, Categories, Subject, Hyperlink Base, Company), Related Dates (Last Modified, Created, Last Printed), Related People (Manager, Author).
Figure 2.22 Backstage view shows file properties, which are the statistics and technical details of your file. (Used with permission from Microsoft)

Mac Tip

The Backstage view is not included in the Mac Version of Office, but you can get the properties of a file by going to the File tab and choosing Properties.

Creating a New File

As you open an Office application, you will be introduced to the welcome screen, which shows your recent files on the left and your options on the right. See Figure 2.23. Because you are in Word, you can choose Blank document to start a new document, or you can select a template from the default template list. A template is a document with many fields already filled and formatted, ready for the user to work on.

A Home window displays options to select a Blank Document or other Templates. Options for Recent documents are available, listing recently accessed files with the Name and Date modified indicated.
Figure 2.23 The welcome screen gives you three choices: start from scratch with a new file, create a file from a template, or open a recent file you have already saved. (Used with permission from Microsoft)

Mac Tip

The Mac version does not have the same welcome screen. To create a new file, go to the File tab and choose New Document or New Document from Template.

To create a new document without using a template, simply select Blank document. A new document will be opened with a blank screen for you to create your file. This new document will be opened in a new window. You can then add the content to the document and save the document if desired. More about document creation will be covered in later chapters in the book.

Saving a File

The Save command is located at the upper-left corner of the window. Using the Save command saves your document in its same location, with its same file name. It is a way of making sure your work does not get lost in case your computer crashes or the application closes suddenly. A good best practice is to save your document occasionally, by either pressing on the Save icon or using Ctrl+S. You can also set up automatic saving at specified time intervals.

The Save As command, located on the File tab, allows you to not only save the file with a different name but also to change its location and its type. When you save the file to a new type (for instance, Save As PDF), the file opens in the new file format. The previous file type remains open. When you click on the Save As command, a dialog box will appear, asking you to select the location where you want to save the new version and what you want to name it.

Large companies like WorldCorp will typically give their employees a schema or convention to follow when naming files so that the company will have a unified system that all employees can easily identify and understand. This also allows people within the organization to be able to keep track of different information about the file, such as its version and the project or department it is associated with. For example, if the name of your market trends report is “market_report_v1.docx,” the next version could be “market_report_v2.docx.” This gives you a version history of the file, which enables you to keep track of older and newer versions. Figure 2.24 shows the current folder and the name of the file you want to change.

Save As is selected, then This PC, opening to the File location folder. The name is being changed to marketing_report(*.docx). Below the bar are other versions of the report and Date modified.
Figure 2.24 When you Save As, you can change the file name, the file format, or both. (Used with permission from Microsoft)

Save As can also be helpful in other situations. For example, you may want to save your file in a different format so that it can be opened by a different application. You would also use the Save As command to save the file in a different folder, with a different name for categorization purposes. The default Word file format is .docx, but you could also save it as a .pdf or .rtf.

Microsoft also offers the option to save to a different location—for example, your local computer, a shared private location (such as a company drive), or the cloud OneDrive. This allows you to save your work easily even if the device you are working on does not have saving capacity, and also gives you the ability to share your work with others. (You will learn more about collaboration later.) To share a file with others, first save your presentation to OneDrive. Choose File, then Share, and then Share with People.

Opening an Existing File

With the desktop version of Microsoft 365, your recent file list will be readily available in Backstage view. If the file you want does not appear in your recent file list, click on File and then Open. Locate the file, select it, and click Open. If you want a file to always appear in your recent file list, you can “pin” it: Go back to File, and the file that is now open will have a pushpin icon next to its name. Click on the pushpin, and the file will be pinned.

To access a file in Microsoft 365 online, you must set up an account with Microsoft if you do not already have one. Then, you can go to the program you are working in and you will find your recent file list. OneDrive also gives you access to files not listed in your recent file list. Locate the file you want and click Open. Your document should appear.

Printing a File

To print a file, choose the File tab. In the list of options on the left, you will see Print. When you click on Print, you will be shown a preview of your document along with print options. See Figure 2.25. The print options include a variety of settings, such as number of copies, printer selection, and paper size. You can also print on both sides of the paper or select only certain sheets to print. When you have chosen the desired settings, choose Print on the upper-left side of the screen.

Print is selected and options available include Print, Copies, Printer, Print All Pages, Print One Sided, Collated, Custom Staple Setting, Portrait Orientation, and Letter. A Preview of document displays at the right.
Figure 2.25 You can also choose to have your document stapled if that option is available on your printer. (Used with permission from Microsoft)

Mac Tip

Print screen on a Mac displays the options that are included with the user’s installed printer.

Options

The Options command at the bottom of the File tab contains a multitude of choices that control the way your workspace appears, determine the way the text is corrected, and allow changes to many aspects of the program. A summary of the options available is shown in Table 2.3.

General Provides options that affect the user interface
Display Changes how the content is shown on the screen and when it is printed
Proofing Sets the way spelling and grammar are checked
Save Sets up AutoSave to save a copy of your work at scheduled intervals
Language Chooses the language in which menus and controls appear
Accessibility Checks your documents for accessibility to people with visual or other challenges
Advanced Sets how words are edited, replaced, or cut and pasted
Customize Ribbon Allows users to choose which commands are shown on the ribbon
Quick Access Toolbar Allows users to choose what is displayed on the Quick Access Toolbar above the ribbon
Add-ins Manages the available Office add-ins
Trust Center Sets security settings, most of which should remain as set
Table 2.3 Summary of the Options Dialog Box The Options command appears in all Office applications and provides helpful settings.

The Options command, present in all Office applications, opens an Options dialog box, as shown in Figure 2.26. Before you start working, it’s advisable to click on each of the Options items to see what each covers.

An Options item that is critical to your work is a Save option called AutoRecover. Just ask yourself, “Has my computer ever frozen in the middle of a sentence?” This happens to everyone, but AutoRecover can prevent a catastrophe by allowing you to set the program to automatically save your work every two minutes, five minutes, or whatever interval you choose.

Another helpful option is proofing, which allows Microsoft to check your spelling as you type.

You will find some options that you may never need to change. In the future, however, you will be glad to know where to locate these hidden settings.

General is selected. Word Options displays some selections: When using multiple displays: Optimize for best appearance, Show Mini Toolbar on selection, Enable Live Preview, Update document content while dragging, Enable modern comments.
Figure 2.26 The Options command, present in all Office applications, opens an Options dialog box with many available options or settings that can be changed. (Used with permission from Microsoft)

Customize Ribbon and the Quick Access Toolbar are useful features. Because you are likely to use both functions on a regular basis, you want their commands to always be visible. This is most easily done by customizing the ribbon or the Quick Access Toolbar.

There are probably some other commands that you wish you had immediate access to but did not know this was possible. For example, did you know that you can add an email command to either the ribbon or the Quick Access Toolbar? Suppose you want to email someone and add a presentation to your email as an attachment. If you add Email to your ribbon or Quick Access Toolbar, you can just click on the Email command, which will open your regular email program with access to your address book and add an attachment of the presentation to the email. No more need to open the email program independently, then search for the file on your computer, and finally attach it.

As another example, suppose you work with a lot of graphics. There are numerous commands associated with drawing and inserting graphics that are generally hidden. You may not even be aware that these functions exist, but when you change the scope to All Commands and look through the choices, you will find many commands that can save you a lot of time if you set them up for immediate access.

There are two ways to customize the Quick Access Toolbar. First, from the Options dialog box, select the Quick Access Toolbar, shown in Figure 2.27.

PowerPoint Quick Access Toolbar is selected. Customize the Quick Access Toolbar displays drop down menus for Choose commands from and Customize Quick Access Toolbar. Add and Remove buttons are between the drop-downs.
Figure 2.27 To customize the Quick Access Toolbar, add commands from the selections on the left to the list on the right. (Used with permission from Microsoft)

For example, to add a Quick Print option, scroll down to Quick Print in the list of commands on the left. Highlight Quick Print, click the Add button, and Quick Print will appear on the Quick Access Toolbar, as seen in Figure 2.28, which shows the result of customizing the Quick Access Toolbar.

Quick Access Toolbar is selected in PowerPoint Options. Customize the Quick Access Toolbar displays Quick Print selected from Popular Commands and being Added to Customize Quick Access Toolbar.
Figure 2.28 Items added to the Quick Access Toolbar will appear at the top of the screen when you open the program. (Used with permission from Microsoft)

The second way to customize is to right-click on the Quick Access Toolbar, which opens a context menu. Choose Quick Print from the menu items, as shown in Figure 2.29. The Quick Print option should appear on the Quick Access Toolbar.

Quick Print is being selected from the Customize Quick Access Toolbar drop-down located above the ribbon.
Figure 2.29 Using the context menu, you can easily add the Quick Print option to the Quick Access Toolbar. (Used with permission from Microsoft)

Mac Tip

The Quick Access Toolbar is found on the Preferences tab on the app main page.

Customizing the ribbon is a similar process. Start at the Customize the ribbon command from Options in Backstage view. To add a command to the ribbon, you first have to create a new group, as follows:

  1. Choose the tab on the right where you want to add the new command. (For the purposes of this demonstration, choose the Draw group, making sure there is a check mark next to the Draw box.)
  2. Click on New Group, which will be listed when you click on the plus sign next to Draw.
  3. In the box at the top left, select Commands Not in the ribbon (see Figure 2.30).
  4. Scroll down to Borders and Shading and click Add.
  5. Then, select another command, Brightness, and click Add.

When you return to the application, you will see your New Group with the options selected. Using this method, you can select any command from the left and add it to the ribbon commands on the right. This works for all the Office programs.

Customize the Ribbon is selected in PowerPoint Options. Customize the Ribbon displays drop-down menus for Choose commands from and Customize the Ribbon. Add and Remove buttons are between the drop-downs.
Figure 2.30 Customizing the ribbon can facilitate your productivity by including items you use frequently for quicker access. (Used with permission from Microsoft)

Home Tab

The Home tab is where you begin to create your document, spreadsheet, or presentation. The ribbon for the Home tab in Word is shown in Figure 2.31. You can view the ribbon as command central for the application: It is a collection of commands and command groups that govern the basics of the program you are working with. Each group of commands is separated by a thin vertical line (see arrow in Figure 2.31).

Font command group includes Font, Font Size, Increase and Decrease Font Size, Change Case, Clear All Formatting, Bold, Italic, Underline, Strikethrough, Subscript, Superscript, Text Effects and Typography, Text Highlight Color, Font Color.
Figure 2.31 The Home tab contains items such as formatting the font size and determining the line spacing. (Used with permission from Microsoft)

First is the Clipboard group, which contains the commands for all the cut-and-paste functions. As in all the Office applications, an arrow next to or below a label means that there are other possible choices for that function. Notice that the Paste command has an arrow below it. Clicking on the arrow gives you several Paste options; if you hover over them, you will see helpful descriptions and previews.

The Font command group is similar across applications. You can choose Bold, Italic, Underline, Strikethrough, and Highlight. You can also regulate character spacing and add a superscript or subscript. Primarily, however, you will change the font face, color, and size.

Sticking with Word to get an idea of how the Home tab operates, the Paragraph command group contains the commands for indentation and for aligning text to the right or to the left, centered, or justified. You can create columns, change the direction of the text by rotating 90, 180, or 270 degrees, or stack the letters on top of one another. The Paragraph command group also contains the commands for creating bulleted and numbered lists and for adding SmartArt graphics to text. Notice that there is an arrow associated with most of these commands, indicating that each one offers still more choices for formatting a paragraph.

Table 2.4 lists common keyboard shortcuts. To use each action, press the Ctrl button, and while holding it down, press the next key. You may find these shortcuts useful so that you do not have to take your hands from the keyboard to use the mouse. It might be helpful to bookmark this table for future reference as you work through the rest of the book.

Action Keyboard Shortcut Action Keyboard Shortcut Action Keyboard Shortcut
Copy Ctrl+C Italic Ctrl+I Help F1
Cut Ctrl+X Center Ctrl+E Open a file Ctrl+O
Paste Ctrl+V Justify Ctrl+J Create a new file Ctrl+N
Undo Ctrl+Z Underline Ctrl+U Save a file Ctrl+S
Redo Ctrl+Y Align left Ctrl+L Print a file Ctrl+P
Bold Ctrl+B Find Ctrl+F Close a file Ctrl+W
Table 2.4 Common Keyboard Shortcuts in Office

Mac Tip

On a Mac, Control is replaced with Command.

Format Painter

Format Painter, represented with a paintbrush icon, is a shortcut tool that is available in Word, Excel, and PowerPoint. This tool lets you copy the formatting of a section of text, a cell, or whatever you choose to another place on a document, spreadsheet, or slide, respectively. It is especially useful when you need to reformat large amounts of text.

First, select the text that has been formatted in the way you want. Then, click on Format Painter, and the cursor will turn into a little paintbrush, as Figure 2.32 shows. Brush over the text you want to change, let go of the mouse, and the text will now be formatted in the desired style.

Note that if you want to use Format Painter again, you will have to repeat the steps outlined above. To format a lot of text, double-click on the Format Painter icon, and it will last until you click on it one more time.

In PowerPoint, the Format Painter icon (a paintbrush) from the Clipboard command group is enlarged for view.
Figure 2.32 Format Painter is a handy tool to brush, so to speak, over text and format it as you like. (Used with permission from Microsoft)

Insert Tab

The Insert tab allows you to insert a variety of items into your file, including visual images such as pictures or diagrams, tables, links, and equations or special symbols. The Insert tab will differ a bit by program. Figure 2.33 shows what the Insert tab looks like for Word, Excel, and PowerPoint. For example, in Word and PowerPoint, you have options to insert SmartArt. Excel has many options to insert charts and graphs. More details about the specific insert options will appear in the chapters to follow on each of the programs.

(a) Word Insert tab includes Pages, Tables, Illustrations, Reuse Files, Add-ins, Media. (b) Excel Insert tab includes Tables, Illustrations, Add-ins, Charts. (c) PowerPoint Insert tab includes Slides, Tables, Images, Illustrations, Forms, Links.
Figure 2.33 (a) Insert tab for Word, (b) Excel, and (c) PowerPoint. Different tabs appear for each program depending on the program’s purpose. (Used with permission from Microsoft)

Design Tab

The Design tab is found on the ribbon in Word and in PowerPoint. See Figure 2.34. The tab includes options to customize the look of the document or presentation. There are preset themes that you can use to enhance the document or slide, or you can create your own theme. The options on the Design tab are covered in more depth in Creating and Working in Documents and Preparing Presentations.

(a) Word Design tab selected. The command group Document Formatting displays various document Themes for selection. (b) PowerPoint Design tab selected. The command group Themes displays various document theme options for selection.
Figure 2.34 (a) The Design tab in Word allows you to choose preset themes for formatting text or you can create your own design choices. (b) PowerPoint’s Design tab functions similarly. (Used with permission from Microsoft)

Layout and Page Layout Tabs

The Layout tab (Word) and Page Layout (Excel) tabs control items such as spacing and margins in your file. You can use the options on the tabs to insert page breaks, change the orientation, and define the print area. In Page Layout in Excel, you can also apply a theme to your spreadsheet to enhance the visual appeal. This is similar to what you would find on the Design tab for Word and PowerPoint. Figure 2.35 shows the tabs for Word and Excel. The chapters on Word and Excel will cover these tabs in depth.

(a) Word Layout tab displays Page Setup and Paragraph command groups. (b) Excel Page Layout tab displays Themes, Page Setup, Scale to Fit, and Sheet Options command groups.
Figure 2.35 (a) The Layout tab in Word and (b) Page Layout tab in Excel allow you to set up your document or spreadsheet for easier reading and visual appeal. (Used with permission from Microsoft)

Review Tab

The Review tab is found in three Office programs (Access does not have a Review tab). In Word, the Review tab is useful to check spelling, track changes within a document, and compare previous versions of documents to each other. The Review tab in Excel also contains a spell-check feature, but also allows you to add comments and to protect the worksheet from editing by others. Finally, the Review tab options in PowerPoint are very similar to those in Excel. The Review tab is a great place to reference to make sure your file is ready to share with others and to collaborate by adding comments. Figure 2.36 shows the Review tabs for Excel, Word, and PowerPoint.

(a) Word Review tab displays Proofing, Speech, Accessibility, Language, Comments. (b) Excel Review tab displays Proofing, Accessibility, Insights, Language, Comments. (c) PowerPoint Review tab displays Proofing, Accessibility, Language, Comments.
Figure 2.36 The Review tab in (a) Word, (b) Excel, and (c) PowerPoint all share common functions, such as creating and managing comments from multiple users. (Used with permission from Microsoft)

View Tab

The View tab is also seen in Office applications, except Access. It can customize what you see on the screen. You can change the options to show you what the file will look like when printed by choosing the Print Layout view. You can use the options to zoom in to make the screen larger. Finally, there are options to view files open in the same program side by side or to switch between the open windows when working with multiple files at a time. Notice the slight differences in options between the three applications in Figure 2.37.

(a) Word View tab includes Views, Immersive, Page Movement, Show, Zoom. (b) Excel View tab includes Sheet/Workbook Views, Show, Zoom. (c) PowerPoint View tab includes Presentation/Master Views, Show, Zoom, Color/Grayscale.
Figure 2.37 The (a) View tab in Word, (b) Excel, and (c) PowerPoint sets how your document, spreadsheet, or presentation will appear on-screen. (Used with permission from Microsoft)

Help Tab

The Help tab looks the same in all the Office applications. The Help tab gives you options to seek help on an issue with the application you are working with. Through the tab, you can use the Help search by clicking on the question mark or you can contact support directly. The Show Training is a good place to start if you have not used the program at all before. It gives you a collection of help tutorials to walk you through many of the more common features used in the program. When you select any of the options on the Help tab, a window will open at the right to assist you further (see Figure 2.38).

Help is selected. Help dialog box displays Search Bar, Get Started, Collaborate, Insert Text, Pages & layouts, Pictures, Save & print, Mail Merge, Recommended Topics (Words for Windows training, Lay out pages).
Figure 2.38 When you select the general help search with the question mark, you can type the topic or question you need help with into the search bar. (Used with permission from Microsoft)

Other Tabs

Based on the application you are using, there are different tabs that are included in the ribbon specific to that program. These tabs offer options that relate to the functionality of the program. For example, in Word, you have a Mailings tab that can send a document to a large database of individuals. In PowerPoint, you have the Slide Show tab that contains options for developing your presentation. Table 2.5 gives you the default tabs for each program. Remember, using the Customized Ribbon option, you can change which tabs you have displayed in the programs.

Word Home, Insert, Layout, References, Mailings, Review, View, and Help
Excel Home, Insert, Page Layout, Formulas, Data, Review, View, and Help
PowerPoint Home, Insert, Design, Transitions, Animations, Slide Show, Review, View, and Help
Access Home, Create, External Data, Database Tools, Help, Table Fields, and Table
Table 2.5 Default Tabs by Office Program Each program has a ribbon of default tabs.
Citation/Attribution

This book may not be used in the training of large language models or otherwise be ingested into large language models or generative AI offerings without OpenStax's permission.

Want to cite, share, or modify this book? This book uses the Creative Commons Attribution License and you must attribute OpenStax.

Attribution information
  • If you are redistributing all or part of this book in a print format, then you must include on every physical page the following attribution:
    Access for free at https://openstax.org/books/workplace-software-skills/pages/1-chapter-scenario
  • If you are redistributing all or part of this book in a digital format, then you must include on every digital page view the following attribution:
    Access for free at https://openstax.org/books/workplace-software-skills/pages/1-chapter-scenario
Citation information

© Jan 3, 2024 OpenStax. Textbook content produced by OpenStax is licensed under a Creative Commons Attribution License . The OpenStax name, OpenStax logo, OpenStax book covers, OpenStax CNX name, and OpenStax CNX logo are not subject to the Creative Commons license and may not be reproduced without the prior and express written consent of Rice University.