Professor Grey is an instructor of COMM 499, an undergraduate course at the Faculty of Commerce at UFC that is open to all students regardless of their status. This means that even students with GRAD and UNCL status (in addition to those with UGRD status) are allowed to take the course. The grading system used for UNCL and UGRD students, however, is different from the grading system used for GRAD students. First, Professor Grey needs to complete column B of his class list (in an Excel spreadsheet) to assign each student to the correct four-letter Status. He wants to use a VLOOKUP function. Professor Grey intends to type up the formula in cell B2, and then drag the formula down to cell B15. The lookup table will be in F3:G5. Complete the lookup table F3:G5 below by entering appropriate values. Since F3:G5 is in an Excel worksheet, do not use double quotations when entering text in a cell. Do not leave any space or use $ sign. Also, do not use comma when entering a number. Multiple fill-in-the-blank

Log in for full answers

We've collected over 50,000 authentic original questions and detailed explanations from around the globe. Log in now and get instant access to the answers!

Similar Questions

More Practical Tools for Students Powered by AI Study Helper

Join us and instantly unlock extensive past papers & exclusive solutions to get a head start on your studies!