# 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

**View All Answers**

**Next Tests:**