16) Which keyboard shortcut can be used to copy cells down? O Control r Control d Shift d Shift r 17) Which function will move from the selected cell over a number of rows and/or columns based on what you specify? MATCH CONCATENATE MOVE OFFSET 18) In the Excel extract below, we want to build a Data Table that outputs the monthly mortgage payment at the following interest rate sensitivities. When creating the Data Table, what must be true? B 100,000 5.00% 360 536.82 1 Principle $ 2 Annual Interest Rate 3 Number of Payments 4 Monthly Payment $ 5 6 7 Interest Rate Assumptions $ 4.00% 4.50% 10 5.00% 11 5.50% 12 6.00% 536.82 8 9 13 Row Input is B2 Row Input is B4 Column Input is B2 Column Input is B4 19) Which function can be used to output the position of a particular character within a cell? FIND CHARACTER POSITION MATCH