55 One of the great advantages of references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations. * formula relative absolute cell The IF function is a logical function that 59 returns one value if a condition is true, and returns a different value if that condition is false * True False ! Absolute references are marked with a 55 $ 5 55 Which of the following is not a comparison operator? * Samantha is a distributor of jewelry. She 55 uses Excel 2013 to record her inventory and order forms. Samantha's worksheet for her company's monthly orders needs to display summary information including the total number of items ordered and the amount of revenue generated from those orders. Samantha wants to find out how much money she will make on her largest order, which is currently in row E. Cell E4 contains the number of items ordered and cell E5 contains the price per item. An appropriate formula would be =E5/E4 =E44E5 =E4*E5 =E4+E5 55 One of the great advantages of references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations. * formula relative absolute cell The IF function is a logical function that 59 returns one value if a condition is true, and returns a different value if that condition is false * True False ! Absolute references are marked with a 55 $ 5 55 Which of the following is not a comparison operator? * Samantha is a distributor of jewelry. She 55 uses Excel 2013 to record her inventory and order forms. Samantha's worksheet for her company's monthly orders needs to display summary information including the total number of items ordered and the amount of revenue generated from those orders. Samantha wants to find out how much money she will make on her largest order, which is currently in row E. Cell E4 contains the number of items ordered and cell E5 contains the price per item. An appropriate formula would be =E5/E4 =E44E5 =E4*E5 =E4+E5