What statement is accurate in regards to sharing workbooks select an answer

From the course: Excel Essential Training (Microsoft 365)

Video is locked.

Unlock the full course today

Join today to access over 20,400 courses taught by industry experts or purchase this course individually.

Sharing workbooks

Sharing workbooks

From the course: Excel Essential Training (Microsoft 365)

Start my 1-month free trial Buy this course (A$50.00*)

Sharing workbooks

- [Narrator] If you want to allow multiple users to access the same workbook, you'll need to know how to activate sharing, and ultimately the ability to track changes by each user. And when we say, open at the same time, we are also opening the door to the idea that people could be making changes to the same cells at approximately the same time frame. The feature called sharing, in prior versions of Excel, used to be found on the review tab. Now, when you go to the review tab in the ribbon, you don't see sharing, but you might see here, grayed out, unshare workbook. So how do we share our workbook? We need to add an icon to the quick access toolbar. On the right side of the quick access toolbar, and most people do keep this above the ribbon, there's a drop arrow, slide down to more commands. In this dialog box, choose commands from either commands not in the ribbon or all commands. Slide down to the letter S, and you'll see an option. "Share workbook," it's a Legacy feature. We add it…

Practice while you learn with exercise files

Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.

  • Exercise File: Subscribe to access. Ex_Files_Excel_EssT_O365_Upd.zip
  • Exercise File: Subscribe to access. Glossary_Excel_Essential_Training_Office365.zip

Download courses and learn on the go

Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.

Contents

  • Introduction Introduction

    • Getting started with Excel for Office 365

      38s

  • 1. Getting Started with Excel 1. Getting Started with Excel

    • What is Excel used for?

      2m 25s

    • Using the Quick Access Toolbar and ribbon menu

      3m 26s

    • Shortcut menus and the Mini toolbar

      2m 59s

    • Understanding workbooks and worksheets

      2m 56s

    • Using Excel Help

      2m 47s

  • 2. Entering Data 2. Entering Data

    • Exploring data entry, editing, and AutoFill

      4m 8s

    • Working with dates and times

      3m 2s

    • Using Undo and Redo

      2m 39s

    • Using Save or Save As

      3m 34s

  • 3. Formulas and Functions 3. Formulas and Functions

    • Using simple formulas

      3m 57s

    • Copying a formula into adjacent cells

      3m 2s

    • Using SUM and AVERAGE

      4m 6s

    • XLOOKUP and lookup functions

      4m 32s

  • 4. Formatting 4. Formatting

    • Exploring font styles and effects

      4m 9s

    • Applying borders and color backgrounds

      2m 55s

    • Adjusting row heights and column widths

      4m 30s

  • 5. Adjusting Worksheet Layout and Data 5. Adjusting Worksheet Layout and Data

    • Rows and columns: Insert, delete, hide, and unhide

      4m 30s

    • Moving, copying, and inserting data

      2m 52s

    • Finding and replacing data

      3m 8s

  • 6. Printing 6. Printing

    • Page Layout view and commands

      4m 59s

    • Using Page Break Preview and print setup options

      4m 39s

  • 7. Charts 7. Charts

    • Creating charts

      5m 39s

    • Exploring chart types

      3m 58s

    • Working with Excel Ideas

      5m 9s

  • 8. Adjusting Worksheet Views 8. Adjusting Worksheet Views

    • Freezing and unfreezing panes

      3m 17s

    • Splitting screens horizontally and vertically

      4m 42s

  • 9. Multiple Worksheets and Workbooks 9. Multiple Worksheets and Workbooks

    • Renaming, inserting, and deleting sheets

      3m 7s

    • Moving, copying, and grouping sheets

      3m 21s

  • 10. Data Management Features 10. Data Management Features

    • Sorting data

      5m 5s

    • Using filters

      3m 15s

    • Creating PivotTables

      4m 56s

    • New data types coming to Excel for 365

      6m 58s

  • 11. Sharing Workbooks 11. Sharing Workbooks

    • Protecting worksheets and workbooks

      4m 48s

    • Sharing workbooks

      2m 57s

    • Tracking changes

      4m 14s

  • Conclusion Conclusion

    • Next steps

      25s