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!