1, 7 could have multiple answers 1) Before you can use Excel\'s Solver you need
ID: 3853278 • Letter: 1
Question
1, 7 could have multiple answers
1) Before you can use Excel's Solver you need
a. objective cells
b. changing variable cells
c. constraints
2) 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
3) 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
4) 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
5) 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
6) 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
7) You can use a password to protect a workbook from
a) being opened
b) being modified
c) being saved
8) 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
The answer is as follows:
1. Answer is all a,b,c
2. Answer is a) another name for a column header or label
3. Answer is b)a box that holds fields that filter the pivot table
4. Answer is c)a box that allows you to display each category of that item in its own row
5. Answer is d) a box that allows you to display each category of that item in its own column
6. Answer is d) none of the above.
7. Anaswer is a) and b)
8 Answer is d) There is nothing that can be done.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.