Excel Module 2 PC

Question

1.) Cell A5 contains the number 24.7835. In another cell, Ariane wants to enter the number from cell A5 but rounded to two decimal places. Which of these formulas can she use to do so?

a	=MROUND(A5,2)
b	=ROUND(A5,2)
c	=MROUND(A5,0.2)
d	=ROUND(A5,2.0)

2.) Rohan can display the current date in a cell using the TODAY() function. T/F?

3.) Use Goal Seek to specify an output value and work backward to find the input value needed to reach that goal.

Answer 1

1. Answer b (d will also work). MROUND rounds based on the second argument; since it is 2, it rounds to the nearest even number, which is 24.00 in the case. The other MROUND answer rounds to the nearest 0.2, which for this case is 24.80. If you try =ROUND(A5,2.0), it will work, but the entry will lose the decimal places.
2. True. It will, however, change if you open the spreadsheet tomorrow or recalculate after midnight.
3. I have a Mac, and Goal Seek does not work. However, the Solver Add-In does.

Find Solver by going to Data / Analysis Tools. Check Solver if it isn't already included.

If your target calculation cell and cell to make changes to are on the same tab, go there first before clicking on Solver. Then set the objective cell and its target value, and the variable cell(s) to change to get to the target.

I can't show what things look like here (I tried), but it is reasonably self-explanatory.

I am keeping to the simple case here, so once your target and change cells are selected, click on Solve.

You will get another dialog box. You can then keep the solution or go back.