MS Excel MCQ Questions and Answers pdf - Set 07 - ObjectiveBooks

MS Excel MCQ Questions and Answers pdf - Set 07

Practice Test: Question Set - 07

1. To create a formula, you can use:
    (A) Values but not cell references
    (B) Cell references but not values
    (C) Values or cell references although not both at the same time
    (D) Value and cell references

2. You can use the formula palette to
    (A) Format cells containing numbers
    (B) Create and edit formulas containing functions
    (C) Enter assumptions data
    (D) Copy a range of cells

3. Which of the following is not a valid data type in excel
    (A) Number
    (B) Character
    (C) Label
    (D) Date/time

4. How can you delete a record?
    (A) Delete the column from the worksheet
    (B) Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
    (C) Select Data > Delete Record from the menu
    (D) Click the Delete button on the Standard toolbar

5. Which menu option can be sued to split windows into two?
    (A) Format > window
    (B) View > window > split
    (C) Window > split
    (D) View > split

6. The chart wizard term data series refers to
    (A) A chart legend
    (B) A collection of chart data markers
    (C) A set of values you plot in a chart
    (D) A data label

7. A numeric value can be treated as a label value if it proceeds with
    (A) Apostrophe (&lsquo
    (B) Exclamation (!)
    (C) Hash (#)
    (D) Ampersand (&

8. You can activate a cell by
    (A) Pressing the Tab key
    (B) Clicking the cell
    (C) Pressing an arrow key
    (D) All of the above

9. When integrating word and excel, word is usually the
    (A) Server
    (B) Destination
    (C) Client
    (D) Both ‘b’ and ‘c’

10. Which button do you click to add up a series of numbers?
    (A) The autosum button
    (B) The Formula button
    (C) The quicktotal button
    (D) The total button

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: