Excel Essential Training (Office 365/Microsoft 365)

You resurrected an old worksheet. It appears to contain most of the information that you need, but not all of it. Which step should you take next?

Check for data you have previously hidden.

You would like to filter your large worksheet down to only sales from January. Which action must you take before using the Filter feature?

Make sure your date has no empty rows or columns

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?

Print the first page.

You hide three worksheets in a workbook and need to unhide them. How can you accomplish this?

Right-click any visible sheet, then select which worksheet you want to Unhide.

What does it mean that the right mouse button is "context-sensitive"?

The menu item available will differ depending on the context of what you are right-clicking.

How can you access Track Changes in Microsoft Excel Office 365?

Track Changes is located under the Customize Quick Access Toolbar.

What is a good rule-of-thumb for using color backgrounds in a worksheet?

Use a light-color fill.

What is the best practice for entering dates and times in Excel?

Use slashes for dates and colons for time.

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?

Use the Filter option to filter by full time employees and use the Numbers filter to select greater than $45,000.

Why would you set up a workbook to be shared if you are the only one using the workbook?

You can track changes.

What statement is accurate in regards to sharing workbooks?

You must add the feature to the Quick Access Toolbar.

How does tracking changes relate to sharing a workbook in Excel?

You must share the workbook to track changes.

As you are working with a pivot table, you decide to change some of your source data. How will the pivot table recognize the change?

You will either have to click Refresh on the Analyze ribbon or click Alt + F5.

Although it is not a term Excel uses, how do most people think of Excel?

as a spreadsheet

You created a formula in cell C8. When you copy the formula into cell D8, which action are you taking?

You are changing the content in the formula to the content in cell D8.

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?

Add a blank column between Columns B & C, click in cell A2 and select Sort.

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?

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?

Click in the tab name of the worksheet, hold the Ctrl key, and drag the worksheet.

You are creating a chart using the data shown below. What is the best chart type and style to use in order to make the upward sales trend most obvious?

Create a line chart and make the chart more narrow than the default.

Which shortcuts can you use for Undo and Redo?

Ctrl + Z for Undo and Ctrl + Y for Redo

Which two keys are commonly used to move or insert data?

Ctrl and Shift

Which shortcut can you use to rename a worksheet?

Double-click the sheet tab, and then type the new name.

Which type of chart is preferable when you are dealing with a timeframe?

line chart

To use AutoSum with a row of four values, where must your cursor be to have the sum appear in the row if you have not highlighted the cells?

on the first empty cell to the right of the last cell containing a value

To freeze rows 1 and 2, and columns 1, 2, and 3, which cell should you highlight before selecting Freeze Panes?

row 3, column 4

You have data for Regions, Products, and Customers. Which option on a Pivot Table will you find in the Fields list?

Regions

Where can you access the format cell's Dialog Box launcher?

from the arrow to the right of Font on the ribbon