Exam 7: Excel

When you record a macro, Excel stores it as a VBA module attached to the workbook.

If a worksheet contains cells with blue fills of varying lengths representing the values, the cells most likely have ________ applied to them .

A _____ is a calculated named field in Power Pivot.

Which of the following properties can you change for a Command Button (ActiveX Control)?

Tanya wants to insert a form control and then assign a macro to it.Which of the following objects should she insert?

A(n) _____ is a specially formatted word, phrase, or graphic that, when clicked, displays a webpage.

Which of the following can you change in SmartArt? Select all the options that apply.

Which of the following is a predefined procedure that returns a value?

When you link an Excel chart to a PowerPoint slide, the chart always retains its original formatting.

Hannah is preparing to take out a mortgage to buy a house.She wants to compare the monthly payments for the loans she is considering, which have interest rates ranging from 3.5% to 5.25%.She can quickly fill in the values from 3.5% to 5.25% using a sequential series.

In the formula =SUM('San Francisco'!A6:D6), what do the single quotation marks around the worksheet reference indicate?

Before importing data into Excel, you can use the Power Query Editor to remove columns.

Which of the following are math & trig functions? Select all the options that apply.

Which of the following options should you select to have Excel update all formulas as you edit a worksheet?

To change theme effects, click the Effects button on the Page Layout tab, then select an effect from the gallery.