Practice Test	Project 3
INSTRUCTIONS: Answer each question below. Enter your name and click the 'Grade Test' button to receive a graded study guide. You will not get a grade until all questions are answered.

1.	Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called ____.  A: goal seeking  B: what-if analysis  C: sensitivity examination  D: what-if seeking
2.	A(n) ____ chart is used to show the relationship of the parts to a whole.  A: pie  B: 3-D  C: embedded  D: exploded
3.	When you cut cells using the Cut button, Excel copies the cells to the Office Clipboard, but does not remove the cells until you paste the cells in the destination area by clicking the ____ button.  A: Move  B: Complete  C: Execute  D: Paste
4.	Excel allows you to control the rotation angle, elevation, perspective, height, and angle of the axes of a chart by using the ____.  A: Chart Painter dialog box  B: Pie Chart Control box  C: Control tab  D: Format Chart Area dialog box
5.	Use the ____ function to enter the system date into a cell in the worksheet.  A: IF  B: NOW  C: GMT  D: DATE
6.	Text in a cell can be rotated counterclockwise by entering a number between 1º and ____ in the Alignment sheet in the Format Cells dialog box.  A: 10º  B: 45º  C: 90º  D: 180º
7.	The worksheet entries that determine the size of the slices in a pie chart are called the ____.  A: data series  B: pie data  C: data collection  D: chart data
8.	When you insert a row, the new row automatically inherits the format from ____.  A: the last row  B: the first row  C: the row below  D: the row above
9.	When creating panes in a worksheet, the bar going across the middle of the window is called the ____.  A: horizontal ruler  B: scroll bar  C: vertical split bar  D: horizontal split bar
10.	The ____ entry of the IF function is made up of two expressions and a comparison operator.  A: logical_test  B: value_if_true  C: value_if_false  D: value_if_equal
11.	The ____ is a reserved place in a computer's memory that allows you to collect text and graphic items from an Office document and then place them into any Office document.  A: Office Clipboard  B: Ribbon  C: Copy tab  D: Format Painter
12.	The underline format will underline ____.  A: the entire cell  B: only the characters in the cell  C: the entire row of cells  D: will draw a border around a cell
13.	To turn off Freeze Panes, click ____ on the Freeze Panes gallery.  A: Thaw Panes  B: Panes Off  C: Toggle Panes  D: Unfreeze Panes
14.	If you know the result you want a formula to produce, you can use ____ to determine the value of a cell on which a formula depends.  A: goal seeking  B: mixed cell referencing  C: what-if-analysis  D: drag-and-drop
15.	A formula using a(n) ____ reference instructs Excel to adjust the cell reference as it copies it to a destination area.  A: adjustable cell  B: absolute cell  C: mixed cell  D: relative cell
16.	Using the mouse to move or copy cells is called ____.  A: mouse copy  B: move and drop  C: drag and drop  D: mousing
17.	You can emphasize a slice of a pie chart by ____ it from the rest of the slices so it stands out.  A: offsetting  B: impacting  C: embedding  D: charting
18.	To specify an absolute reference in a formula, enter a(n) ____ before a column letter or a row number.  A: percent sign  B: apostrophe  C: dollar sign  D: tilde
19.	To copy a word, such as Monday, which Excel might interpret as the start of a series, hold down the ____ key while you drag the fill handle to a destination area.  A: SPACEBAR  B: F4  C: CTRL  D: SHIFT
20.	A pie chart with one or more slices offset from the main portion is called a(n) ____ pie chart.  A: exploded  B: detached  C: separated  D: highlighted
Enter your name and click the 'Grade Test' button.