Identify the item highlighted by the red rectangle (pictured) Question 5 Not yet answered 22. Points out of 1.00 P Flag question Select one: O A. Tab Bar B. Name Box C. Formula Bar D. Ribbon Previous page Which function key displays the formula (or contents) of the active cell when selected?! Question 6 Not yet answered Points out of 1.00 P Flag question Select one: o A. F2 B.FI o C.F3 D. F4 which of the followings is the habit to avoid in modeling? Question 7 Not yet answered Points out of 1.00 P Flag question Select one: o A. Needlessly complex or long formulas B. Merged cells C. Inconsistent Formatting D. Hardcoded values O E. All of the above Question 8 Not yet answered Points out of 1.00 550 $ Salary 122,502 ID P Flag question 8 550 600 270 175 385 $ $ $ $ $ $ $ Salary 65,000 75,855 122,502 85,000 91,612 95,000 100,000 12 Which of the following formula can be used to find the value in B3? Select one: o A. =VLOOKUP(A3,A6:B12,1,0) o B. =VLOOKUP(A3,A6:B12,2,0) o C. =VLOOKUP(A3, A6:B12,1,1) o D. None of the above