BG-6

Q1. What does the VLOOKUP function do?

A. Looks up text that contain ‘v’

B. Checks whether text is the same in one cell as in the next

C. Finds related record

D. All the above

Q2. When you see a cell with a red triangle in the top right corner, what does this signify?

A. There is an error in the cell

B. There is a comment associated with the cell

C. The font color for text in the cell is red

D. A formula cannot be entered into the cell

Q3. The horizontal and vertical lines on a worksheet are called:

A. cells

B. sheets

C. block lines

D. gridlines

Q4. The intersection of a raw and column is known as

A. Cell

B. chart

C. Formula

D. Value

Q5. Which of the following defines a formula in excel ?

A. &

B. *

C. ^

D. =

Q6. Which of the following formula is not entered correctly?

A. =10+5

B. =5*9

C. 2+4

D. =10/2

Q7. Which among the following represents a range type cell reference in Excel?

A. (A10:A20)

B. (B10,B20)

C. (A10,A20)

D. A10 92

Q8. An excel workbook is a collection of

A. Workbooks

B. Worksheets

C. Charts

D. None of above

Q9. The keyboard shortcut for cut command is

A. Ctrl+C

B. Altl+C

C. Ctrl+X

D. Alt+V

Q10. What is a shortcut to insert the table?

A. CTRL+S

B. CTRL+T

C. CTRL+A

D. Alt+T