MCQ for Microsoft Excel - Set 06 - ObjectiveBooks

MCQ for Microsoft Excel - Set 06

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

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: