Spread Sheet Quiz Questions and Answers - Set 02 - ObjectiveBooks

Spread Sheet Quiz Questions and Answers - Set 02

Practice Test: Question Set - 02

1. Which function key is used to open goto dialogue box in MS Excel?
    (A) F2
    (B) F5
    (C) F7
    (D) F11

2. How rows are numbered in MS Excel?
    (A) Alphabetically
    (B) Numerically
    (C) Alphanumerically
    (D) Special characters

3. What type of software is MS Office?
    (A) Application Software
    (B) Operating System
    (C) Programming Language
    (D) System Software

4. Which bar is used to display the sheet information and insertion point location in MS Excel?
    (A) Ruler
    (B) Scroll Bar
    (C) Status Bar
    (D) Title Bar

5. Where does the result displays when a formula is entered in Excel?
    (A) Current Cell
    (B) Next Cell
    (C) Previous Cell
    (D) Formula Bar

6. Which option in Excel is used to rearrange the rows base on the content of a particular column?
    (A) Find
    (B) Filter
    (C) Sort
    (D) Format

7. Which key is used to make multiple lines in a single cell?

    (A) Alt + Enter

    (B) Tab + Enter

    (C) Ctrl + Enter

    (D) Shift + Enter

8. How Cells are named in MS Excel?
    (A) Alphabetically
    (B) Numerically
    (C) Alphanumerically
    (D) Special Character

9. What is the file extension of Excel 2010?
    (A) xls
    (B) xlsb
    (C) xlsm
    (D) xlsx

10. Which tab is used to change the display of worksheet area and the data it contains?
    (A) Page Layout
    (B) View
    (C) Data
    (D) Review

11. Which function is used to find the middle number in a range?
    (A) "MEDIAN()"
    (B) "MID()"
    (C) "TRIM()"
    (D) "MODE()"

12. Which key is used to move the insertion point to the beginning of the current sheet?
    (A) Page up
    (B) Home
    (C) Ctrl + page up
    (D) Ctrl + Home

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: