Excel Essential Training (Office
365/Microsoft 365) Exam
Questions and Answers 100%
PASS
Which shortcuts can you use for Undo and Redo? - CORRECT 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? - CORRECT 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? - CORRECT
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? - CORRECT ANSWER-Add a blank column between Columns B
& C, click in cell A2 and select Sort.
365/Microsoft 365) Exam
Questions and Answers 100%
PASS
Which shortcuts can you use for Undo and Redo? - CORRECT 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? - CORRECT 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? - CORRECT
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? - CORRECT ANSWER-Add a blank column between Columns B
& C, click in cell A2 and select Sort.
