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.
What is the first step in creating an AVERAGEIF formula?
What is the first step in creating an AVERAGEIF formula?
What are Sparklines?
What are Sparklines?
To permanently remove a linked reference, click the _____ bu…
To permanently remove a linked reference, click the _____ button at the _____ dialog box.