MS Excel MCQ Questions and Answers Doc - Set 05 - ObjectiveBooks

MS Excel MCQ Questions and Answers Doc - Set 05

Practice Test: Question Set - 05


1. How many characters can be typed in a single cell in Excel?
    (A) 256
    (B) 1024
    (C) 32000
    (D) 65535

2. Tab scrolling button
    (A) Allow you to view a different worksheet
    (B) Allow you to view additional worksheet rows down
    (C) Allow you to view additional worksheet columns to the right
    (D) Allow you to view additional sheets tabs

3. The auto calculate feature
    (A) Can only add values in a range of cells
    (B) Provides a quick way to view the result of an arithmetic operation on a range of cells
    (C) Automatically creates formulas and adds them to a worksheet
    (D) Both A and C

4. Which of the following will not cut information?
    (A) Pressing Ctrl + C
    (B) Selecting Edit > Cut from the menu
    (C) Clicking the Cut button on the standard
    (D) Pressing Ctrl+X

5. How do you select an entire column?
    (A) Select Edit > Select > Column from the menu
    (B) Click the column heading letter
    (C) Hold down the shift key as you click anywhere in the column
    (D) Hold down the Ctrl key as you click anywhere in the column

6. How can you find specific information in a list?
    (A) Select Tools > Finder from the menu
    (B) Click the Find button on the standard toolbar
    (C) Select Insert > Find from the menu
    (D) Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button

7. Multiple calculations can be made in a single formula using
    (A) Standard formulas
    (B) Array formula
    (C) Complex formulas
    (D) Smart formula

8. When you link data maintained in an excel workbook to a word document
    (A) The word document cannot be edit
    (B) The word document contains a reference to the original source application
    (C) The word document must contain a hyperlink
    (D) The word document contains a copy of the actual data

9. Which of the following is the oldest spreadsheet package?
    (A) VisiCalc
    (B) Lotus 1-2-3
    (C) Excel
    (D) StarCalc

10. Excel files have a default extension of
    (A) Xls
    (B) Xlw
    (C) Wk1
    (D) 123

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests:


    Blogger Comment
    Facebook Comment