01-Which what-if analysis tool is the best option for complex calculations requiring constrained
02-Which tools are best suited to calculate the impact of multiple interest rates on auto loan
Scenario Manager, one-variable data table
Q.1- A worksheet contains data for business that are sponsoring this years art
fest. The worksheet contains these columns in the sequence, business name,
address, city, state, and donation amount. What is the change in setting within
the subtotal dialog b
Spread Sheet CH#4
In order to put formula use he function and use Field name by " IF Function"
[Pay_Type]="Paid in Full"
1 . Click cell B2 and freeze the panes above and to the left of the active cell.
Click cell B2. On the View tab
3.Enter a formula in cell H8 to calculate the # of Pmt Periods for the first loan by multiplying the
Years by the Pmts Per Year using a mixed cell reference for the cell containing the Pmts Per
Year: =G8*B$5. Copy the formula in cell H8 d