# Practice Test: Question Set - 06

**1. Which of the following is not information you can specify using the solver?**

- (A) Input cells

- (B) Constraints

- (C) Target cell

- (D) Changing
cells

**2. Excel worksheet cells work very similarly to what common element of the windows graphical user interface**

- (A) Option
buttons

- (B) List boxes

- (C) Text boxes

- (D) Combo boxes

**3. You can select a single range of cells by**

- (A) Clicking the
upper-left cell in a group of cells and then pressing the Shift key while
clicking the lower right cell in a group of cells

- (B) Pressing the
Ctrl key while dragging over the desired cells

- (C) Pressing the
Shift key and an arrow key

- (D) Dragging
over the desired cells

**4. To copy cell contents using drag and drop press the**

- (A) End key

- (B) Shift key

- (C) Ctrl key

- (D) Esc key

**5. Which of the following formulas will Excel Not be able to calculate?**

- (A) =SUM(Sales)-A3

- (B) =SUM(A1:A5)*.5

- (C) =SUM(A1:A5)/(10-10)

- (D) =SUM(A1:A5)-10

**6. Data can be arranged in a worksheet in a easy to understand manner using**

- (A) Auto
formatting

- (B) Applying
styles

- (C) Changing
fonts

- (D) All of above

**7. Which of the following is not a way to complete a cell entry?**

- (A) Pressing
enter

- (B) Pressing any
arrow key on the keyboard

- (C) Clicking the
Enter button on the Formula bar

- (D) Pressing
spacebar

**8. To create a formula, you first:**

- (A) Select the
cell you want to place the formula into

- (B) Type the
equals sign (=) to tell Excel that you’re about to enter a formula

- (C) Enter the
formula using any input values and the appropriate mathematical operators that
make up your formula

- (D) Choose the
new command from the file menu

**9. Which is used to perform what if analysis?**

- (A) Solver

- (B) Goal seek

- (C) Scenario
Manager

- (D) All of above

**10. When the formula bar is active, you can see**

- (A) The edit
formula button

- (B) The cancel
button

- (C) The enter
button

- (D) All of the
above

**View All Answers**

**Next Tests:**