8. An office worker would like to highlight, underline, or apply any other annotation, to any data in a range that satisfies a specified criterion (e.g., this criterion could be, a number less or equal to a specified value, etc.). An Excel command to perform this feature is the a. Conditional Formatting b. Cell Style C. Sort & Filter d. Data Analysis I 9. Excel has a command that summarize (0.g., adding) all numerical values from different worksheets and places the result in a specified cell(s) in a desired worksheet. This feature can be invoked by selecting the following a. Cell style b. Filter c. Queries d. Consolidate Question 11 is a continuation of question 10 below 10. To edit or delete names of already named cells, you would first click on the —_tab. a. Home b. Insert C. Formulas d. Data 11. And then you would select the_ _icon e. Math and trig f. Name Manager & Define Name h. Trace Precedents Question 13 and 14 are continuation of question 12 below. 12. Someone is in the process of making a bank loan. The Monthly Payment depends on two varlables: a) the interest rate, and b) the Number of months to pay the loan Now, the borrower wants to know what the monthly payment for ten different interest rates would be along with three different options for the total number of months to pay full loan. Manually, you would have to calculate:
