Spread Sheet Application Objective Mock Test Practice Test - Set 03 - ObjectiveBooks

# Practice Test: Question Set - 03

1. Which one of the following is ‘no argument’ function?
(A) "Now()"
(B) "Lower()"
(C) "Max()"
(D) "IF()"

2. How does the single element in a worksheet known as in Excel?
(A) Cell
(B) Column
(C) Range
(D) Row

3. How columns are named in MS Excel?
(A) Alphabetically
(B) Numerically
(C) Alphanumerically
(D) Special characters

4. Which tab in Excel is used for proofing, protecting, and marking up a spread sheet?
(A) Formula
(B) Data
(C) Review
(D) View

5. What do you mean by A3,B13:B20,C7 reference in Excel?
(A) Range
(B) Union
(C) Formula
(D) General

6. What is the purpose 'Tab' key in MS Excel?
(A) Moves cell pointer to previous column
(B) Moves cell pointer to next column
(C) Moves cell pointer previous row
(D) Moves cell pointer next row

7. Which bar lies top of the window in Excel Screen?
(A) Status Bar
(B) Ruler
(C) Title Bar
(D) Scroll Bar

8. Which one of the following will starts with ‘=’ sign in Excel 2010?
(A) Data
(B) Text
(C) Numbers
(D) Formulas

9. Which function is used to count the number of cells that contain numbers, in a range?
(A) Count()
(B) Countif()
(C) Sum()
(D) Sumif()

10. Which symbol is used to execute formulas in MS Excel?
(A) "="
(B) " ' "
(C) "#"
(D) " " "

11. Which tab in Excel is used when importing, querying, outlining and subtotaling the data placed into a worksheet's data list?
(A) Formula
(B) Data
(C) Review
(D) Insert

12. What is the purpose of ‘Enter Key’ in MS Excel?
(A) Moves cell pointer to previous column
(B) Moves cell pointer to next column
(C) Moves cell pointer to previous row
(D) Moves cell pointer to next row

13. Which sequence of operation is used to insert the hidden formula bar in Excel worksheet?
(A) View-Show/hide-Formula bar
(B) Insert-show/hide-Formula bar
(C) Data-show/hide-Formula bar
(D) Home-show/hide-formula bar

Show and hide multiple DIV using JavaScript View All Answers

Next Tests:
Blogger Comment