Excel Essential Training (Office 365/microsoft 365) Study Guide Graded A+

How does tracking changes relate to sharing a workbook in Excel? {Ans: You must share the workbook to track changes.}The worksheet below has the split feature active as shown by the vertical line between columns B and C. Which cell was selected when split was chosen by the user? {Ans: C1}You have a workbook with multiple worksheets and want an exact copy of one of the worksheets. How can you duplicate this sheet within the same workbook? {Ans: Click in the tab name of the worksheet, hold the Ctrl key, and drag the worksheet.}You hide three worksheets in a workbook and need to unhide them. How can you accomplish this? {Ans: Right-click any visible sheet, then select which worksheet you want to Unhide.}Which two keys are commonly used to move or insert data? {Ans: Ctrl and Shift}You would like to filter your large worksheet down to only sales from January. Which action must you take before using the Filter feature? {Ans: Make sure your date has no empty rows or columns}