Microsoft Excel MCQs with Answers - Set 02 - ObjectiveBooks
Microsoft Excel MCQs with Answers - Set 02

Microsoft Excel MCQs with Answers - Set 02

Practice Test: Question Set - 02

1. It is acceptable to let long text flow into adjacent cells on a worksheet when
    (A) Data will be entered in the adjacent cells
    (B) No data will be entered in the adjacent cells
    (C) There is no suitable abbreviation of the text
    (D) There is not time to format the next
2. Documentation should include
    (A) Destination and users of the output data
    (B) Source of input data
    (C) Information on the purpose of the workbook
    (D) All of the above
3. When you copy a formula
    (A) Excel erases the original copy of the formula
    (B) Excel edits cell references in the newly copied formula
    (C) Excel adjusts absolute cell references
    (D) Excel doesn’t adjust relative cell references
4. What symbol is used before a number to make it a label?
    (A) ” (quote)
    (B) = (equal)
    (C) _ (underscore)
    (D) ‘ (apostrophe)
5. A typical worksheet has ________ Number of columns
    (A) 128
    (B) 256
    (C) 512
    (D) 1024
6. The Chart wizard term data categories refers to;
    (A) A chart plot area
    (B) A horizontal axis
    (C) The organization of individual values with a chart’s data series
    (D) The data range that supply chart data
7. Concatenation of text can be done using
    (A) Apostrophe (&lsquo
    (B) Exclamation (!)
    (C) Hash (#)
    (D) Ampersand (&
8. Which of the following methods cannot be used to enter data in a cell?
    (A) Pressing an arrow key
    (B) Pressing the Tab key
    (C) Pressing the Esc key
    (D) Clicking on the formula bar
9. How do you insert a row?
    (A) Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
    (B) Select the row heading where you want to insert the new row and select Edit >Row from the menu
    (C) Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
    (D) All of the above
10. When you insert an excel file into a word document. The data are
    (A) Hyperlinked placed in a word table
    (B) Linked
    (C) Embedded
    (D) Use the word menu bar and toolbars
Show and hide multiple DIV using JavaScript View All Answers
 Next Tests: