Exam 7: Excel

You can change a table to a worksheet range by click the Change to Range button.

Caleb created a column chart that lists numbers from $50,000 to $0 on the left.What can he add to the chart to indicate that these are monthly revenue amounts?

You receive a worksheet in which the row numbers are 1, 2, 3, 5, 6.This means that row 4 is _____.

To ungroup worksheets after grouping them and working on them simultaneously, right-click any worksheet tab in the group and click Ungroup Sheets.

Where can you create a relationship between two Excel tables?

You need to add another product to your inventory worksheet, which shows product names in row A.Which of the following should you add?

The easiest way to insert the SUM function is to use the AutoSum button on the Home tab.

Melanie inserted a Clustered Column PivotChart, but a Clustered Bar PivotChart would work better for the data.What should she do?

Text files you can import into Excel use a(n) _____, a separator such as a space or comma between columns of data.

You must display the Visual Basic tab on the ribbon to insert form controls into a worksheet.

Which of the following conditional formatting types can you apply to use red fill to indicate cells that have higher values and green fill to indicate lower values?

If you save an Excel workbook on OneDrive, _____ saves versions of your workbook as you make changes.

Al wants to compare data in two worksheets of two different workbooks quickly by scrolling through both at the same time.Which of these should he click after turning on View Side by Side on the View Tab in the Windows group?

To perform an action based on whether an option button control is selected, you assign a macro to the form control.

When you distribute a workbook, you may want to encrypt it with a password to protect it.

In a two-input data table, you can vary the results in two cells and see the recalculated results.

To display the first four characters from a cell containing text, you can use the MID function.

In the formula =SUM('San Francisco'!A6:D6), the exclamation point is a(n) linked reference indicator.

Miguel wants to remove the outline from a worksheet containing grouped data.What does he need to do?

To select a single worksheet cell so you can work with it, which of the following would you do?