Excel Crash Course Exam 2024 Questions with Latest Update

1.) Which shortcuts can you use for Undo and Redo - Answer- Ctrl+ Z for Undo and Ctrl+Y for Redo 2.) 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. 3.) What statement is accurate in regards to sharing workbooks - Answer-You must add the feature to the Quick Access Toolbar. 4.) 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 and C, click in cell A2, and select Sort. 5.) How can you access Track Changes in Microsoft Excel Office 365 - Answer-Track Changes is located under the Customize Quick Access Toolbar. 6.)Why would you set up a workbook to be shared if you are the only one using the workbook - Answer-You can track changes. 7.) Although it is not a term Excel uses, how do most people think of Excel - Answer-as a spreadsheet 8.) How does tracking changes relate to sharing a workbook in Excel - Answer-You must share the workbook to track changes. 9.) What does it mean that the right mouse button is "context-sensitive" - Answer-The menu items available will differ depending on the context of what you are right-clicking. 10.) You have data for Regions, Products, and Customers. Which option on a Pivot Table will you find in the Fields list - Answer-Regions 11.) While it might be considered "old-school," which action should you take if you are unsure how a page will print, even after looking at Page Break Preview - Answer-Print the first page.