Excel

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

line chart

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

By right clicking the cell in which you are working

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

Which shortcut can you use to rename a worksheet?

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

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

Track Changes is located under the Customize Quick Access Toolbar.

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

Filters

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 shortcuts can you use for Undo and Redo?

Ctrl+Z for Undo and Ctrl + Y for redo

If you have a worksheet containing data you do not want to be sorted, what must you do before sorting?

Delineate the data you do not want to be sorted

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

Before you create a chart in Excel, how would you have the chart appear?

Remove any totals next to your data.

If you accidentally delete a sheet that you wanted to keep, which action should you take?

Retrieve the sheet from a saved version of the file.

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.

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

You are repeating the results obtained in cell C8 to the values in D8

You can _____ multiple sheets at the same time by _____ them first.

edit; grouping

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 an analytical tool

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

Use slashes for dates and colons for times

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

You can track changes

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

avoid using colors

How can you remove a split other than by clicking the Split button under View?

by double-clicking the split line

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

ctrl and shift