Excel

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 can _____ multiple sheets at the same time by _____ them first.

edit; grouping

Which action will edit locked cells in a protected worksheet

Enter the password to turn off the protection.

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 created a bar chart with the bars for the products and the colors for the salesperson. If you click Switch Row Column, what will happen?

The bars will change to salespeople, and the colors will change to products.

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.

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

by double-clicking the split line