1, 3, 4, 5, 11 have mutiple answers 1) To use goal seek you need a. a cell that
ID: 3853263 • Letter: 1
Question
1, 3, 4, 5, 11 have mutiple answers
1) To use goal seek you need
a. a cell that contains a formula
b. a value that is the goal
c. a cell that contributes to the formula that you may change
2) Goal seek is used to answer
a) the direction to sort the data
b) a "what if" question
c) the time of the day
d) the score of a football game
3) After goal seek has found an answer you may
a. keep the new value
b. go back to the old value
c. keep both the old and the new values
4) You may use the scenarios feature to
a. change the values of various cells
b. save the changed values
c. compare differing scenarios
5) Before you can use Excel's Solver you need
a. objective cells
b. changing variable cells
c. constraints
6) In a PivotTable a field is a
a) another name for a column header or label
b) a box that holds fields that filter the pivot table
c) a box that allows you to display each category of that item in its own row
d) a box that allows you to display each category of that item in its own column
7) In a PivotTable a report filter is
a) another name for a column header or label
b) a box that holds fields that filter the pivot table
c) a box that allows you to display each category of that item in its own row
d) a box that allows you to display each category of that item in its own column
8) In a PivotTable a row label is
a. another name for a column header or label
b. a box that holds fields that filter the pivot table
c. a box that allows you to display each category of that item in its own row
d. a box that allows you to display each category of that item in its own column
9) In a PivotTable a column label is
a. another name for a column header or label
b. a box that holds fields that filter the pivot table
c. a box that allows you to display each category of that item in its own row
d. a box that allows you to display each category of that item in its own column
10) When sharing a workbook
a. protect it with a password
b. post its password on your FaceBook page
c. never use a password
d. none of the above
11) You can use a password to protect a workbook from
a) being opened
b) being modified
c) being saved
12) If you forget your workbook's password you can
a. call Microsoft and they will give you the default password
b. open it without the password as long as you are using the same computer
c. change the password to a new one that you can remember
d. There is nothing that can be done!
Explanation / Answer
1 - a, b, c
All three options are correct. This is how goal seek is applied in excel.
------
2 - Goal seek is used to answer hypothetical questions which are in the form of "what if". Basically we provide it a goal and it tries to find a solution to it.
So, answer is "what if" question. option b.
------
3 - you have the option to keep the old value or the new value. but you can't keep both.
So, answers are (a) and (b)
------
4 - It is used to compare different scenarios. This inturn may change the values. We may choose to keep the changed values or go back to old values.
So, all options are correct - (a) , (b), (c)
-----
Please ask the rest of the questions in a separate post. Thank you.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.