Exam 7: Excel

Colin inserted SmartArt using an Organizational Chart layout.How can he make the SmartArt look more distinctive?

Miley wants to perform the same calculations on four worksheets with identical structures.To group the worksheets and perform the task faster, she can make the change on one worksheet, right-click the worksheet tab, and then click Duplicate Changes on the shortcut menu.

Chen has a worksheet with a City column listing five cities and an Order ID column listing unique IDs for product orders.He wants to count the number of orders from Charlotte.Which of the following functions should he use?

After you circle invalid data on a worksheet, the circles remain in place until you correct the circle values.

To paste copied cell contents with values only, not including formatting, which of the following can you use?

If you want to combine data from multiple worksheets and display the results on another worksheet, you can summarize the data.

Which of the following can you do using the Name Manager dialog box? Select all the options that apply.

Nathan has recorded a few macros in a workbook and now wants to run one of them.Which dialog box should he open to select a macro and then run it?

What feature inserts a function that totals the cells above or to the left of the selected cell?

Which of the following boxes will you check after clicking on a table and then selecting Table Tools > Design, to add a total row to a table?

You can set only one language as the editing language in Excel.

Which of the following elements can you add to a chart to display a line representing the general direction in a data series?

Which of the following chart types shows the distribution of data grouped in bins?

To preserve an exact cell address in a copied formula, you can use a relative cell reference.

To paste a data range so that column data appears in rows and row data appears in columns, you can _____ the data using the Paste list arrow.

Which category do you select in the Excel Options dialog box to add the Power Pivot tab to the ribbon?

To paste only a copied cell's formats, you can click the Paste Options button and select the appropriate option.

When you run the Spell Checker in a workbook, Excel automatically checks the spelling in all worksheets at once.

Cora inserted a Check Box control in a worksheet.She wants to display the text TRUE in cell B17 when the control contains a checkmark.What property should she set?

Lydia entered row titles in the range A1:A10 and listed data next to it in the range B1:B10.Which Excel feature can she use to apply the text in the range A1:10 as defined names for the cells in the range B1:B10?