Question

1 Open Excel and enter Exploring Series as the user name in the Excel Options dialog box, if necessary. Add the Compare and Merge Workbooks command to the Quick Access Toolbar, if necessary. Download and open exploring_e11_grader_h1_Classes.xlsx. Save it as exploring_e11_grader_h1_Classes_LastFirst. Hint: To open the Excel Options dialog box, click the File tab and click Options. To add the command to the toolbar, in the Excel Options dialog box, click Quick Access Toolbar. 2

Answer 1

Excel Options General Formulas Data Proofing Save Language Ease of Access Advanced Customize Ribbon Quick Access Toolbar Add-ins Trust Center General options for working with Excel User Interface options Show Mini Toolbar on selection ⓘ Show Quick Analysis options on selection Enable Live Preview O ScreenTip style Show feature descriptions in ScreenTips When creating new workbooks Use this as the default font Body Font Font size Default yiew for new sheets: Normal View Include this many sheets:1 Personalize your c of Microsoft Office Always use these values regardless of sign in to Office. Office Background: No Background Office Iheme Colorful Office intelligent services Intelligent services bring the power of the cloud to the Office apps to help save you time and produce better results To provide these services, Microsoft needs to be able to collect your search terms and document content Enable services Linkedin Features OK Cancel Click on the File tab on the Ribbon. Select Options from the menu It will open a "Excel Options" dialog box. Click on the Quick Access Tollbar from the left panel. Choose "Commands not in the Ribbon", select the Compare and Merge Workbooks command and click on the ADD>> button.

Select the exploring_ell_grader _hl Classes_Hoge.xlsx into your workbook and click on OK button. Select Files to Merge Into Current Workbook ˇ个璽> This PC Desktop q286691 79-Excel vC Search q28669179-Excel Organize ▼ New folder Name Date modified Type Size dBrown eploring e11 grader_h1 Classes 121/2019 359 PM Microsoft Excel W dexploring el1 grader h1 Classes Hoge 121/2019 3:59 PM Microsoft Excel W 19 KB 21 KB Microsoft Excel OneDrive This P Desktop 囹Documents Downloads Music Pictures Videos OS (C) " New Volume (D; Netwnrk File name ege grader h1 Classes Hoge Excel Workbook Tools OK Cancel

Info Brown_ exploring e1l grader h1 Classes Desktop q23569179-Eacel Open Protect Workbook Centrol what types of changes people can make to this workbook Siee Tale Save As Spring Bology Schedule dd a ta dd comment Print Mark a oryt with Password and absolute Sobject Hyperlink Base Add lest Speoity the sutject rotect Caerent Shee Centrol t types of changes pelea maie to the cut Specity the company Protect Werbook Strctue event td changes o theuctuetebk Such ing sheets Related Dates Lat Modidied Toay, &17 PM Eestrict Access Gant people access ile removing their ability to edit, copy, cr print 29 2011 309 AM Lat Printed /2/201 326AM Related People Specily the manages Exploring Series Browser View Options when tha workbook is viewed en the Last Modified By Browser Vilew Exploring Series A dialog box will appear, prompting you to save. Click OK. Microsoft Excel This workbook will be marked as final and then saved OK Cancel O Another dialog box will appear. Click OK. Microsoft Excel This document has been marked as final to indicate that edting is compiete and that this is the final version of the document when document is marked as final, the status property set to .Finar and typing, editing commands, and proofing marks are turned off. You can recognize that a document is marked as final when the Mark As Final icon displays in the status bar Don't show this message again ok Step15 Save and close the workbook.