Quiz

  1. 1
    Beginner

    You have the spreadsheet shown below and enter the following formula in C2: =IF(A2=“Juice”,B2,”Not Juice”) What is the result?

  2. 2
    Beginner

    You have the spreadsheet shown below and want to write a formula that will return the Sales $ for each row if the Product is Water or the Quantity is greater than 5, or a zero if not. What formula would you want to copy down from D2 to make this happen?

  3. 3
    Beginner

    You have the spreadsheet shown below. Which formula was entered in cell D2 and copied down?