Microsoft Excel Objective Questions & Answers - ObjectiveBooks

Microsoft Excel Objective Questions & Answers

Practice Test: Question Set - 10

1. When a label is too long to fit within a worksheet cell, you typically must
    (A) Shorten the label
    (B) Increase the column width
    (C) Decrease the column width
    (D) Adjust the row height

2. You can use the horizontal and vertical scroll bars to
    (A) Split a worksheet into two panes
    (B) View different rows and columns edit the contents of a cell
    (C) Edit the contents of a cell
    (D) View different worksheets

3. Which area in an excel window allows entering values and formulas
    (A) Title bar
    (B) Menu bar
    (C) Formula bar
    (D) Standard toolbar

4. Which of the following is a popular DOS based spreadsheet package?
    (A) Word
    (B) Smart cell
    (C) Excel
    (D) Lotus 1-2-3

5. The Paste Special command lets you copy and paste:
    (A) Multiply the selection by a copied value
    (B) Cell comments
    (C) Formatting options
    (D) The resulting values of a formula instead of the actual formula

6. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
    (A) Press Ctrl +Home
    (B) Press Home
    (C) Press Shift + Home
    (D) Press Alt + Home

7. Files created with Lotus 1-2-3 have an extension
    (A) DOC
    (B) XLS
    (C) 123
    (D) WK1

8. Which of the following is not a worksheet design criterion?
    (A) Efficiency
    (B) Aditibility
    (C) Description
    (D) Clarity

9. Which symbol must all formula begin with?
    (A) =
    (B) +
    (C) (
    (D) @

10. Which of the following is not an example of a value?
    (A) 350
    (B) May 10, 2001
    (C) 0.57
    (D) Serial Number 50771

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests:

    Blogger Comment
    Facebook Comment