Slicers allow you to
How can you remove protection from a worksheet?
How can you remove protection from a worksheet?
To test three different what-if conditions using the Scenari…
To test three different what-if conditions using the Scenario Manager, you must
The _____ Excel function calculates the principal portion of…
The _____ Excel function calculates the principal portion of a loan payment.
Which of these functions uses an argument containing multipl…
Which of these functions uses an argument containing multiple criteria?
A _____ is a preset formula.
A _____ is a preset formula.
If the Excel data being exported to Word will often change a…
If the Excel data being exported to Word will often change and you want to keep the Word document up to date, copy the data to the Clipboard in Excel, open Word, place the insertion point in the desired location,
To unlock cells, click the _____ in the Cells group on the H…
To unlock cells, click the _____ in the Cells group on the Home tab.
When viewing the results of a scenario at the Scenario Manag…
When viewing the results of a scenario at the Scenario Manager dialog box, click the _____ button to apply the current values.
To use data from a program that is not compatible with Excel…
To use data from a program that is not compatible with Excel, check the program’s export options for a(n) _____ file format.