Concepts Review ............................................................................................................................................ 2

Excel-1 Solutions to Excel 2016 Module 1 EOM Exercises

MODULE A

Getting Started with Excel 2016

Table of Contents Module 1: Getting Started with Excel 2016 ................................................................................................... 2 Concepts Review ............................................................................................................................................ 2 Skills Review ................................................................................................................................................... 2 Independent Challenge 1 ............................................................................................................................... 4 Independent Challenge 2 ............................................................................................................................... 5 Independent Challenge 3 ............................................................................................................................... 6 Independent Challenge 4: Explore ................................................................................................................. 7 Visual Workshop ............................................................................................................................................ 8

(Illustrated Microsoft® Office 365 & Excel 2016, Comprehensive, 1e Elizabeth Eisner Reding, Lynn Wermers) (Solution Manual, For Complete File, Download link at the end of this File) 1 / 4

Microsoft Office 2016 – Illustrated Introductory Excel-2 Solutions to Excel 2016 Module 1 EOM Exercises

Module 1: Getting Started with Excel 2016

Concepts Review

Screen Labeling Matching Items Multiple Choice

• Normal view button 7. a 13. b
• Formula bar 8. e 14. b
• Mode indicator/Status bar 9. d 15. b
• New sheet button 10. c 16. c
• Ruler 11. f 17. a
• View tab 12. b 18. b
• b
• d
• d

Skills Review The filename for steps 2 through 8 in this Skills Review is EX 1-Weather Data.xlsx. The completed solution file is shown on the following page.

• No data file is supplied for this step.
• Students should understand that a worksheet is part of a workbook.
• Some common uses for electronic spreadsheets are payroll calculations, a list of a store’s inventory,

calculation of sales tax due, list of patient data, and a record of sales data.

• ‘What-if’ analysis lets you speculate as to the possible outcomes if specific values, such as tax rates or

sales amounts change.

• Students should refer to the lesson "Touring the Excel 2016 Window" and Figures 1-3 and 1-4 for help

with this step. Make sure they can identify as many elements of the Excel window as possible.

• The formula used to calculate the difference in altitude between Atlanta and Dallas is =D4-F4. 2 / 4

Microsoft Office 2016 – Illustrated Introductory Excel-3 Solutions to Excel 2016 Module 1 EOM Exercises

Solution File: EX 1-Weather Data.xlsx

• / 4

Microsoft Office 2016 – Illustrated Introductory Excel-4 Solutions to Excel 2016 Module 1 EOM Exercises

Independent Challenge 1

Filename: EX 1-Real Estate Acquisitions.xlsx

Because an independent challenge can be tackled in different ways, it is important to stress that there is not a single correct solution. Look for information similar to what is shown in the figures below, remembering that there is room for variety.

Estimated completion time: 10 minutes

• / 4