EXCEL CRASH EXAM.pdf file:///C:/Users/HP/Desktop/New%20folder%20(4)/EXCEL%20CR
Excel Crash Exam Questions & Answers
1. What shortcuts can you do for redo and undo
Answer
2. 1.) Which shortcuts can you use for Undo and Redo
Answer Ctrl+Z for Undo and Ctrl+Y for Redo
3. 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.
4. 3.) What statement is accurate in regards to sharing workbooks
Answer You must add the feature to the Quick Access Toolbar.
1/7
1 of 7 10/24/2024, 8:03
,EXCEL CRASH EXAM.pdf file:///C:/Users/HP/Desktop/New%20folder%20(4)/EXCEL%20CR
5. 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.
6. 5.) How can you access Track Changes in Microsoft Excel Office 365
Answer Track Changes is located under the Customize Quick Access Toolbar.
7. 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.
8. 7.) Although it is not a term Excel uses, how do most people think of
Excel
Answer as a spreadsheet
9. 8.) How does tracking changes relate to sharing a workbook in Excel
Answer You must share the workbook to track changes.
2/7
2 of 7 10/24/2024, 8:03
Excel Crash Exam Questions & Answers
1. What shortcuts can you do for redo and undo
Answer
2. 1.) Which shortcuts can you use for Undo and Redo
Answer Ctrl+Z for Undo and Ctrl+Y for Redo
3. 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.
4. 3.) What statement is accurate in regards to sharing workbooks
Answer You must add the feature to the Quick Access Toolbar.
1/7
1 of 7 10/24/2024, 8:03
,EXCEL CRASH EXAM.pdf file:///C:/Users/HP/Desktop/New%20folder%20(4)/EXCEL%20CR
5. 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.
6. 5.) How can you access Track Changes in Microsoft Excel Office 365
Answer Track Changes is located under the Customize Quick Access Toolbar.
7. 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.
8. 7.) Although it is not a term Excel uses, how do most people think of
Excel
Answer as a spreadsheet
9. 8.) How does tracking changes relate to sharing a workbook in Excel
Answer You must share the workbook to track changes.
2/7
2 of 7 10/24/2024, 8:03
