Q$1.$ Give us an example of when you might use an absolute cell reference. Give your example or form it as a question, and then "translate it$"$ into Excel.

Don't use the eText or MindTap$/$SAM example or my example.

Example: I want to know how much a pizza and a side of garlic knots will cost if I use my $10\%$ discount code. The regular price of the pizza is in A$5,$ the garlic knots are in A$6.$ The discount is in B$2$ and is formatted as a percent and my result will be in B$5$ and B$6.$ I want to create the formula in B$5$ and then copy it to B$5.$

For B$5,$ the formula would be the price of the pizza minus the $10\%$ discount. One way to calculate the discount is the price $*$ the discount. That would then work out to

$=$A$5-($A$5-$$B$$)$

Q$2.$ Give an example of when you might use an IF function. Give your example or form it as a question, and then "translate it$"$ into Excel. Don't use the eText or MindTap$/$SAM example or my example.

Example: We're going to have some type of precipitation. If the temperature is $32$ degrees F or below, we'll get snow. If it's above $32$ degrees F$,$ it will rain. The temperature is in A$15$ and the formula goes in B$15.$

The format for an IF function is IF $($test$,$ true, false$)$

If the temperature is equal to or less than $32$

TRUE $=$ "Snow"

FALSE $=$ "Rain"

The formula would then be $=$ IF $($A$15<=32,$ "Snow", "Rain"$)$

Q$3.$ A fun thing to try. You can enter your birthday in a cell and then format it as a "Long Date". Don't give us the actual date, but tell us what day of the week you were born. I was born on a Tuesday.