Excel Essential Training (Office 365/Microsoft 365) Questions And Verified Solutions.

Which shortcuts can you use for Undo and Redo? - Answer Ctrl + Z for Undo and Ctrl + Y for Redo You manage the worksheet shown below and it contains information for the company's 1500 employees. You are asked to provide a list of all of the employees who are full time and make more than $45,000 per year. What is the best way to create the list? - Answer Use the Filter option to filter by full time employees and use the Numbers filter to select greater than $45,000. What statement is accurate in regards to sharing workbooks? - Answer You must add the feature to the Quick Access Toolbar. You manage the worksheet shown below that contains a list of employees and a list of building numbers. The employee list is 1500 rows of data. What is the easiest way to sort the employee list without affecting the building number list? - Answer Add a blank column between Columns B & C, click in cell A2 and select Sort. How can you access Track Changes in Microsoft Excel Office 365? - Answer Track Changes is located under the Customize Quick Access Toolbar. Why would you set up a workbook to be shared if you are the only one using the workbook? - Answer You can track changes. Although it is not a term Excel uses, how do most people think of Excel? - Answer as a spreadsheet How does tracking changes relate to sharing a workbook in Excel? - Answer You must share the workbook to track changes.