WALL STREET EXCEL EXAM QUESTIONS WITH 100% CORRECT ANSWERS

WALL STREET EXCEL EXAM QUESTIONS WITH 100% CORRECT ANSWERS Cells B1:B25 contain salaries. Write a formula to return the rank of cell B8, with the values ranked in ascending order. Answer RANK(B8, B1:B25, 1) Which Excel function counts the number of cells that have numerical data in them? Answer COUNT Cells A1:A4 contain the values 2, 5, 7, and 8. What does MEDIAN(A1:A4) return? Answer 6 Which formula will produce the sum of cells A3 in two worksheets named Vermont and New Hampshire? Answer Vermont!A3+'New Hampshire'!A3 When tracing the dependence on a cell in a worksheet, how can you tell whether a dependency for that cell exists in another worksheet? Answer A dotted black line points to an icon for a Sheet. Which sequence will add 5 to each number in cells A1, A2, and A3? Answer Enter 5 in cell A4. Select A4, select Ctrl+C, highlight cells A1-A3, select Ctrl+Alt+V, select Add, and then select OK. What is the third argument in an IF statement? Answer the return value if FALSE What is the result of this statement: IF(54 AND 45, 1, 2)? Answer 2 When using VLOOKUP to find an approximate match, which argument is the index number of the lookup column? Answer third Which value for the fourth argument will produce an exact match when using VLOOKUP? Answer false When searching cells A2:A300, which MATCH function will return the row number where a match to cell B1 is found? Answer MATCH(B1,A:A,0) Which Excel category contains the SWITCH function? Answer logical What is the correct function to show the formula in cell A2? Answer FORMULATEXT(A2) The combination of the MATCH and INDEX functions is referred to as a workaround for