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
Next Tests: