You have a table in Excel where column A contains employee I…
You have a table in Excel where column A contains employee IDs, and column B contains their department names. The table range is A2:B20. You want to display the department name for the employee ID entered in cell E2. Which of the following VLOOKUP formulas should you enter in cell F2?
Read DetailsBelow is a spreadsheet containing credit risk data. Below…
Below is a spreadsheet containing credit risk data. Below is the same spreadsheet, but now containing data in column F, classifying the checking account status has low, medium, or high. Which IF function could be entered in cell F2 to classify the checking account balance as low if it is less than $250, medium if it is at least $250 but less than $2000, and high otherwise? This will be used to drag the checking account status column down until cells F11 to classify the remaining checking and savings account balances.
Read Details