Match the Suffix to Its Meaning

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?

ADF scanner (automatic ______________________) or sheet feeder.  Enables a document to be fed through an ADF  similar to a copier; good for scanning multiple-page documents.

Another popular type of digital camera is a __________ which is a digital camera that attaches to a PC for use in transmitting live video or recording video. 

Which of the following interfaces can be used to connect a laser printer to a PC? (Choose 3) 

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.

What was our revenue and profit last quarter?” is an example of which type of analytics?

Which chart type is most appropriate for showing trends over time in Excel?

Which of the following best describes what happens when you drag a numeric field into the Values area of a PivotTable in Excel?

Using the picture below use meiosis to explain why these 2 siblings do not look exactly the same. Make sure to use the correct terms in your explanation.