Excel Certification Exam

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 data 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.

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

Track Changes is located under the Customize Quick Access Toolbar.

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.

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

Ctrl and Shift

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

Regions

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

Use a light-color fill.

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

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

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 worksheet?

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

Which shortcuts can you use for Undo and Redo?

Ctrl+Z for Undo and Ctrl+Y for Redo

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.

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

You can track changes.

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

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

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 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.

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

from the arrow to the right of Font on the ribbon

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 manage the worksheet shown below 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 and C, click in cell A2, and select Sort.

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 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 shortcut can you use to rename a worksheet?

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

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

as a spreadsheet

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

Use slashes for dates and colons for time.