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()"
Next Tests: