The below items are known issues or potential sources of confusion in the MyLab Lessons assigned this semester. The notes will help you to complete the affected questions and move on.
Mac users may also wish to consult our list of keyboard shortcuts for differences that might impact how things work on a Mac compared to Windows.
MyLab Lesson A
| Module | Step | Title | Notes |
| None |
MyLab Lesson B
| Module | Step | Title | Notes |
| B3 | XL 6.1.1 | Create a Range Name | Use the "Create from Selection" option to define the range names. |
| B3 | XL 8.1.1 | Use SUMIF, AVERAGEIF, and COUNTIF | Surround the date criteria with double quotation marks (e.g., "criteria"). |
| B3 | XL 8.1.4 | Identify Salary Ranges by Quartile | Use absolute cell references for the salaries. |
| B4 | XL 8.3.5 | Creating a Forecast Worksheet | Resize both the width and height of the chart at the same time. |
MyLab Lesson C
| Module | Step | Title | Notes |
| None |
MyLab Lesson D
| Module | Step | Title | Notes |
| D2 | AC 2.3.3 | Change Query Data | In Part 5, both fields are to be sorted in ascending order. |
MyLab Lesson E
| Module | Step | Title | Notes |
| None |
MyLab Lesson F
| Module | Step | Title | Notes |
| F3 | WD 2.2.2 | Work with Sections and Format Text into Columns | The auto-select text does not complete at times even though the correct text is selected. Users should not try to change the number of columns to 2 if the text does not auto-select or an Incorrect Action error occurs. Try resetting the question and attempting it again. |
| F3 | WD 4.1.3 | Create and Update Footnotes | The footnote style is the style named Footnote Text. |
MyLab Lesson G
| Module | Step | Title | Notes |
| G2 | PP 7.2.4 | Delete, Add, and Rename Slide Layouts | Close any open panes or dialog boxes when finished. |