Multiple choice Questions on Spread Sheet Application - Set 01 - ObjectiveBooks

Multiple choice Questions on Spread Sheet Application - Set 01

Practice Test: Question Set - 01


1. Which option in MS Excel is used to display the rows that meet certain conditions?
    (A) Find
    (B) Filter
    (C) Format
    (D) Sort

2. Which function in Excel is used to find the biggest value in a range?
    (A) Ceiling
    (B) DMAX
    (C) LEN
    (D) MAX

3. Which function is used to add the values in a range?
    (A) Count()
    (B) Sum()
    (C) ABS()
    (D) Sumif()

4. Which function key is used to open save as dialogue box in MS Excel?
    (A) F2
    (B) F5
    (C) F7
    (D) F12

5. Which tool in MS Office is best for organizing data and making lists?
    (A) Access
    (B) Excel
    (C) Power Point
    (D) Word

6. What is the maximum limit of rows in MS Excel 2010?
    (A) 1084567
    (B) 1048567
    (C) 1048576
    (D) 1084576

7. Which type of key should combine with ctrl key to create a macro key in Excel?
    (A) Numeric
    (B) Alphabetic
    (C) Alphanumeric
    (D) Special characters

8. Which tab is used for creating, formatting and editing a spreadsheet?
    (A) Data
    (B) Home
    (C) Insert
    (D) Review

9. Which one of the following is a text function in MS Excel?
    (A) "MID()"
    (B) "NOW()"
    (C) "COUNT()"
    (D) "SIGN"

10. Which type of addressing is used to keep rows constant and column changes and vice versa while copying a formula from one area of the worksheet to another in Excel?
    (A) Mixed
    (B) General
    (C) Relative
    (D) Absolute

11. What is the maximum limit of column in MS Excel 2010?
    (A) 16384
    (B) 16438
    (C) 16843
    (D) 16348

12. Which tab is used to include pivot table, charts, and hyperlinks to a spread sheet?
    (A) Insert
    (B) Page Layout
    (C) Data
    (D) Review

13. Which view in Excel displays the pages exactly as they appear when printed?
    (A) Custom View
    (B) Full screen View
    (C) Page Break View
    (D) Page Layout view

14. Which one of the following is a ‘Date & Time’ function in Excel?
    (A) "FIND()"
    (B) "MOD()"
    (C) "NOW()"
    (D) "MID()"

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: