Chapter 3, Problem 2.10CP

In cell C19, insert a formula that will calculate the projected advertising spending after the forecasted increase in cell A18 is added to the 2019 total. Ensure that the reference to cell A18 is an absolute cell reference.

Question 1 Use Index and math functions to fill in a table that extracts the amounts shipped between each pair of cities in Excel file General Appliance Corporation your table should display as follows and the formula for the amount should reference the names in the From and To columns From To Amount Marrietta Cleveland 0 Marrietta Baltimore 350 Marrietta Chicago 0 Marrietta Phoneix 850 Minneapolis Cleveland 150 Minn. Baltimore 0 Minn. Chicago 500 Minn. Phoneix 150 Full explainthe  this question very fast solution sent me step by step Don't ignore any part all part work u  A to CText typing work only not allow paper work

On the Sales Data worksheet, calculate the commission rate and commission paid for each sales associate.  Beginning in cell F4, enter a formula using the IFS function to calculate the commission rate based on the following table. Hint: Do not include comma separators in numerical values in formulas. Excel interprets commas as function argument separators.