Part 1: Copy and paste the following link into your web browser: https://www.you

Question

Part 1: Copy and paste the following link into your web browser:

https://www.youtube.com/watch?v=iKN-QpBLkyM

Listen and watch the video to understand how to use the IF() function. Then, write the formulas as indicated for columns C, E and F of the worksheet (directions are also included in spreadsheet).

Part 2: Copy and paste the following link into your web browser:

http://computers.tutsplus.com/tutorials/how-to-extract-data-from-a-spreadsheet-using-vlookup-match-andindex--cms-20641

Using the Source Data, Sales Amounts, Match and Index worksheets, watch and follow along with the training video to use the VLOOKUP, MATCH and INDEX functions on the worksheets as instructed.

This is the link to the Excel sheet in which the solutions are to be carried.

https://blackboard.utdl.edu/bbcswebdav/pid-4843527-dt-content-rid-17443555_1/xid-17443555_1

Explanation / Answer

The Excel sheet link is asking authorization i.e. user name and password.

=IF function can be used to impose a condition in the excel. For example, if one wants to take only the positive value from column-C, one can write "=IF(C1>0,C1,0)". Copying this formula in any cell will give the either the positive value or zero.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects